Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
compressing every page before backup
B.
granting users permitted operations on database objects
C.
choosing a join algorithm
D.
reordering projections in a query
Show Answer
Correct Answer: B. granting users permitted operations on database objects
Explanation:
This statement is correct because authorization means that granting users permitted operations on database objects.
Choose an option to check your answer.
A.
reordering projections in a query
B.
choosing a join algorithm
C.
compressing every page before backup
D.
granting users permitted operations on database objects
Show Answer
Correct Answer: D. granting users permitted operations on database objects
Explanation:
authorization is used in Advanced DBMS because granting users permitted operations on database objects.
Choose an option to check your answer.
A.
reordering projections in a query
B.
choosing a join algorithm
C.
compressing every page before backup
D.
granting users permitted operations on database objects
Show Answer
Correct Answer: D. granting users permitted operations on database objects
Explanation:
The correct answer explains authorization in the context of Integrity and Security.
Choose an option to check your answer.
A.
a transaction must use two-phase commit
B.
a table must be stored on a web domain
C.
an attribute value must come from a permitted domain or range
D.
a query must run only on Sunday
Show Answer
Correct Answer: C. an attribute value must come from a permitted domain or range
Explanation:
This statement is correct because domain constraint means that an attribute value must come from a permitted domain or range.
Choose an option to check your answer.
A.
an attribute value must come from a permitted domain or range
B.
a table must be stored on a web domain
C.
a transaction must use two-phase commit
D.
a query must run only on Sunday
Show Answer
Correct Answer: A. an attribute value must come from a permitted domain or range
Explanation:
domain constraint is used in Advanced DBMS because an attribute value must come from a permitted domain or range.
Choose an option to check your answer.
A.
a table must be stored on a web domain
B.
a transaction must use two-phase commit
C.
a query must run only on Sunday
D.
an attribute value must come from a permitted domain or range
Show Answer
Correct Answer: D. an attribute value must come from a permitted domain or range
Explanation:
The correct answer explains domain constraint in the context of Integrity and Security.
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.
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.
every table must have exactly one column
B.
foreign key values must match referenced primary key values or be null when allowed
C.
records must always be sorted by date
D.
only DBA users can run SELECT
Show 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.
A.
views must be materialized
B.
all strings must be uppercase
C.
foreign keys must always be encrypted
D.
primary key values must be unique and not null
Show 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.
A.
all strings must be uppercase
B.
primary key values must be unique and not null
C.
views must be materialized
D.
foreign keys must always be encrypted
Show 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.
A.
foreign keys must always be encrypted
B.
views must be materialized
C.
primary key values must be unique and not null
D.
all strings must be uppercase
Show Answer
Correct Answer: C. primary key values must be unique and not null
Explanation:
The correct answer explains entity integrity in the context of Integrity and Security.
