Question 1

In which type of join are all rows from the table listed first in the query included, regardless of whether they match rows from the table listed second in the query?

Accepted Answer

A)  left inner join 
B)  left outer join 
C)  right inner join 
D)  right outer join 
A)  left inner join 
B)  left outer join 
C)  right inner join 
D)  right outer join B

Question 2

What is the term for the letter S or the letter D in the following query? ​
SELECT S.SERVER_ID, S.LAST_NAME, D.DINER_ID, D.LAST_NAME
FROM SERVER S, DINER D
WHERE (S.SERVER_ID = D.SERVER_ID)

Accepted Answer

A)  alias 
B)  operator 
C)  qualifier 
D)  set 
A)  alias 
B)  operator 
C)  qualifier 
D)  set A

Question 3

To create a condition that is true if one or more rows are obtained when the subquery is executed, you can precede that subquery with which operator?

Accepted Answer

A)  IS NULL 
B)  IS TRUE 
C)  IS EXIST 
D)  EXISTS 
A)  IS NULL 
B)  IS TRUE 
C)  IS EXIST 
D)  EXISTS D

Question 4

What is the benefit of using an alias in MySQL?

Accepted Answer

A)  It improves performance. 
B)  It simplifies complex queries. 
C)  It prevents confusion of columns from different tables. 
D)  It is required for calculations. 
A)  It improves performance. 
B)  It simplifies complex queries. 
C)  It prevents confusion of columns from different tables. 
D)  It is required for calculations.

Question 5

You can use the EXISTS operator to retrieve data from more than one table.

Accepted Answer

A) True 
 B)False

Question 6

In a nested query, the outer query is evaluated first.

Accepted Answer

A) True 
 B)False

Question 7

Nina is writing a MySQL query to list the descriptions of items in the CUPCAKES table, which are identified by PROD_ID values. The ORDER_LINE table includes product and quantity information from bakery orders, which are identified by ORDER_NUM values. What can she add to the following query to limit the list to descriptions of cupcakes purchased through order 342? SELECT DESCRIPTION FROM CUPCAKES WHERE

Accepted Answer

A)  PROD_ID IN(ORDER_LINE WHERE(ORDER_NUM = '342')); 
B)  EXISTS (PROD_ID WHERE (ORDER_LINE.ORDER_NUM = '342')); 
C)  PROD_ID IN(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342')); 
D)  PROD_ID EXISTS(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342')); 
A)  PROD_ID IN(ORDER_LINE WHERE(ORDER_NUM = '342')); 
B)  EXISTS (PROD_ID WHERE (ORDER_LINE.ORDER_NUM = '342')); 
C)  PROD_ID IN(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342')); 
D)  PROD_ID EXISTS(SELECT PROD_ID FROM ORDER_LINE WHERE(ORDER_NUM = '342'));

Question 8

When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.

Accepted Answer

A) True 
 B)False

Question 9

Which element belongs in the blank if you want to display 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'))

Accepted Answer

A)  ANY 
B)  ALL 
C)  UNION 
D)  INTERSECT 
A)  ANY 
B)  ALL 
C)  UNION 
D)  INTERSECT

Question 10

What steps should you take to construct a detailed query in a step-by-step fashion?

Accepted Answer

List in the SELECT clause all the column

Question 11

You can use the ALL and ANY operators with subqueries to produce a single column of numbers.

Accepted Answer

A) True 
 B)False

Question 12

To retrieve data from multiple tables in a query, you can use a subquery containing the _____.

Accepted Answer

A)  AND operator 
B)  IN operator 
C)  OR operator 
D)  NOT operator 
A)  AND operator 
B)  IN operator 
C)  OR operator 
D)  NOT operator

Question 13

You create an alias by typing the name of the table, pressing the _____, and then typing the name of the alias.

Accepted Answer

A)  Tab key 
B)  Backspace key 
C)  Enter key 
D)  Spacebar 
A)  Tab key 
B)  Backspace key 
C)  Enter key 
D)  Spacebar

Question 14

You can use the IN operator to retrieve data from multiple tables.

Accepted Answer

A) True 
 B)False

Question 15

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) _____.

Accepted Answer

A)  comma (,) 
B)  period (.) 
C)  percent sign (%) 
D)  asterisk (*) 
A)  comma (,) 
B)  period (.) 
C)  percent sign (%) 
D)  asterisk (*)

Question 16

Which statement about table joins in SQL is true?

Accepted Answer

A)  Self-joins usually do not include WHERE or ORDER BY clauses. 
B)  You cannot perform a self-join on a table's primary key column. 
C)  Joins must be performed between at least two different tables. 
D)  SQL has no problem treating one table with two aliases as two tables. 
A)  Self-joins usually do not include WHERE or ORDER BY clauses. 
B)  You cannot perform a self-join on a table's primary key column. 
C)  Joins must be performed between at least two different tables. 
D)  SQL has no problem treating one table with two aliases as two tables.

Question 17

Why do you use the ANY and ALL operators? What is the difference between the two operators?

Accepted Answer

You can use the ALL and ANY operators wi

Question 18

The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.

Accepted Answer

A)  union 
B)  inner join 
C)  intersection 
D)  difference 
A)  union 
B)  inner join 
C)  intersection 
D)  difference

Question 19

What steps should you take to construct the SQL command to join (relate) tables?

Accepted Answer

In the SELECT clause, list all columns y

Question 20

The _____ of two tables is a table containing all rows that are in both tables.

Accepted Answer

A)  intersection 
B)  union 
C)  difference 
D)  minus 
A)  intersection 
B)  union 
C)  difference 
D)  minus

In which type of join are all rows from the table listed first in the query included, regardless of whether they match rows from the table listed second in the query?

What is the term for the letter S or the letter D in the following query? SELECT S.SERVER_ID, S.LAST_NAME, D.DINER_ID, D.LAST_NAME FROM SERVER S, DINER D WHERE (S.SERVER_ID = D.SERVER_ID)

To create a condition that is true if one or more rows are obtained when the subquery is executed, you can precede that subquery with which operator?

What is the benefit of using an alias in MySQL?

You can use the EXISTS operator to retrieve data from more than one table.

In a nested query, the outer query is evaluated first.

When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.

Which element belongs in the blank if you want to display 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'))

What steps should you take to construct a detailed query in a step-by-step fashion?

You can use the ALL and ANY operators with subqueries to produce a single column of numbers.

To retrieve data from multiple tables in a query, you can use a subquery containing the _____.

You create an alias by typing the name of the table, pressing the _____, and then typing the name of the alias.

You can use the IN operator to retrieve data from multiple tables.

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) _____.

Which statement about table joins in SQL is true?

Why do you use the ANY and ALL operators? What is the difference between the two operators?

The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.

What steps should you take to construct the SQL command to join (relate) tables?

The _____ of two tables is a table containing all rows that are in both tables.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

Exam 5: Multiple Table Queries

In which type of join are all rows from the table listed first in the query included, regardless of whether they match rows from the table listed second in the query?

What is the term for the letter S or the letter D in the following query? ​ SELECT S.SERVER_ID, S.LAST_NAME, D.DINER_ID, D.LAST_NAME FROM SERVER S, DINER D WHERE (S.SERVER_ID = D.SERVER_ID)

To create a condition that is true if one or more rows are obtained when the subquery is executed, you can precede that subquery with which operator?

What is the benefit of using an alias in MySQL?

You can use the EXISTS operator to retrieve data from more than one table.

In a nested query, the outer query is evaluated first.

When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.

Which element belongs in the blank if you want to display 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'))

What steps should you take to construct a detailed query in a step-by-step fashion?

You can use the ALL and ANY operators with subqueries to produce a single column of numbers.

To retrieve data from multiple tables in a query, you can use a subquery containing the _____.

You create an alias by typing the name of the table, pressing the _____, and then typing the name of the alias.

You can use the IN operator to retrieve data from multiple tables.

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) _____.

Which statement about table joins in SQL is true?

Why do you use the ANY and ALL operators? What is the difference between the two operators?

The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.

What steps should you take to construct the SQL command to join (relate) tables?

The _____ of two tables is a table containing all rows that are in both tables.

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Updating Data

Database Administration

Functions Procedures and Triggers

Filters

What is the term for the letter S or the letter D in the following query? SELECT S.SERVER_ID, S.LAST_NAME, D.DINER_ID, D.LAST_NAME FROM SERVER S, DINER D WHERE (S.SERVER_ID = D.SERVER_ID)