Question 1

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

Accepted Answer

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

Question 2

The process of retrieving only certain rows based upon a specified condition is known as ____.​

Accepted Answer

A)  ​selection 
B)  ​projection 
C)  ​retrieval 
D)  ​derivation 
A)  ​selection 
B)  ​projection 
C)  ​retrieval 
D)  ​derivation

Question 3

Oracle12c is case sensitive when comparing data to a search condition._________________________​

Accepted Answer

A) True 
 B)False

Question 4

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 5

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.

Accepted Answer

A) True 
 B)False

Question 6

What special consideration needs to be given to search conditions when they are being compared to character or date columns?​

Accepted Answer

When a search is being conduct

Question 7

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 8

Contents of BOOKS table
   ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?​

Accepted Answer

A)  ​SELECT * FROM books
WHERE cost > $25.00; 
B)  ​SELECT * FROM books
WHERE cost >= 25.00; 
C)  ​SELECT * FROM books
WHERE cost >= $25.00; 
D)  ​none of the above 
A)  ​SELECT * FROM books
WHERE cost > $25.00; 
B)  ​SELECT * FROM books
WHERE cost >= 25.00; 
C)  ​SELECT * FROM books
WHERE cost >= $25.00; 
D)  ​none of the above

Question 9

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

Although Oracle12c 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 11

When the WHERE clause contains multiple types of operators,which of the following is resolved first?​

Accepted Answer

A)  ​arithmetic operations 
B)  ​comparison operators 
C)  ​logical operators 
D)  ​union operators 
A)  ​arithmetic operations 
B)  ​comparison operators 
C)  ​logical operators 
D)  ​union operators

Question 12

When using a search pattern,a(n)? symbol is used to indicate exactly one character in that position._________________________​

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.​

Accepted Answer

A)  ​an ORDER BY clause can not be added 
B)  ​only columns in the SELECT clause can be used for sorting 
C)  ​only a primary sort is allowed 
D)  ​None of the above 
A)  ​an ORDER BY clause can not be added 
B)  ​only columns in the SELECT clause can be used for sorting 
C)  ​only a primary sort is allowed 
D)  ​None of the above

Question 15

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

Accepted Answer

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

Question 16

The ____________________ symbol is used to represent one or more characters in a search pattern.​

Accepted Answer

%
percent

Question 17

If there is an exact match between the data used for a primary sort,a(n)____ can be used to determine the sequence used to display the data.​

Accepted Answer

A)  ​secondary sort 
B)  ​alternative sort 
C)  ​alternate sort 
D)  ​supplemental sort 
A)  ​secondary sort 
B)  ​alternative sort 
C)  ​alternate sort 
D)  ​supplemental sort

Question 18

A greater than or equal to comparison is indicated by the symbols =>._________________________​

Accepted Answer

A) True 
 B)False

Question 19

Contents of BOOKS table
   ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?​

Accepted Answer

A)  ​SELECT * FROM books WHERE retail >38 SORT BY retail; 
B)  ​SELECT * FROM books WHERE retail >38 SORTED BY retail; 
C)  ​SELECT * FROM books WHERE retail >38 ORDERED BY retail; 
D)  ​SELECT * FROM books WHERE retail >38 ORDER BY retail; 
A)  ​SELECT * FROM books WHERE retail >38 SORT BY retail; 
B)  ​SELECT * FROM books WHERE retail >38 SORTED BY retail; 
C)  ​SELECT * FROM books WHERE retail >38 ORDERED BY retail; 
D)  ​SELECT * FROM books WHERE retail >38 ORDER BY retail;

Question 20

If a date column is being used for comparison against the search condition,the search condition is enclosed in double quotation marks._________________________​

Accepted Answer

A) True 
 B)False

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

The process of retrieving only certain rows based upon a specified condition is known as ____.

Oracle12c is case sensitive when comparing data to a search condition._________________________

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

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.

What special consideration needs to be given to search conditions when they are being compared to character or date columns?

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?

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

Although Oracle12c 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.

When the WHERE clause contains multiple types of operators,which of the following is resolved first?

When using a search pattern,a(n)? symbol is used to indicate exactly one character in that position._________________________

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

In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.

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

The ____________________ symbol is used to represent one or more characters in a search pattern.

If there is an exact match between the data used for a primary sort,a(n)____ can be used to determine the sequence used to display the data.

A greater than or equal to comparison is indicated by the symbols =>._________________________

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?

If a date column is being used for comparison against the search condition,the search condition is enclosed in double quotation marks._________________________

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

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

The process of retrieving only certain rows based upon a specified condition is known as ____.​

Oracle12c is case sensitive when comparing data to a search condition._________________________​

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

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.

What special consideration needs to be given to search conditions when they are being compared to character or date columns?​

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

Contents of BOOKS table ​ -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?​

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

Although Oracle12c 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.

When the WHERE clause contains multiple types of operators,which of the following is resolved first?​

When using a search pattern,a(n)? symbol is used to indicate exactly one character in that position._________________________​

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

In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.​

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

The ____________________ symbol is used to represent one or more characters in a search pattern.​

If there is an exact match between the data used for a primary sort,a(n)____ can be used to determine the sequence used to display the data.​

A greater than or equal to comparison is indicated by the symbols =>._________________________​

Contents of BOOKS table ​ -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?​

If a date column is being used for comparison against the search condition,the search condition is enclosed in double quotation marks._________________________​

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

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

The process of retrieving only certain rows based upon a specified condition is known as ____.

Oracle12c is case sensitive when comparing data to a search condition._________________________

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

What special consideration needs to be given to search conditions when they are being compared to character or date columns?

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

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?

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

When the WHERE clause contains multiple types of operators,which of the following is resolved first?

When using a search pattern,a(n)? symbol is used to indicate exactly one character in that position._________________________

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

In regards to sorting,if a DISTINCT option is used in the SELECT clause of a query then ____.

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

The ____________________ symbol is used to represent one or more characters in a search pattern.

If there is an exact match between the data used for a primary sort,a(n)____ can be used to determine the sequence used to display the data.

A greater than or equal to comparison is indicated by the symbols =>._________________________

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?

If a date column is being used for comparison against the search condition,the search condition is enclosed in double quotation marks._________________________