SQL Subqueries and Functions Quiz

SQL Subqueries and Functions Quiz

Professional Development

12 Qs

quiz-placeholder

Similar activities

Intro SQL 2 - Data Dictionary

Intro SQL 2 - Data Dictionary

Professional Development

12 Qs

SQL Quiz

SQL Quiz

Professional Development

10 Qs

ACE DAY 3

ACE DAY 3

Professional Development

10 Qs

JMP Quizerable

JMP Quizerable

Professional Development

10 Qs

Pretest

Pretest

Professional Development

11 Qs

MC Demos

MC Demos

Professional Development

12 Qs

Cuestionario sobre Campañas TDC

Cuestionario sobre Campañas TDC

Professional Development

15 Qs

AUR última semana de Abril

AUR última semana de Abril

Professional Development

14 Qs

SQL Subqueries and Functions Quiz

SQL Subqueries and Functions Quiz

Assessment

Quiz

Other

Professional Development

Easy

Created by

Harrison Kitema

Used 1+ times

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following best describes a correlated subquery?

It runs only once and returns a single value.

It is independent of the outer query.

It references columns from the outer query.

It cannot be used in WHERE clauses.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL clause can a subquery not be used in?

SELECT

GROUP BY

WHERE

FROM

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main advantage of using a CTE over a subquery?

CTEs are faster.

CTEs allow recursive operations and improve readability.

CTEs are always written inside the FROM clause.

CTEs return multiple result sets.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, what does the OVER() clause do in a window function?

It joins multiple tables.

It groups rows into a temporary table.

It defines the window of rows for the function to operate on.

It filters results before aggregation.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions is typically used with window functions?

SUM()

COUNT()

ROW_NUMBER()

MAX()

6.

OPEN ENDED QUESTION

3 mins • 1 pt

A subquery can return multiple rows and columns.

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

Window functions always require a GROUP BY clause.

Evaluate responses using AI:

OFF

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?