
Oracle SQL Subquery Mastery

Quiz
•
Other
•
12th Grade
•
Hard
Chandra Sekhar
FREE Resource
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a scalar subquery in Oracle SQL?
A scalar subquery in Oracle SQL is a subquery that returns a single row.
A scalar subquery in Oracle SQL is a subquery that returns a single value (one row and one column). It can be used in places where an expression is expected, such as SELECT list, WHERE clause, or HAVING clause.
A scalar subquery in Oracle SQL is a subquery that returns no values.
A scalar subquery in Oracle SQL is a subquery that returns multiple values.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the concept of a correlated subquery with an example.
Selecting all employees whose salary is below the average salary of their department
Using a subquery to calculate the total salary for each department and comparing it to the salary of each employee
Filtering employees based on their job title rather than salary
An example of a correlated subquery is selecting all employees whose salary is above the average salary of their department. This can be achieved by using a subquery to calculate the average salary for each department and then comparing it to the salary of each employee in the outer query.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How is an inline view used in Oracle SQL subqueries?
By placing the subquery within the FROM clause and giving it an alias.
By placing the subquery within the GROUP BY clause and giving it an alias.
By placing the subquery within the WHERE clause and giving it an alias.
By placing the subquery within the SELECT clause and giving it an alias.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Differentiate between nested subquery and correlated subquery.
Nested subquery is executed after the outer query, while correlated subquery is executed before the outer query.
Nested subquery is not dependent on the outer query, while correlated subquery is dependent on the outer query.
Nested subquery is executed first before the outer query, while correlated subquery is executed for each row processed by the outer query.
Nested subquery can only return a single value, while correlated subquery can return multiple values.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When would you use an EXISTS subquery in Oracle SQL?
When you want to retrieve all columns from a table
When you want to check for the existence of rows in a subquery result set.
When you want to update multiple rows in a table
When you want to sort the result set in descending order
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Provide an example of a NOT EXISTS subquery in Oracle SQL.
SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table1.id = table2.id);
SELECT * FROM table1 WHERE EXISTS (SELECT * FROM table2);
SELECT * FROM table1 WHERE EXISTS (SELECT * FROM table2 WHERE table1.id = table2.id);
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a multi-column subquery and how is it useful?
A multi-column subquery is a subquery that returns multiple columns of data. It is useful when you need to retrieve related data from different tables in a single query.
A multi-column subquery is a subquery that returns only one column of data.
A multi-column subquery is a subquery that returns data from a single table.
A multi-column subquery is a subquery that returns data in random order.
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Tin học 12 bài 3

Quiz
•
1st - 12th Grade
10 questions
Introdução às Consultas SQL

Quiz
•
12th Grade - University
10 questions
SQL_Quiz

Quiz
•
12th Grade
10 questions
IT QUIZ

Quiz
•
10th - 12th Grade
15 questions
Oracle SQL Join

Quiz
•
12th Grade
15 questions
SQL Quiz

Quiz
•
12th Grade
15 questions
pagi pagi makan marning , pagi ini siap ada warning!!!

Quiz
•
12th Grade
17 questions
Access - set up and queries

Quiz
•
10th - 12th Grade
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade