Managing Databases with Oracle
Q. What is the purpose of a transaction in a DBMS?
-
A.
To store data
-
B.
To ensure data integrity
-
C.
To create indexes
-
D.
To define schemas
Solution
The purpose of a transaction in a DBMS is to ensure data integrity by grouping operations that must all succeed or fail together.
Correct Answer: B — To ensure data integrity
Q. What is the purpose of normalization in databases?
-
A.
To increase redundancy
-
B.
To reduce data anomalies
-
C.
To improve performance
-
D.
To simplify queries
Solution
The purpose of normalization in databases is to reduce data anomalies and ensure data integrity.
Correct Answer: B — To reduce data anomalies
Q. What SQL command is used to retrieve data from a database?
-
A.
SELECT
-
B.
GET
-
C.
FETCH
-
D.
RETRIEVE
Solution
The SELECT command is used to retrieve data from a database in SQL.
Correct Answer: A — SELECT
Q. Which component of a DBMS is responsible for managing data storage?
-
A.
Query Processor
-
B.
Storage Manager
-
C.
Transaction Manager
-
D.
Buffer Manager
Solution
The Storage Manager is responsible for managing data storage in a DBMS.
Correct Answer: B — Storage Manager
Q. Which indexing method allows for faster retrieval of data?
-
A.
Sequential Indexing
-
B.
Hash Indexing
-
C.
B-Tree Indexing
-
D.
Bitmap Indexing
Solution
B-Tree Indexing allows for faster retrieval of data due to its balanced tree structure.
Correct Answer: C — B-Tree Indexing
Showing 1 to 5 of 5 (1 Pages)
