MCQ Collection
Advance Database Management Systems MCQs
Practice Advance Database Management Systems questions with answers and explanations.
Choose an option to check your answer.
A.
every table must have exactly one column
B.
only DBA users can run SELECT
C.
records must always be sorted by date
D.
foreign key values must match referenced primary key values or be null when allowed
Show Answer
Correct Answer: D. foreign key values must match referenced primary key values or be null when allowed
Explanation:
referential integrity is used in Advanced DBMS because foreign key values must match referenced primary key values or be null when allowed.
Choose an option to check your answer.
A.
a statement used to give privileges to users or roles
B.
a statement used to roll back a crash
C.
a statement used to physically defragment disks
D.
a statement used only to create loops
Show Answer
Correct Answer: A. a statement used to give privileges to users or roles
Explanation:
This statement is correct because GRANT statement means that a statement used to give privileges to users or roles.
Choose an option to check your answer.
A.
writing marketing content for a database product
B.
drawing only conceptual ER diagrams
C.
assigning usernames to employees only
D.
deciding storage structures, indexes, partitions, and access paths for performance
Show Answer
Correct Answer: D. deciding storage structures, indexes, partitions, and access paths for performance
Explanation:
The correct answer explains physical database design in the context of Physical Design and Tuning.
Choose an option to check your answer.
A.
splitting a relation by columns only
B.
splitting a relation by rows using predicates
C.
encrypting each tuple independently
D.
copying the whole relation at every site
Show Answer
Correct Answer: B. splitting a relation by rows using predicates
Explanation:
horizontal fragmentation is used in Advanced DBMS because splitting a relation by rows using predicates.
Choose an option to check your answer.
A.
only DBA users can run SELECT
B.
every table must have exactly one column
C.
records must always be sorted by date
D.
foreign key values must match referenced primary key values or be null when allowed
Show Answer
Correct Answer: D. foreign key values must match referenced primary key values or be null when allowed
Explanation:
This statement is correct because referential integrity means that foreign key values must match referenced primary key values or be null when allowed.
Choose an option to check your answer.
A.
a statement used to create a backup image
B.
a statement used to start a cursor
C.
a statement used only for sorting rows
D.
a statement used to remove privileges from users or roles
Show Answer
Correct Answer: D. a statement used to remove privileges from users or roles
Explanation:
The correct answer explains REVOKE statement in the context of Database Administration.
Choose an option to check your answer.
A.
writing marketing content for a database product
B.
deciding storage structures, indexes, partitions, and access paths for performance
C.
assigning usernames to employees only
D.
drawing only conceptual ER diagrams
Show Answer
Correct Answer: B. deciding storage structures, indexes, partitions, and access paths for performance
Explanation:
physical database design is used in Advanced DBMS because deciding storage structures, indexes, partitions, and access paths for performance.
Choose an option to check your answer.
A.
splitting a relation by columns only
B.
copying the whole relation at every site
C.
encrypting each tuple independently
D.
splitting a relation by rows using predicates
Show Answer
Correct Answer: D. splitting a relation by rows using predicates
Explanation:
This statement is correct because horizontal fragmentation means that splitting a relation by rows using predicates.
Choose an option to check your answer.
A.
the DBMS manages pages between disk and memory to reduce I/O cost
B.
the DBMS disables transactions
C.
the DBMS stores all data permanently in CPU registers
D.
the DBMS removes indexes from all tables
Show Answer
Correct Answer: A. the DBMS manages pages between disk and memory to reduce I/O cost
Explanation:
This statement is correct because buffer management means that the DBMS manages pages between disk and memory to reduce I/O cost.
Choose an option to check your answer.
A.
security privileges decide join order
B.
queries are executed without statistics
C.
query plans are compared using estimated costs such as I/O, CPU, and cardinality
D.
query plans are chosen alphabetically
Show Answer
Correct Answer: C. query plans are compared using estimated costs such as I/O, CPU, and cardinality
Explanation:
The correct answer explains cost-based optimization in the context of Query Processing.
Choose an option to check your answer.
A.
a method that blocks all transactions
B.
a method that replicates data across sites
C.
a data access method that reads all rows of a table
D.
a method that reads only index leaf entries
Show Answer
Correct Answer: C. a data access method that reads all rows of a table
Explanation:
full table scan is used in Advanced DBMS because a data access method that reads all rows of a table.
Choose an option to check your answer.
A.
Microsoft SQL Server’s extension of SQL for procedural programming and administration
B.
a lock mode for dirty reads
C.
a hardware protocol for disk mirroring
D.
a document-oriented NoSQL model only
Show Answer
Correct Answer: A. Microsoft SQL Server’s extension of SQL for procedural programming and administration
Explanation:
This statement is correct because T-SQL means that Microsoft SQL Server’s extension of SQL for procedural programming and administration.
