Top 150+ Solved Advanced Database Management Systems (ADBMS) MCQ Questions Answer
Q. Changing cardinalities in a database is:
a. a common database design task.
b. a rare database design task, but does occur.
c. a database design task that never occurs.
d. is impossible to do, so a new database must be constructed and the data moved into it.
Q. The SQL keyword(s) ________ is used with wildcards.
a. LIKE only
b. IN only
c. NOT IN only
d. IN and NOT IN
Q. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
a. the primary key
b. any alternate key
c. a surrogate key
d. a foreign key
Q. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
a. Two
b. Three
c. Four
d. Six
Q. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
a. The line numbers reported match the line numbers you see in your text editor.
b. SQL*Plus will automatically show the errors to you.
c. To see the errors, enter SHOW ERRORS in SQL*Plus.
d. If there are no syntax errors, you will receive the message "NO ERRORS."
Q. Which of the following is not true about indexes?
a. Indexes are created to enforce uniqueness on columns.
b. Indexes are created to enable fast retrieval by column values.
c. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
d. Indexes are created with the ALTER TABLE comman