What is the purpose of a trigger in a database? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which of the following is a true statement about indexes?
Correct Answer: Option D
Explanation:
Indexes speed up data retrieval but require additional maintenance during data modifications, which can slow down DML operations.
Indexes speed up data retrieval but require additional maintenance during data modifications, which can slow down DML operations.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?
Correct Answer: Option B
Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which SQL keyword is placed immediately inside a SELECT statement or an aggregate function to eliminate duplicate rows from the output?
Correct Answer: Option C
Explanation:
The DISTINCT keyword is used to remove all duplicate values or records from the output of an SQL SELECT query.
The DISTINCT keyword is used to remove all duplicate values or records from the output of an SQL SELECT query.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!