Question 1

The ____________________ function returns the phonetic representation for a specified value.

Accepted Answer

The answer of The ____________________ function returns the phonetic representation...

Question 2

The format argument in the TO_CHAR function must be enclosed in $\underline {\text { double }}$ quotation marks. _________________________

Accepted Answer

A) True 
 B)False

Question 3

Which of the following format elements will display insignificant leading zeros?

Accepted Answer

A)  $999 
B)  0009999 
C)  99.999 
D)  9,999.990 
A)  $999 
B)  0009999 
C)  99.999 
D)  9,999.990

Question 4

Which of the following format elements will display the value of Friday in a specified date as a 6?

Accepted Answer

A)  D 
B)  DD 
C)  DDD 
D)  DAY 
A)  D 
B)  DD 
C)  DDD 
D)  DAY

Question 5

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.

Accepted Answer

When used with date values, the TO_CHAR

Question 6

Which of the following is an accurate statement?

Accepted Answer

A)  When the LOWER function is used in a SELECT clause, it will automatically store the data in lower-case letters in the database table. 
B)  When the LOWER function is used in a SELECT clause, the function stays in effect for the remainder of that user's session. 
C)  When the LOWER function is used in a SELECT clause, the function only stays in effect for the duration of that SQL statement. 
D)  none of the above 
A)  When the LOWER function is used in a SELECT clause, it will automatically store the data in lower-case letters in the database table. 
B)  When the LOWER function is used in a SELECT clause, the function stays in effect for the remainder of that user's session. 
C)  When the LOWER function is used in a SELECT clause, the function only stays in effect for the duration of that SQL statement. 
D)  none of the above

Question 7

Which of the following functions can be used to determine the date one month after a specified date?

Accepted Answer

A)  ADD_MONTH 
B)  ADD_MONTHS 
C)  ONE_MONTH 
D)  NEXT_MONTH 
A)  ADD_MONTH 
B)  ADD_MONTHS 
C)  ONE_MONTH 
D)  NEXT_MONTH

Question 8

The ____________________ function is used to determine the number of months between two dates.

Accepted Answer

The answer of The ____________________ function is used to determine...

Question 9

Which of the following functions can be used to remove a specific set of characters from the left side of a set of data values?

Accepted Answer

A)  LTRIM 
B)  RTRIM 
C)  FULLTRIM 
D)  both a and b 
A)  LTRIM 
B)  RTRIM 
C)  FULLTRIM 
D)  both a and b

Question 10

When a format argument is included in a function, it must be enclosed in ____.

Accepted Answer

A)  single quotation marks 
B)  double quotation marks 
C)  parentheses 
D)  percent signs 
A)  single quotation marks 
B)  double quotation marks 
C)  parentheses 
D)  percent signs

Question 11

Which of the following functions determines the number of characters in a character string?

Accepted Answer

A)  COUNT 
B)  NUMBER 
C)  LENGTH 
D)  none of the above 
A)  COUNT 
B)  NUMBER 
C)  LENGTH 
D)  none of the above

Question 12

The ____________________ function can be used to determine the number of characters in a string.

Accepted Answer

The answer of The ____________________ function can be used to...

Question 13

Which of the following functions can be used to fill a character string to a specific width?

Accepted Answer

A)  LPAD 
B)  RPAD 
C)  LFILL 
D)  both a and b 
A)  LPAD 
B)  RPAD 
C)  LFILL 
D)  both a and b

Question 14

The $\underline {\text { ROUND } }$ function can be used to round numeric data to the left or right of the decimal point. _________________________

Accepted Answer

A) True 
 B)False

Question 15

When functions are nested, the ____ function is solved first.

Accepted Answer

A)  single-row 
B)  multiple-row 
C)  inner 
D)  outer 
A)  single-row 
B)  multiple-row 
C)  inner 
D)  outer

Question 16

The$\underline{YR}$ element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date. _________________________

Accepted Answer

A) True 
 B)False

Question 17

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 the number of days between the date an order was placed and the date it was shipped?

Accepted Answer

A)  SELECT order#, TO_CHAR(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
B)  SELECT order#, MONTHS_BETWEEN(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
C)  SELECT order#, ADD_MONTHS(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
D)  SELECT order#, DAYS_BETWEEN(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
A)  SELECT order#, TO_CHAR(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
B)  SELECT order#, MONTHS_BETWEEN(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
C)  SELECT order#, ADD_MONTHS(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL; 
D)  SELECT order#, DAYS_BETWEEN(shipdate-orderdate, '99') FROM orders
WHERE shipdate IS NOT NULL;

Question 18

The TO_CHAR function can be used to format what types of data?

Accepted Answer

A)  numeric 
B)  date 
C)  numeric and date 
D)  no formatting can be performed 
A)  numeric 
B)  date 
C)  numeric and date 
D)  no formatting can be performed

Question 19

The ____ function can be used to convert dates and numbers to a formatted character string.

Accepted Answer

A)  TO_DATE 
B)  CONVERT 
C)  FORMATMODEL 
D)  TO_CHAR 
A)  TO_DATE 
B)  CONVERT 
C)  FORMATMODEL 
D)  TO_CHAR

Question 20

A(n) ____________________ date represents the number of days that have passed between a specified date and January 1, 4712, B.C.

Accepted Answer

The answer of A(n) ____________________ date represents the number of...

The ____________________ function returns the phonetic representation for a specified value.

The format argument in the TO_CHAR function must be enclosed in $\underline {\text { double }}$ quotation marks. _________________________

Which of the following format elements will display insignificant leading zeros?

Which of the following format elements will display the value of Friday in a specified date as a 6?

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.

Which of the following is an accurate statement?

Which of the following functions can be used to determine the date one month after a specified date?

The ____________________ function is used to determine the number of months between two dates.

Which of the following functions can be used to remove a specific set of characters from the left side of a set of data values?

When a format argument is included in a function, it must be enclosed in ____.

Which of the following functions determines the number of characters in a character string?

The ____________________ function can be used to determine the number of characters in a string.

Which of the following functions can be used to fill a character string to a specific width?

The $\underline {\text { ROUND } }$ function can be used to round numeric data to the left or right of the decimal point. _________________________

When functions are nested, the ____ function is solved first.

The $\underline{YR}$ element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date. _________________________

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 the number of days between the date an order was placed and the date it was shipped?

The TO_CHAR function can be used to format what types of data?

The ____ function can be used to convert dates and numbers to a formatted character string.

A(n) ____________________ date represents the number of days that have passed between a specified date and January 1, 4712, B.C.

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

The ____________________ function returns the phonetic representation for a specified value.

The format argument in the TO_CHAR function must be enclosed in double ‾\underline {\text { double }} double ​ quotation marks. _________________________

Which of the following format elements will display insignificant leading zeros?

Which of the following format elements will display the value of Friday in a specified date as a 6?

Explain the difference between the TO_CHAR and TO_DATE functions when used with date values.

Which of the following is an accurate statement?

Which of the following functions can be used to determine the date one month after a specified date?

The ____________________ function is used to determine the number of months between two dates.

Which of the following functions can be used to remove a specific set of characters from the left side of a set of data values?

When a format argument is included in a function, it must be enclosed in ____.

Which of the following functions determines the number of characters in a character string?

The ____________________ function can be used to determine the number of characters in a string.

Which of the following functions can be used to fill a character string to a specific width?

The ROUND ‾\underline {\text { ROUND } } ROUND ​ function can be used to round numeric data to the left or right of the decimal point. _________________________

When functions are nested, the ____ function is solved first.

The YR‾\underline{YR}YR​ element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date. _________________________

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 the number of days between the date an order was placed and the date it was shipped?

The TO_CHAR function can be used to format what types of data?

The ____ function can be used to convert dates and numbers to a formatted character string.

A(n) ____________________ date represents the number of days that have passed between a specified date and January 1, 4712, B.C.

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

The format argument in the TO_CHAR function must be enclosed in $\underline {\text { double }}$ quotation marks. _________________________

The $\underline {\text { ROUND } }$ function can be used to round numeric data to the left or right of the decimal point. _________________________

The $\underline{YR}$ element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date. _________________________