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.
Select an option to see the answer and solution.
Database · all questionsAdvanced SQL
Advanced SQL
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
29
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
Select an option to see the answer and solution.
The UNION clause is used to combine the output from multiple queries together into a single result table.
Select an option to see the answer and solution.
ROLLBACK WORK asks SQL to empty the log file.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
Select an option to see the answer and solution.
A correlated subquery is where the outer query depends on data from the inner query.
Select an option to see the answer and solution.
A function returns one value and has only output parameters.
Select an option to see the answer and solution.
With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
Select an option to see the answer and solution.