Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q291: Which of the following is NOT a typical use of a data dictionary?
- A: Accessing data about schema objects
- B: Modifying data definitions
- C: Providing direct access to the base tables
- D: Serving as a read-only reference
View Answer
C
Q292: What does the SQL statement `SELECT * FROM user_tables;` display?
- A: All relational tables accessible to the user
- B: All tables owned by the current user
- C: All constraint definitions on tables
- D: All data dictionary views
View Answer
B
Q293: What is a sequence used for in Oracle databases?
- A: Generating unique auto-number values on demand
- B: Storing large amounts of data
- C: Backing up database tables
- D: Encrypting database information
View Answer
A
Q294: What is the purpose of the `MINVALUE` clause in a sequence?
- A: Specify the maximum value of the sequence
- B: Specify the interval between sequence numbers
- C: Specify the minimum value of the sequence
- D: Specify how many values to cache
View Answer
C
Q295: What does the `START WITH` clause define in a sequence?
- A: The first sequence number to be generated
- B: The maximum value the sequence can generate
- C: The number of values to cache
- D: The interval between sequence numbers
View Answer
A
Q296: How does the `INCREMENT BY` clause affect a sequence?
- A: It defines the interval between sequence numbers
- B: It specifies the minimum value of the sequence
- C: It sets the maximum value of the sequence
- D: It determines how many values are cached
View Answer
A
Q297: What does the `CACHE` clause do in a sequence?
- A: It specifies how many values to pre-allocate and keep in memory for faster access
- B: It determines the maximum value of the sequence
- C: It defines the starting value of the sequence
- D: It sets the increment interval
View Answer
B
Q298: What is the effect of the `CYCLE` option in a sequence?
- A: The sequence continues generating values after reaching its maximum or minimum value
- B: The sequence stops generating values after reaching its maximum or minimum value
- C: The sequence value is reset to zero after reaching its maximum value
- D: The sequence automatically increments by two values instead of one
View Answer
A
Q299: What will happen if you use the `NO CYCLE` option in a sequence?
- A: The sequence will stop generating values after reaching its maximum or minimum value
- B: The sequence will generate values continuously without interruption
- C: The sequence will reset to its minimum value after reaching its maximum value
- D: The sequence will automatically start from zero again
View Answer
B
Q300: What does the `CREATE SEQUENCE customers_seq START WITH 1000 INCREMENT BY 1 NOCACHE NOCYCLE;` statement do?
- A: Creates a sequence starting at 1000, incrementing by 1, with no caching and no cycling
- B: Creates a table with customer ID numbers starting at 1000, incrementing by 1
- C: Creates a view with customer data starting at 1000, incrementing by 1
- D: Creates a stored procedure with a sequence starting at 1000, incrementing by 1
View Answer
A