Advanced SQL MCQs
Practice free Advanced SQL multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 31 questions — no login required.
Question 20hard
The code to create triggers and routines is stored in only one location and is administered centrally.
Question 21hard
A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
Advertisement
Question 22hard
When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
Question 23hard
The UNION clause is used to combine the output from multiple queries together into a single result table.
Advertisement
Question 25hard
The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
Question 26hard
Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
Question 27hard
A correlated subquery is where the outer query depends on data from the inner query.