Question 1

Comparison operators are used to combine search conditions.

Accepted Answer

A) True 
 B)False  False

Question 2

When two conditions are joined by the AND logical operator, only one of the conditions must be True to be included in the query results.

Accepted Answer

A) True 
 B)False  False

Question 3

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

Accepted Answer

NOT

Question 4

To find rows containing a NULL value in a specified column, you must use the search condition of = NULL.

Accepted Answer

A) True 
 B)False

Question 5

The maximum number of columns that can be specified for sorting data is ____.

Accepted Answer

A)  25 
B)  52 
C)  225 
D)  255 
A)  25 
B)  52 
C)  225 
D)  255

Question 6

An ORDER BY clause can reference a column to be used for sorting based upon its position in the SELECT clause.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following search patterns could be used to find the word HELLO in Oracle11g?

Accepted Answer

A)  %H% 
B)  HEL* 
C)  _EL* 
D)  %HEL?O 
A)  %H% 
B)  HEL* 
C)  _EL* 
D)  %HEL?O

Question 8

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders that were not shipped for at least three days after the order was received?

Accepted Answer

A)  SELECT * FROM orders WHERE shipdate-orderdate => 3; 
B)  SELECT * FROM orders WHERE shipdate-orderdate >= 3; 
C)  SELECT * FROM orders WHERE NOT shipdate-orderdate => 3; 
D)  SELECT * FROM orders WHERE NOT shipdate-orderdate >= 3; 
A)  SELECT * FROM orders WHERE shipdate-orderdate => 3; 
B)  SELECT * FROM orders WHERE shipdate-orderdate >= 3; 
C)  SELECT * FROM orders WHERE NOT shipdate-orderdate => 3; 
D)  SELECT * FROM orders WHERE NOT shipdate-orderdate >= 3;

Question 9

Contents of BOOKS table
  
-Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list the title and retail price of each book stored in the BOOKS table, sorted in order of the book titles?

Accepted Answer

A)  SELECT title, retail FROM books
ORDERED BY title; 
B)  SELECT title, retail FROM books
SORTED BY title; 
C)  SELECT title, retail FROM books
ORDER BY title; 
D)  SELECT title, retail FROM books
SORT BY title; 
A)  SELECT title, retail FROM books
ORDERED BY title; 
B)  SELECT title, retail FROM books
SORTED BY title; 
C)  SELECT title, retail FROM books
ORDER BY title; 
D)  SELECT title, retail FROM books
SORT BY title;

Question 10

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?

Accepted Answer

A)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDER BY customer#, order#; 
B)  SELECT * FROM orders
WHERE shipdate IS NULL
ORDER BY customer#, order#; 
C)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDERED BY customer#, order#; 
D)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
SORTED BY customer#, order#; 
A)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDER BY customer#, order#; 
B)  SELECT * FROM orders
WHERE shipdate IS NULL
ORDER BY customer#, order#; 
C)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
ORDERED BY customer#, order#; 
D)  SELECT * FROM orders
WHERE shipdate IS NOT NULL
SORTED BY customer#, order#;

Question 11

The $\leq$ symbol is used to search for records containing a value that is less than or equal to the stated search condition. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Contents of BOOKS table
  
-Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

Accepted Answer

A)  SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35; 
B)  SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35; 
C)  SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35; 
D)  SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35); 
A)  SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35; 
B)  SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35; 
C)  SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35; 
D)  SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);

Question 13

Which of the following is a valid logical operator?

Accepted Answer

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

Question 14

When sorted in descending order, NULL values will be listed first in the results, unless the user specifies otherwise.

Accepted Answer

A) True 
 B)False

Question 15

A(n) $\underline { \text { clause } }$ identifies what must exist or a requirement that must be met for a record to be included in the results of a query. _________________________

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is a valid comparison operator?

Accepted Answer

A)  != 
B)  IN 
C)  ^= 
D)  all of the above 
A)  != 
B)  IN 
C)  ^= 
D)  all of the above

Question 17

NOT, AND, and OR are $\underline {\text { comparison } }$ operators. _________________________

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____ is used to indicate how data should relate to a given search condition.

Accepted Answer

A)  comparison operator 
B)  logical operator 
C)  search pattern 
D)  criteria 
A)  comparison operator 
B)  logical operator 
C)  search pattern 
D)  criteria

Question 19

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?

Accepted Answer

A) SELECT * FROM orders WHERE shipdate = '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03'; D) both b and c A) SELECT * FROM orders WHERE shipdate = '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03'; D) both b and c

Question 20

The ____________________ logical operator is similar to the IN comparison operator.

Accepted Answer

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

Comparison operators are used to combine search conditions.

When two conditions are joined by the AND logical operator, only one of the conditions must be True to be included in the query results.

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

To find rows containing a NULL value in a specified column, you must use the search condition of = NULL.

The maximum number of columns that can be specified for sorting data is ____.

An ORDER BY clause can reference a column to be used for sorting based upon its position in the SELECT clause.

Which of the following search patterns could be used to find the word HELLO in Oracle11g?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders that were not shipped for at least three days after the order was received?

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list the title and retail price of each book stored in the BOOKS table, sorted in order of the book titles?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?

The $\leq$ symbol is used to search for records containing a value that is less than or equal to the stated search condition. _________________________

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

Which of the following is a valid logical operator?

When sorted in descending order, NULL values will be listed first in the results, unless the user specifies otherwise.

A(n) $\underline { \text { clause } }$ identifies what must exist or a requirement that must be met for a record to be included in the results of a query. _________________________

Which of the following is a valid comparison operator?

NOT, AND, and OR are $\underline {\text { comparison } }$ operators. _________________________

A(n) ____ is used to indicate how data should relate to a given search condition.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?

The ____________________ logical operator is similar to the IN comparison operator.

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 8: Restricting Rows and Sorting Data

Comparison operators are used to combine search conditions.

When two conditions are joined by the AND logical operator, only one of the conditions must be True to be included in the query results.

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

To find rows containing a NULL value in a specified column, you must use the search condition of = NULL.

The maximum number of columns that can be specified for sorting data is ____.

An ORDER BY clause can reference a column to be used for sorting based upon its position in the SELECT clause.

Which of the following search patterns could be used to find the word HELLO in Oracle11g?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders that were not shipped for at least three days after the order was received?

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list the title and retail price of each book stored in the BOOKS table, sorted in order of the book titles?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?

The ≤\leq≤ symbol is used to search for records containing a value that is less than or equal to the stated search condition. _________________________

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?

Which of the following is a valid logical operator?

When sorted in descending order, NULL values will be listed first in the results, unless the user specifies otherwise.

A(n) clause ‾\underline { \text { clause } } clause ​ identifies what must exist or a requirement that must be met for a record to be included in the results of a query. _________________________

Which of the following is a valid comparison operator?

NOT, AND, and OR are comparison ‾\underline {\text { comparison } } comparison ​ operators. _________________________

A(n) ____ is used to indicate how data should relate to a given search condition.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?

The ____________________ logical operator is similar to the IN comparison operator.

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

The $\leq$ symbol is used to search for records containing a value that is less than or equal to the stated search condition. _________________________

A(n) $\underline { \text { clause } }$ identifies what must exist or a requirement that must be met for a record to be included in the results of a query. _________________________

NOT, AND, and OR are $\underline {\text { comparison } }$ operators. _________________________