Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
tracking database activities to support accountability and security monitoring
B.
randomly deleting old transaction logs
C.
fragmenting records across sites
D.
estimating join cardinality
Show 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.
A.
estimating join cardinality
B.
fragmenting records across sites
C.
tracking database activities to support accountability and security monitoring
D.
randomly deleting old transaction logs
Show 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.
A.
randomly deleting old transaction logs
B.
fragmenting records across sites
C.
tracking database activities to support accountability and security monitoring
D.
estimating join cardinality
Show 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.
A.
a two-phase commit coordinator
B.
a trigger that fires before insert
C.
a stored query result that can be refreshed to improve performance
D.
a password-protected window in the DBMS
Show Answer
Correct Answer: C. a stored query result that can be refreshed to improve performance
Explanation:
This statement is correct because materialized view means that a stored query result that can be refreshed to improve performance.
Choose an option to check your answer.
A.
a stored query result that can be refreshed to improve performance
B.
a two-phase commit coordinator
C.
a password-protected window in the DBMS
D.
a trigger that fires before insert
Show Answer
Correct Answer: A. a stored query result that can be refreshed to improve performance
Explanation:
materialized view is used in Advanced DBMS because a stored query result that can be refreshed to improve performance.
Choose an option to check your answer.
A.
a stored query result that can be refreshed to improve performance
B.
a password-protected window in the DBMS
C.
a two-phase commit coordinator
D.
a trigger that fires before insert
Show Answer
Correct Answer: A. a stored query result that can be refreshed to improve performance
Explanation:
The correct answer explains materialized view in the context of Database Administration.
Choose an option to check your answer.
A.
a view through which certain changes can be propagated to base tables when conditions allow
B.
a view that can never be queried
C.
a view used only for recovery logs
D.
a view with no SELECT statement
Show Answer
Correct Answer: A. a view through which certain changes can be propagated to base tables when conditions allow
Explanation:
This statement is correct because updatable view means that a view through which certain changes can be propagated to base tables when conditions allow.
Choose an option to check your answer.
A.
a view through which certain changes can be propagated to base tables when conditions allow
B.
a view that can never be queried
C.
a view used only for recovery logs
D.
a view with no SELECT statement
Show Answer
Correct Answer: A. a view through which certain changes can be propagated to base tables when conditions allow
Explanation:
updatable view is used in Advanced DBMS because a view through which certain changes can be propagated to base tables when conditions allow.
Choose an option to check your answer.
A.
a view through which certain changes can be propagated to base tables when conditions allow
B.
a view used only for recovery logs
C.
a view with no SELECT statement
D.
a view that can never be queried
Show Answer
Correct Answer: A. a view through which certain changes can be propagated to base tables when conditions allow
Explanation:
The correct answer explains updatable view in the context of Database Administration.
Choose an option to check your answer.
A.
a mandatory password policy
B.
a physical disk partition only
C.
a virtual table derived from one or more base tables
D.
a backup copy of all indexes
Show Answer
Correct Answer: C. a virtual table derived from one or more base tables
Explanation:
This statement is correct because view means that a virtual table derived from one or more base tables.
Choose an option to check your answer.
A.
a physical disk partition only
B.
a backup copy of all indexes
C.
a virtual table derived from one or more base tables
D.
a mandatory password policy
Show Answer
Correct Answer: C. a virtual table derived from one or more base tables
Explanation:
view is used in Advanced DBMS because a virtual table derived from one or more base tables.
Choose an option to check your answer.
A.
a virtual table derived from one or more base tables
B.
a physical disk partition only
C.
a backup copy of all indexes
D.
a mandatory password policy
Show Answer
Correct Answer: A. a virtual table derived from one or more base tables
Explanation:
The correct answer explains view in the context of Database Administration.
