Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: D. a structured block with declarations, executable statements, and exception handling
Explanation:
The correct answer explains PL/SQL block in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: D. a relational operation that selects specific columns
Explanation:
This statement is correct because projection operation means that a relational operation that selects specific columns.
Choose an option to check your answer.
Correct Answer: A. a data access method that uses an index to locate qualifying rows
Explanation:
The correct answer explains index scan in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: D. a structured block with declarations, executable statements, and exception handling
Explanation:
PL/SQL block is used in Advanced DBMS because a structured block with declarations, executable statements, and exception handling.
Choose an option to check your answer.
Correct Answer: A. a unique increasing identifier used to order log records and relate pages to logs
Explanation:
This statement is correct because log sequence number means that a unique increasing identifier used to order log records and relate pages to logs.
Choose an option to check your answer.
Correct Answer: B. an operation that combines rows from related tables based on a condition
Explanation:
The correct answer explains join operation in the context of Query Processing.
Choose an option to check your answer.
Correct Answer: B. a data access method that uses an index to locate qualifying rows
Explanation:
index scan is used in Advanced DBMS because a data access method that uses an index to locate qualifying rows.
Choose an option to check your answer.
Correct Answer: B. a structured block with declarations, executable statements, and exception handling
Explanation:
This statement is correct because PL/SQL block means that a structured block with declarations, executable statements, and exception handling.
Choose an option to check your answer.
Correct Answer: D. the DBMS manages pages between disk and memory to reduce I/O cost
Explanation:
The correct answer explains buffer management in the context of Physical Design and Tuning.
Choose an option to check your answer.
Correct Answer: B. an operation that combines rows from related tables based on a condition
Explanation:
join operation is used in Advanced DBMS because an operation that combines rows from related tables based on a condition.
Choose an option to check your answer.
Correct Answer: C. a data access method that uses an index to locate qualifying rows
Explanation:
This statement is correct because index scan means that a data access method that uses an index to locate qualifying rows.
Choose an option to check your answer.
Correct Answer: D. Microsoft SQL Server’s extension of SQL for procedural programming and administration
Explanation:
The correct answer explains T-SQL in the context of Database Programming.
