Question 1

By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.

Accepted Answer

A) True 
 B)False

Question 2

____________________ operators are used to combine search conditions in the WHERE clause of a query.

Accepted Answer

The answer of ____________________ operators are used to combine search...

Question 3

The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.

Accepted Answer

A) True 
 B)False

Question 4

The , !=, or ^= operators can be used to search for values that are $\underline { \text { not equivalent } }$ to the specified search condition. _________________________

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ logical operator is evaluated last in a sequence of logical operators.

Accepted Answer

The answer of The ____________________ logical operator is evaluated last...

Question 6

Retrieving only certain rows from a table is known as projection.

Accepted Answer

A) True 
 B)False

Question 7

Contents of the ORDERS table
  
-Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will return all orders shipped within 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; D) SELECT * FROM orders WHERE shipdate-orderdate <= 3; A) SELECT * FROM orders WHERE shipdate-orderdate >= 3; B) SELECT * FROM orders WHERE shipdate-orderdate = 3; D) SELECT * FROM orders WHERE shipdate-orderdate <= 3;

Question 8

The $\underline { \text { numeric order } }$ of columns in a SELECT clause can be referenced in the ORDER BY clause. _________________________

Accepted Answer

A) True 
 B)False

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 
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

The order in which NULL values appear in the results can be overridden by which of the following keywords?

Accepted Answer

A)  NULLS FIRST 
B)  NULLS LAST 
C)  NSEQ 
D)  both a and b 
A)  NULLS FIRST 
B)  NULLS LAST 
C)  NSEQ 
D)  both a and b

Question 11

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.

Accepted Answer

A)  double quotation marks (" ") 
B)  single quotation marks (' ') 
C)  parentheses ( ) 
D)  none of the above 
A)  double quotation marks (" ") 
B)  single quotation marks (' ') 
C)  parentheses ( ) 
D)  none of the above

Question 12

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.

Accepted Answer

The answer of The ____________________ keywords can be included in...

Question 13

The $\underline {\text { "equal to" }}$ comparison operator is used to search for NULL values. _________________________

Accepted Answer

A) True 
 B)False

Question 14

To instruct Oracle11g 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 
A)  ASC 
B)  A 
C)  ASCENDING 
D)  either a or c

Question 15

Although Oracle11g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".

Accepted Answer

A) True 
 B)False

Question 18

Which of the following clauses is used to indicate a particular sort sequence for presenting query results?

Accepted Answer

A)  SELECT 
B)  SORT BY 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  SORT BY 
C)  WHERE 
D)  ORDER BY

Question 19

____________________ characters are used to represent unknown characters in a search pattern.

Accepted Answer

The answer of ____________________ characters are used to represent unknown...

Question 20

The SORT BY clause is used to present query results in a specific order.

Accepted Answer

A) True 
 B)False

By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.

____________________ operators are used to combine search conditions in the WHERE clause of a query.

The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.

The <>, !=, or ^= operators can be used to search for values that are $\underline { \text { not equivalent } }$ to the specified search condition. _________________________

The ____________________ logical operator is evaluated last in a sequence of logical operators.

Retrieving only certain rows from a table is known as projection.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will return all orders shipped within three days after the order was received?

The $\underline { \text { numeric order } }$ of columns in a SELECT clause can be referenced in the ORDER BY clause. _________________________

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?

The order in which NULL values appear in the results can be overridden by which of the following keywords?

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.

The $\underline {\text { "equal to" }}$ comparison operator is used to search for NULL values. _________________________

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

Although Oracle11g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.

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

The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".

Which of the following clauses is used to indicate a particular sort sequence for presenting query results?

____________________ characters are used to represent unknown characters in a search pattern.

The SORT BY clause is used to present query results in a specific order.

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

By default, query results are sorted in ascending order based upon the column specified in the ORDER BY clause.

____________________ operators are used to combine search conditions in the WHERE clause of a query.

The percent sign (%) and underscore (_) symbols can be used with the LIKE comparison operator to create a search pattern.

The <>, !=, or ^= operators can be used to search for values that are not equivalent ‾\underline { \text { not equivalent } } not equivalent ​ to the specified search condition. _________________________

The ____________________ logical operator is evaluated last in a sequence of logical operators.

Retrieving only certain rows from a table is known as projection.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will return all orders shipped within three days after the order was received?

The numeric order ‾\underline { \text { numeric order } } numeric order ​ of columns in a SELECT clause can be referenced in the ORDER BY clause. _________________________

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?

The order in which NULL values appear in the results can be overridden by which of the following keywords?

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____.

The ____________________ keywords can be included in an ORDER BY clause to indicate that NULL values should be listed first in the results.

The "equal to" ‾\underline {\text { "equal to" }} "equal to" ​ comparison operator is used to search for NULL values. _________________________

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

Although Oracle11g is not case sensitive in regards to keywords, table names, and column names, it is case sensitive when comparing search conditions to the data contained in a database table.

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

The underscore symbol (_) is used in a search pattern to indicate "exactly one character in this position".

Which of the following clauses is used to indicate a particular sort sequence for presenting query results?

____________________ characters are used to represent unknown characters in a search pattern.

The SORT BY clause is used to present query results in a specific order.

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 <>, !=, or ^= operators can be used to search for values that are $\underline { \text { not equivalent } }$ to the specified search condition. _________________________

The $\underline { \text { numeric order } }$ of columns in a SELECT clause can be referenced in the ORDER BY clause. _________________________

The $\underline {\text { "equal to" }}$ comparison operator is used to search for NULL values. _________________________