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. 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. 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: 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: B. a database object used to process query results row by row
Explanation:
This statement is correct because cursor means that a database object used to process query results row by row.
Choose an option to check your answer.
Correct Answer: A. a database object used to process query results row by row
Explanation:
cursor is used in Advanced DBMS because a database object used to process query results row by row.
Choose an option to check your answer.
Correct Answer: B. a database object used to process query results row by row
Explanation:
The correct answer explains cursor in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: C. a database program that automatically executes in response to specified events
Explanation:
This statement is correct because trigger means that a database program that automatically executes in response to specified events.
Choose an option to check your answer.
Correct Answer: B. a database program that automatically executes in response to specified events
Explanation:
trigger is used in Advanced DBMS because a database program that automatically executes in response to specified events.
Choose an option to check your answer.
Correct Answer: A. a database program that automatically executes in response to specified events
Explanation:
The correct answer explains trigger in the context of Database Programming.
Choose an option to check your answer.
Correct Answer: B. a saved database program that can contain SQL and procedural logic
Explanation:
This statement is correct because stored procedure means that a saved database program that can contain SQL and procedural logic.
Choose an option to check your answer.
Correct Answer: B. a saved database program that can contain SQL and procedural logic
Explanation:
stored procedure is used in Advanced DBMS because a saved database program that can contain SQL and procedural logic.
Choose an option to check your answer.
Correct Answer: C. a saved database program that can contain SQL and procedural logic
Explanation:
The correct answer explains stored procedure in the context of Database Programming.
