Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: B. primary key values must be unique and not null
Explanation:
entity integrity is used in Advanced DBMS because primary key values must be unique and not null.
Choose an option to check your answer.
Correct Answer: C. assigning permissions to roles and assigning roles to users
Explanation:
This statement is correct because role management means that assigning permissions to roles and assigning roles to users.
Choose an option to check your answer.
Correct Answer: C. tracking database activities to support accountability and security monitoring
Explanation:
The correct answer explains database audit in the context of Integrity and Security.
Choose an option to check your answer.
Correct Answer: B. dividing a large table or index into smaller manageable pieces
Explanation:
partitioning is used in Advanced DBMS because dividing a large table or index into smaller manageable pieces.
Choose an option to check your answer.
Correct Answer: D. primary key values must be unique and not null
Explanation:
This statement is correct because entity integrity means that primary key values must be unique and not null.
Choose an option to check your answer.
Correct Answer: C. a statement used to give privileges to users or roles
Explanation:
The correct answer explains GRANT statement in the context of Database Administration.
Choose an option to check your answer.
Correct Answer: C. tracking database activities to support accountability and security monitoring
Explanation:
database audit is used in Advanced DBMS because tracking database activities to support accountability and security monitoring.
Choose an option to check your answer.
Correct Answer: A. dividing a large table or index into smaller manageable pieces
Explanation:
This statement is correct because partitioning means that dividing a large table or index into smaller manageable pieces.
Choose an option to check your answer.
Correct Answer: B. foreign key values must match referenced primary key values or be null when allowed
Explanation:
The correct answer explains referential integrity in the context of Integrity and Security.
Choose an option to check your answer.
Correct Answer: A. a statement used to give privileges to users or roles
Explanation:
GRANT statement is used in Advanced DBMS because a statement used to give privileges to users or roles.
Choose an option to check your answer.
Correct Answer: A. tracking database activities to support accountability and security monitoring
Explanation:
This statement is correct because database audit means that tracking database activities to support accountability and security monitoring.
Choose an option to check your answer.
Correct Answer: A. splitting a relation by rows using predicates
Explanation:
The correct answer explains horizontal fragmentation in the context of Distributed Databases.
