Question 1

Which of the following is NOT a comparison operator?

Accepted Answer

A)  >= 
B)  BETWEEN...AND 
C)  = 
D)  NOT 
A)  >= 
B)  BETWEEN...AND 
C)  = 
D)  NOT

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be True to be included in the results.

Accepted Answer

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

Question 4

The maximum number of columns that can be used to sort data is $\underline { 25   }$ _________________________

Accepted Answer

A) True 
 B)False

Question 5

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 6

The $\underline { \text { SORT BY } }$ clause is used for displaying the results of a query in a sorted order. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

The process of specifying that certain rows be displayed in the results of a query is known as $\underline { \text { selection } }$. _________________________

Accepted Answer

A) True 
 B)False

Question 9

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% 
A)  %03% 
B)  *03 
C)  %03 
D)  _03%

Question 10

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 published in 2001?

Accepted Answer

A) SELECT * FROM books WHERE pubdate BETWEEN '01-JAN-01' AND '31-DEC-01'; B) SELECT * FROM books WHERE pubdate LIKE '%01'; C) SELECT * FROM books WHERE pubdate >= '01-JAN-01' AND pubdate <= '31-DEC-01'; D) all of the above A) SELECT * FROM books WHERE pubdate BETWEEN '01-JAN-01' AND '31-DEC-01'; B) SELECT * FROM books WHERE pubdate LIKE '%01'; C) SELECT * FROM books WHERE pubdate >= '01-JAN-01' AND pubdate <= '31-DEC-01'; D) all of the above

Question 11

Which of the following is not a valid comparison operator?

Accepted Answer

A)  => 
B)   
C)  ^= 
D)  none of the above 
A)  => 
B)   
C)  ^= 
D)  none of the above

Question 12

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

Accepted Answer

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

Which of the following is NOT a comparison operator?

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

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be True to be included in the results.

The maximum number of columns that can be used to sort data is $\underline { 25 }$ _________________________

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

The $\underline { \text { SORT BY } }$ clause is used for displaying the results of a query in a sorted order. _________________________

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

The process of specifying that certain rows be displayed in the results of a query is known as $\underline { \text { selection } }$ . _________________________

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

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 published in 2001?

Which of the following is not a valid comparison operator?

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

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 is NOT a comparison operator?

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

The ____________________ logical operator is used to combine search conditions when only one of the conditions must be True to be included in the results.

The maximum number of columns that can be used to sort data is 25‾\underline { 25 }25​ _________________________

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

The SORT BY ‾\underline { \text { SORT BY } } SORT BY ​ clause is used for displaying the results of a query in a sorted order. _________________________

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

The process of specifying that certain rows be displayed in the results of a query is known as selection ‾\underline { \text { selection } } selection ​ . _________________________

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

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 published in 2001?

Which of the following is not a valid comparison operator?

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

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 maximum number of columns that can be used to sort data is $\underline { 25 }$ _________________________

The $\underline { \text { SORT BY } }$ clause is used for displaying the results of a query in a sorted order. _________________________

The process of specifying that certain rows be displayed in the results of a query is known as $\underline { \text { selection } }$ . _________________________