Advanced SQL Assessement

Which SQL construct is typically used for looping in advanced SQL?

• CURSOR

• JOIN

• TRIGGER

• UNION

What is the purpose of a loop in SQL?

• To perform calculations on numeric data

• To iterate through a result set

• To create temporary tables

• To generate reports

Which SQL construct allows you to control the flow within a loop?

• IF statement

• CASE statement

• WHILE statement

• FOR statement

Which of the following is a disadvantage of using loops in SQL?

• Loops can only be used with numeric data

• Loops can slow down performance for large datasets

• Loops cannot be nested

• Loops are not supported by all database systems

Which of the following statements accurately describes a Derived Table in SQL?

• A table that is created based on another table using a CREATE TABLE statement

• A table that is derived from a SELECT statement and exists only for the duration of a query

• A table that is stored physically on disk and can be accessed by

  multiple queries

• A table that contains data imported from an external source

What is a Common Table Expression (CTE) in SQL?

• A table that is created by joining multiple tables together

• A table that is stored permanently in the database for frequent

  querying

• A temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement

• A table that contains data aggregated from other tables using GROUP BY clauses

What is a Subquery in SQL?

• A query that retrieves data from multiple tables using JOIN statements

• A query that is used to update or modify data in a table

• A query that is nested within another query

• A query that retrieves aggregate data using GROUP BY clauses

Which of the following operators is commonly used to compare the results of a Subquery with the main query?

• IN

• LIKE

• BETWEEN

• JOIN

What is the purpose of a Correlated Subquery in SQL?

• To join multiple tables using common columns

• To retrieve data from multiple tables simultaneously

• To update or modify data in a table based on a condition

• To reference a value from the outer query within the Subquery

Which of the following statements accurately describes the execution order of a Subquery in SQL?

• The Subquery is always executed first, followed by the main query

• The main query is always executed first, followed by the Subquery

• The execution order depends on the specific SQL implementation

• The Subquery and main query are executed simultaneously