Question 1

Contents of the ORDERS table
 
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?​

Accepted Answer

A)  ​SELECT * FROM orders WHERE shipcity = 'ATLANTA' OR shipcity = 'SEATTLE'; 
B)  ​SELECT * FROM orders WHERE shipcity IN ( 'ATLANTA' ,'SEATTLE'); 
C)  ​SELECT * FROM orders WHERE shipcity = 'Atlanta' OR shipcity = 'Seattle'; 
D)  ​SELECT * FROM orders WHERE shipcity LIKE 'AT%' OR shipcity LIKE 'SEA%';

Question 2

The ____________________ comparison operator is used to search for NULL values.​

Accepted Answer

The answer of The ____________________ comparison operator is used to...

Question 3

The maximum number of columns that can be used to sort data is 25._________________________​

Accepted Answer

A) True 
 B)False

Question 4

NOT,AND,and OR are comparison operators._________________________​

Accepted Answer

A) True 
 B)False

Question 5

Which of the following operators can be used to combine search conditions?​

Accepted Answer

A)  ​AND 
B)  ​= 
C)  ​IS NOT NULL 
D)  ​none of the above

Question 6

Which of the following is a valid logical operator?​

Accepted Answer

A)  ​NOT 
B)  ​AND 
C)  ​OR 
D)  ​all of the above

Question 7

The IN comparison operator is used when searching for a pattern of characters.​

Accepted Answer

A) True 
 B)False

Question 8

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?​

Accepted Answer

A)  ​ColB = NULL 
B)  ​ColB IS NOT NULL 
C)  ​ColB IS NULL 
D)  ​ColB = ' '

Question 9

Contents of BOOKS table
  ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

Accepted Answer

A)  ​SELECT * FROM books WHERE pubid LIKE "1"; 
B)  ​SELECT * FROM books WHERE pubid = 1; 
C)  ​SELECT * FROM books WHERE pubid > 1; 
D)  ​both a and b

Question 10

Contents of the ORDERS table
 
-​Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?

Accepted Answer

A)  ​SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1007; 
B)  ​SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE 1_7%; 
C)  ​SELECT order#,shipdate-orderdate FROM orders WHERE order# = 1_7%; 
D)  ​SELECT order#,shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';

Question 11

The process of specifying that certain rows be displayed in the results of a query is known as selection._________________________​

Accepted Answer

A) True 
 B)False

Question 12

Which of the following search patterns would find dates occurring only in the year 2003?​

Accepted Answer

A)  ​%03% 
B)  ​*03 
C)  ​%03 
D)  ​_03%

Question 13

When two conditions are joined by the OR keyword,both conditions must be TRUE for a record to be included in the results._________________________​

Accepted Answer

A) True 
 B)False

Question 14

​To instruct Oracle12c to sort data in ascending order,enter ____ after the column name in the ORDER BY clause.

Accepted Answer

A)  ​ASC 
B)  ​A 
C)  ​ASCENDING 
D)  ​either a or c

Question 15

​The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

Accepted Answer

The answer of ​The ____________________ symbol is used for determining...

Question 16

​What is the purpose of the WHERE clause?

Accepted Answer

The answer of ​What is the purpose of the WHERE...

Question 17

A(n)____________________ value is considered the same as the absence of data.​

Accepted Answer

The answer of A(n)____________________ value is considered the same as...

Question 18

Contents of BOOKS table
  ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

Accepted Answer

A)  ​SELECT * FROM books
WHERE pubid = 1 OR pubid = 2 OR retail >= 42; 
B)  ​SELECT * FROM books
WHERE pubid IN (1,2)OR retail => 42; 
C)  ​SELECT * FROM books
WHERE pubid = 1 AND pubid=2 OR retail >=42; 
D)  ​both a and b

Question 19

The ____________________ logical operator is used to reverse the meaning of a search condition.​

Accepted Answer

The answer of The ____________________ logical operator is used to...

Question 20

Which of the following operators is used when the criteria is based upon a search pattern?​

Accepted Answer

A)  ​AND 
B)  ​LIKE 
C)  ​IS NULL 
D)  ​BETWEEN...AND

Exam 8: Restricting Rows and Sorting Data

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?

The ____________________ comparison operator is used to search for NULL values.

The maximum number of columns that can be used to sort data is 25._________________________

NOT,AND,and OR are comparison operators._________________________

Which of the following operators can be used to combine search conditions?

Which of the following is a valid logical operator?

The IN comparison operator is used when searching for a pattern of characters.

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed) ?

The process of specifying that certain rows be displayed in the results of a query is known as selection._________________________

Which of the following search patterns would find dates occurring only in the year 2003?

When two conditions are joined by the OR keyword,both conditions must be TRUE for a record to be included in the results._________________________

To instruct Oracle12c to sort data in ascending order,enter ____ after the column name in the ORDER BY clause.

The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

What is the purpose of the WHERE clause?

A(n)____________________ value is considered the same as the absence of data.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

The ____________________ logical operator is used to reverse the meaning of a search condition.

Which of the following operators is used when the criteria is based upon a search pattern?

Exam 8: Restricting Rows and Sorting Data

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?​

The ____________________ comparison operator is used to search for NULL values.​

The maximum number of columns that can be used to sort data is 25._________________________​

NOT,AND,and OR are comparison operators._________________________​

Which of the following operators can be used to combine search conditions?​

Which of the following is a valid logical operator?​

The IN comparison operator is used when searching for a pattern of characters.​

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?​

Contents of BOOKS table ​ -​Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

Contents of the ORDERS table -​Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed) ?

The process of specifying that certain rows be displayed in the results of a query is known as selection._________________________​

Which of the following search patterns would find dates occurring only in the year 2003?​

When two conditions are joined by the OR keyword,both conditions must be TRUE for a record to be included in the results._________________________​

​To instruct Oracle12c to sort data in ascending order,enter ____ after the column name in the ORDER BY clause.

​The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

​What is the purpose of the WHERE clause?

A(n)____________________ value is considered the same as the absence of data.​

Contents of BOOKS table ​ -​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

The ____________________ logical operator is used to reverse the meaning of a search condition.​

Which of the following operators is used when the criteria is based upon a search pattern?​

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?

The ____________________ comparison operator is used to search for NULL values.

The maximum number of columns that can be used to sort data is 25._________________________

NOT,AND,and OR are comparison operators._________________________

Which of the following operators can be used to combine search conditions?

Which of the following is a valid logical operator?

The IN comparison operator is used when searching for a pattern of characters.

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed) ?

The process of specifying that certain rows be displayed in the results of a query is known as selection._________________________

Which of the following search patterns would find dates occurring only in the year 2003?

When two conditions are joined by the OR keyword,both conditions must be TRUE for a record to be included in the results._________________________

To instruct Oracle12c to sort data in ascending order,enter ____ after the column name in the ORDER BY clause.

The ____________________ symbol is used for determining whether or not a value is less than or equal to a specified search condition.

What is the purpose of the WHERE clause?

A(n)____________________ value is considered the same as the absence of data.

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?

The ____________________ logical operator is used to reverse the meaning of a search condition.

Which of the following operators is used when the criteria is based upon a search pattern?