bao final exam UPDATED ACTUAL Questions And Correct Answers
Terms in this set (39)
In subquery terminology, the first query in the SQL outer
statement is known as the _ query.
The special operator used to check whether a subquery EXISTS
returns any rows is__ _.
Which of the following differentiates the HAVING clause WHERE is executed prior to GROUP BY and HAVING after
from the WHERE clause?
While designing a query you determine that the data Use a subquery to preprocess.
needs to be preprocessed. Which of the following is
most appropriate?
A condition is true if it satisfies any value (one or more) ANY operator
produced by a subquery that is preceded by the _.
When a query includes the clause FROM CLIENT A, treat it as a query of two tables, A and B
CLIENT B, SQL will __ _.
When tables are listed in the FROM clause of an SQL aliases
query, you can give them alternate names, also known as
_____.
Which element belongs in the blank if you want to display ANY
data from all rows with a credit limit greater than the
credit limit of one or more category B cardholders?
WHERE (CREDIT_LIMIT >____(SELECT CREDIT_LIMIT
FROM CARDHOLDER WHERE CATEGORY = 'B'))
You can join tables by using a condition in the _____. WHERE clause
Which statement about subqueries is true? A subquery filters the same way an inner join does.
A condition is true if it satisfies any value (one or more) ANY operator
produced by a subquery that is preceded by the _.
The _____ of two tables is a table containing all rows that intersection
are in both tables.
The _____ of two tables is a table containing every row that union
is in either the first table, the second table, or both tables.
To retrieve data from multiple tables in a query, you can IN operator
use a subquery containing the _.
Terms in this set (39)
In subquery terminology, the first query in the SQL outer
statement is known as the _ query.
The special operator used to check whether a subquery EXISTS
returns any rows is__ _.
Which of the following differentiates the HAVING clause WHERE is executed prior to GROUP BY and HAVING after
from the WHERE clause?
While designing a query you determine that the data Use a subquery to preprocess.
needs to be preprocessed. Which of the following is
most appropriate?
A condition is true if it satisfies any value (one or more) ANY operator
produced by a subquery that is preceded by the _.
When a query includes the clause FROM CLIENT A, treat it as a query of two tables, A and B
CLIENT B, SQL will __ _.
When tables are listed in the FROM clause of an SQL aliases
query, you can give them alternate names, also known as
_____.
Which element belongs in the blank if you want to display ANY
data from all rows with a credit limit greater than the
credit limit of one or more category B cardholders?
WHERE (CREDIT_LIMIT >____(SELECT CREDIT_LIMIT
FROM CARDHOLDER WHERE CATEGORY = 'B'))
You can join tables by using a condition in the _____. WHERE clause
Which statement about subqueries is true? A subquery filters the same way an inner join does.
A condition is true if it satisfies any value (one or more) ANY operator
produced by a subquery that is preceded by the _.
The _____ of two tables is a table containing all rows that intersection
are in both tables.
The _____ of two tables is a table containing every row that union
is in either the first table, the second table, or both tables.
To retrieve data from multiple tables in a query, you can IN operator
use a subquery containing the _.
