Question 1

You can determine the number of characters in a column by using the $\underline {\text { COUNT } }$ function. _________________________

Accepted Answer

A) True 
 B)False

Question 2

The LOWER function can be used to display upper-case characters in lower-case.

Accepted Answer

A) True 
 B)False

Question 3

The $\underline { \text { CONCAT } }$ function can be used to concatenate the data contained in two columns. _________________________

Accepted Answer

A) True 
 B)False

Question 4

A Julian date is the number of days that have passed between a specific date and January 1, 4712 B.C.

Accepted Answer

A) True 
 B)False

Question 5

Contents of ORDERS table
   
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-Based upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

Accepted Answer

A)  SELECT order#, SUBSTR(shipzip, 1, 323)
FROM orders; 
B)  SELECT order#, SUBSTR(shipzip, 1, 323)
FROM orders
WHERE shipzip = 323; 
C)  SELECT order#
FROM orders
WHERE shipzip = SUBSTR(shipzip, 1, 323); 
D)  SELECT order#
FROM orders
WHERE SUBSTR(shipzip, 1, 3) = 323; 
A)  SELECT order#, SUBSTR(shipzip, 1, 323)
FROM orders; 
B)  SELECT order#, SUBSTR(shipzip, 1, 323)
FROM orders
WHERE shipzip = 323; 
C)  SELECT order#
FROM orders
WHERE shipzip = SUBSTR(shipzip, 1, 323); 
D)  SELECT order#
FROM orders
WHERE SUBSTR(shipzip, 1, 3) = 323;

Question 6

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.

Accepted Answer

The answer of The ____________________ function allows different actions to...

Question 7

Only a DATE function can be nested inside another DATE function.

Accepted Answer

A) True 
 B)False

Question 8

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

Accepted Answer

A) True 
 B)False

Question 9

$\underline { \text { INITCAP } }$ can be used to convert character strings to mixed-case characters. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The TO_CHAR function can be used to add a dollar sign ($) to a numeric value.

Accepted Answer

A) True 
 B)False

Question 11

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.

Accepted Answer

A) True 
 B)False

Question 12

The ____________________ function takes a specified value and returns results based on a set of values provided in a list.

Accepted Answer

The answer of The ____________________ function takes a specified value...

Question 13

Which of the following returns one row of results for each record processed?

Accepted Answer

A)  single-row function 
B)  multiple-row function 
C)  aggregate function 
D)  all of the above 
A)  single-row function 
B)  multiple-row function 
C)  aggregate function 
D)  all of the above

Question 14

Which of the following functions will round the numeric data to no decimal places?

Accepted Answer

A)  ROUND(34.21, 1) 
B)  ROUND(34.21, -1) 
C)  ROUND(34.21, NON
E)  
D)  ROUND(34.21, 0) 
A)  ROUND(34.21, 1) 
B)  ROUND(34.21, -1) 
C)  ROUND(34.21, NON
E)  
D)  ROUND(34.21, 0)

Question 15

What is the maximum number of columns or character strings that can be combined through a single CONCAT function?

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  eight 
A)  two 
B)  three 
C)  four 
D)  eight

Question 16

Character functions can be used to change the case of characters or to manipulate characters.

Accepted Answer

A) True 
 B)False

Question 17

The REPLACE function is used to substitute one character string for another character string in a set of data.

Accepted Answer

A) True 
 B)False

Question 18

The $\underline { \text { UPPER } }$ function can be used to display upper-case characters in lower-case. _________________________

Accepted Answer

A) True 
 B)False

Question 19

The $\underline { \text { SUBSTR } }$ function is used to return a portion of a character string. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ function removes a specific string of characters from the left side of a set of data values.

Accepted Answer

The answer of The ____________________ function removes a specific string...

You can determine the number of characters in a column by using the $\underline {\text { COUNT } }$ function. _________________________

The LOWER function can be used to display upper-case characters in lower-case.

The $\underline { \text { CONCAT } }$ function can be used to concatenate the data contained in two columns. _________________________

A Julian date is the number of days that have passed between a specific date and January 1, 4712 B.C.

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.

Only a DATE function can be nested inside another DATE function.

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

$\underline { \text { INITCAP } }$ can be used to convert character strings to mixed-case characters. _________________________

The TO_CHAR function can be used to add a dollar sign ($) to a numeric value.

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.

The ____________________ function takes a specified value and returns results based on a set of values provided in a list.

Which of the following returns one row of results for each record processed?

Which of the following functions will round the numeric data to no decimal places?

What is the maximum number of columns or character strings that can be combined through a single CONCAT function?

Character functions can be used to change the case of characters or to manipulate characters.

The REPLACE function is used to substitute one character string for another character string in a set of data.

The $\underline { \text { UPPER } }$ function can be used to display upper-case characters in lower-case. _________________________

The $\underline { \text { SUBSTR } }$ function is used to return a portion of a character string. _________________________

The ____________________ function removes a specific string of characters from the left side of a set of data values.

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

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 10: Selected Single Row Functions

You can determine the number of characters in a column by using the COUNT ‾\underline {\text { COUNT } } COUNT ​ function. _________________________

The LOWER function can be used to display upper-case characters in lower-case.

The CONCAT ‾\underline { \text { CONCAT } } CONCAT ​ function can be used to concatenate the data contained in two columns. _________________________

A Julian date is the number of days that have passed between a specific date and January 1, 4712 B.C.

Contents of ORDERS table Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP. -Based upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323?

The ____________________ function allows different actions to be performed based upon whether a NULL value exists in a specified column.

Only a DATE function can be nested inside another DATE function.

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

INITCAP ‾\underline { \text { INITCAP } } INITCAP ​ can be used to convert character strings to mixed-case characters. _________________________

The TO_CHAR function can be used to add a dollar sign ($) to a numeric value.

The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.

The ____________________ function takes a specified value and returns results based on a set of values provided in a list.

Which of the following returns one row of results for each record processed?

Which of the following functions will round the numeric data to no decimal places?

What is the maximum number of columns or character strings that can be combined through a single CONCAT function?

Character functions can be used to change the case of characters or to manipulate characters.

The REPLACE function is used to substitute one character string for another character string in a set of data.

The UPPER ‾\underline { \text { UPPER } } UPPER ​ function can be used to display upper-case characters in lower-case. _________________________

The SUBSTR ‾\underline { \text { SUBSTR } } SUBSTR ​ function is used to return a portion of a character string. _________________________

The ____________________ function removes a specific string of characters from the left side of a set of data values.

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

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

You can determine the number of characters in a column by using the $\underline {\text { COUNT } }$ function. _________________________

The $\underline { \text { CONCAT } }$ function can be used to concatenate the data contained in two columns. _________________________

$\underline { \text { INITCAP } }$ can be used to convert character strings to mixed-case characters. _________________________

The $\underline { \text { UPPER } }$ function can be used to display upper-case characters in lower-case. _________________________

The $\underline { \text { SUBSTR } }$ function is used to return a portion of a character string. _________________________