What does the letter 'D' stand for in the widely accepted ACID properties of database transactions? 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 statement is used to delete all rows from a table without logging individual row deletions?
Correct Answer: Option B
Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?
Correct Answer: Option D
Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the role of the 'WHERE' clause in an UPDATE statement?
Correct Answer: Option B
Explanation:
The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.
The WHERE clause in UPDATE identifies the rows that will be updated. Without it, all rows would be updated.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!