Crowdly

Add to Chrome

DataBase Fundamentals new

Looking for DataBase Fundamentals new test answers and solutions? Browse our comprehensive collection of verified answers for DataBase Fundamentals new at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which of the following is a correlated subquery?

Is a subquery that contains a reference to a table that also appears in the outer query

✅

Uses the result of an outer query to determine the processing of an outer query

❌

Uses the result of an inner query to determine the processing of an inner query

❌

View this question

Match the SQL subquery type with its description

A subquery that is defined within the WHERE clause of the outer query

A subquery that returns a single column and a single row

A subquery that is evaluated for each row processed by the outer query

A subquery that is evaluated once for the entire outer query

View this question

Which of the following statements is true concerning subqueries?

Cannot return the same result as a query that is not a subquery

❌

Does not start with the word SELECT

❌

Involves the use of an inner and outer query

✅

Cannot use the same table as the outer query

❌

View this question

Which keyword is used ...

(match the appropriate)

to eliminate duplicate rows in the result of a subquery?

to define an alias for a subquery?

to include the result of a subquery in the SELECT statement of the outer query?

View this question

Match the SQL subquery operator with its function

Checks if a subquery returns any rows

Compares a value with the result of a subquery that returns multiple rows

Checks if a subquery returns no rows

Keyword is commonly used to introduce a subquery

View this question

What does the EXISTS operator return if the subquery returns any rows?

False

Null

True

Error

View this question

Which type of subquery is evaluated for each row processed by the outer query?

Nested subquery

Non-correlated subquery

Scalar subquery

Correlated subquery

View this question

Which operator is used ...

(match the appropriate)

to check if a subquery returns no rows?

to compare for equality a single value with the result of a subquery?

to compare by more/less a value with the result of a subquery that returns a single column and a single row?

View this question

Which type of subquery is executed once for the entire outer query?

Nested subquery

❌

Non-correlated subquery

Scalar subquery

Correlated subquery

Assuming that we have 2 tables - customers and orders:

Assuming the following query

select * from customers join orders on orders.customer_id = customers.customer_id;

It will not bring the customers that they have never put an order.

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank