DBMS Basics for Students Multiple Choice Questions (MCQ) PDF - 372

MCQ 1856: A memory area holding the data dictionary information is known to be

1. Data declaration cache
2. Data declaration log
3. Data dictionary log
4. Data dictionary cache

MCQ 1857: The term that must be dynamically loaded in order to access the database from Java, is known to be

1. JDBC manager
2. JDBC host
3. JDBC administrator
4. JDBC driver

MCQ 1858: Triggers can be used to implement certain

1. Integrity constraint
2. Atomicity
3. Isolation
4. Statements

MCQ 1859: The authorization identifier of the SQL environment is also known as

1. Identifier
2. Author
3. Manager
4. Schema

MCQ 1860: A view is updatable, if any attribute not listed in the select clause can be set to null and is not part of

1. Primary key attribute
2. Candidate key attribute
3. Foreign key attribute
4. Unique key attribute