Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed? 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 component is used to specify a fallback default value for a column when no value is provided during an insert operation?
Correct Answer: Option B
Explanation:
The DEFAULT constraint assigns a predefined default value to a column when an INSERT statement does not explicitly provide a value for that column.
The DEFAULT constraint assigns a predefined default value to a column when an INSERT statement does not explicitly provide a value for that column.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is the purpose of the SQL DISTINCT keyword?
Correct Answer: Option A
Explanation:
DISTINCT removes duplicate rows from the query result.
DISTINCT removes duplicate rows from the query result.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a non-aggregate function in SQL?
Correct Answer: Option D
Explanation:
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!