Which of the following is a purpose of a database management system? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
Correct Answer: Option D
Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
A database object that automatically executes or fires in response to specific events (like INSERT, UPDATE, or DELETE) on a table is known as a what?
Correct Answer: Option A
Explanation:
A Trigger is a named database object containing procedural code that automatically runs or fires when a specific DML statement occurs on a designated table.
A Trigger is a named database object containing procedural code that automatically runs or fires when a specific DML statement occurs on a designated table.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the purpose of the SQL 'CASE' statement?
Correct Answer: Option B
Explanation:
CASE allows for conditional expressions, similar to IF-THEN-ELSE, within SQL statements.
CASE allows for conditional expressions, similar to IF-THEN-ELSE, within SQL statements.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!