Database Management Systems (DBMS)
The following statement describes a specific concept. What is it called? a stored procedure that automatically executes in response to certain events on a table.
Difficulty: Hard
About this MCQ
This Hard Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “The following statement describes a specific concept. What is it called? a stored procedure that automatically executes in response to certain events on a table.”
The accepted answer is B. Database trigger. The following statement describes a specific concept What is it called a stored procedure that automatically executes in response to certain events on a table is answered by Database trigger option B Option A Database index does not match the stem it is a near-miss used to catch incomplete recall of Database trigger Option C Primary key does not match the stem it is a near-miss used to catch incomplete recall of Database trigger Remaining alternatives Entity-Relationship ER diagram fall outside the same rule and should be eliminated once Database trigger is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item.
- A. Database index
Why not A: “Database index” is not correct. The accepted answer is B. Database trigger. The following statement describes a specific concept What is it called a stored procedure that automatically executes in response to certain events on a table is answered by Databa
- B. Database trigger ✓
- C. Primary key
Why not C: “Primary key” is not correct. The accepted answer is B. Database trigger. The following statement describes a specific concept What is it called a stored procedure that automatically executes in response to certain events on a table is answered by Databa
- D. Entity-Relationship (ER) diagram
Why not D: “Entity-Relationship (ER) diagram” is not correct. The accepted answer is B. Database trigger. The following statement describes a specific concept What is it called a stored procedure that automatically executes in response to certain events on a table is answered by Databa
Correct answer
B. Database trigger
Explanation
The following statement describes a specific concept What is it called a stored procedure that automatically executes in response to certain events on a table is answered by Database trigger option B Option A Database index does not match the stem it is a near-miss used to catch incomplete recall of Database trigger Option C Primary key does not match the stem it is a near-miss used to catch incomplete recall of Database trigger Remaining alternatives Entity-Relationship ER diagram fall outside the same rule and should be eliminated once Database trigger is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im...
- Which term refers to a virtual table based on the result of a stored SQL query?
- Which statement correctly explains Entity-Relationship (ER) diagram?
- What does Database view refer to?
- Select the correct name for: a diagram that visually represents entities and their relationships within a data...
- What is the name for a situation in which two transactions are each waiting for the other to release a lock, p...