Which of the following ensures data integrity in RDBMS? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?
Correct Answer: Option D
Explanation:
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?
Correct Answer: Option D
Explanation:
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is a synonym in database terms?
Correct Answer: Option D
Explanation:
A synonym is an alternative name for a database object, allowing simpler references.
A synonym is an alternative name for a database object, allowing simpler references.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!