3. Algorithms

Algorithm Design — Quiz

Test your understanding of algorithm design with 5 practice questions.

Practice Questions

Question 1

Which SQL statement in the SQL:2003 standard provides an atomic MERGE operation to insert, update, or delete rows in a target table based on a source table?

Question 2

Which SQL function returns a bitmask indicating the level of grouping for each column when using ROLLUP or CUBE in GROUP BY?

Question 3

Which feature allows a subquery in the FROM clause to reference columns of preceding items in the FROM list?

Question 4

Under snapshot isolation, which anomaly can still occur that is prevented under full serializable isolation?

Question 5

Which SQL statement prepares a transaction for two-phase commit, deferring the final commit decision?