Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q311: Which SQL statement shows all indexes created by the currently logged in user schema?
- A: SELECT * FROM user_indexes;
- B: SELECT * FROM indexes;
- C: SELECT * FROM user_IND_COLUMNS;
- D: SELECT * FROM all_indexes;
View Answer
A
Q312: What will be displayed by the SQL statement "SELECT * FROM user_IND_COLUMNS"?
- A: All indexes created by the user
- B: All columns of indexes created by the user
- C: All rows in the index table
- D: All data entries in the index table
View Answer
B
Q313: The index table or structure in a database contains which of the following columns?
- A: Key values and row ID
- B: Only the key values
- C: Only the row ID
- D: The actual data and row ID
View Answer
A
Q314: Fill in the blank: The basic syntax for creating an index in Oracle is CREATE INDEX index_name ________ (column_name).
- A: ON
- B: OFF
- C: ALONG
- D: ACROSS
View Answer
A
Q315: Fill in the blank: The data in the index table is sorted ________ in alphabetical order.
- A: ascending
- B: descending
- C: by ID
- D: randomly
View Answer
A
Q316: What is a transaction in the context of a database?
- A: A sequence of unrelated operations
- B: A single logical unit of work
- C: A single operation executed manually
- D: An automatic database backup
View Answer
B
Q317: Which property of a transaction ensures that either all operations are completed or none are?
- A: Consistency
- B: Isolation
- C: Atomicity
- D: Durability
View Answer
C
Q318: If a transaction fails midway, which property ensures that previous operations are rolled back?
- A: Consistency
- B: Atomicity
- C: Isolation
- D: Durability
View Answer
B
Q319: Which property ensures that the database remains in a consistent state before and after a transaction?
- A: Atomicity
- B: Isolation
- C: Consistency
- D: Durability
View Answer
C
Q320: During a transaction, which property ensures that no other transaction can interfere with its operations?
- A: Isolation
- B: Consistency
- C: Durability
- D: Atomicity
View Answer
A