Question 1

The INITIALCAP function can be used to convert character strings to mixed-case characters.

Accepted Answer

A) True 
 B)False

Question 2

When functions are nested, the $\underline {\text { inner }}$ function is solved first. _________________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY'), -4, 4) in the SELECT clause, which of these functions will be executed first?

Accepted Answer

A)  TO_CHAR 
B)  SUBSTR 
C)  MONTH 
D)  YYYY 
A)  TO_CHAR 
B)  SUBSTR 
C)  MONTH 
D)  YYYY

Question 5

Identify the single-row functions used with NULL values and describe their purpose.

Accepted Answer

There are two single-row functions that

Question 6

Contents of the CUSTOMERS table
   
Note: The ST column name is truncated, this represents the STATE column.
-Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table?

Accepted Answer

A)  SELECT INITCAP(firstname, lastname) FROM customers; 
B)  SELECT LENGTH (city, state, zip) FROM customers; 
C)  SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers; 
D)  SELECT INITCAP((firstname),( lastname)) FROM customers; 
A)  SELECT INITCAP(firstname, lastname) FROM customers; 
B)  SELECT LENGTH (city, state, zip) FROM customers; 
C)  SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers; 
D)  SELECT INITCAP((firstname),( lastname)) FROM customers;

Question 7

Which of the following functions can be used to substitute another value for a NULL value during calculations?

Accepted Answer

A)  NVL 
B)  NULLVAL 
C)  NULVAL 
D)  NLV 
A)  NVL 
B)  NULLVAL 
C)  NULVAL 
D)  NLV

Question 8

Case conversion functions can only be used in the SELECT clause of a SELECT statement.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following functions is used to determine the number of months between two date values?

Accepted Answer

A)  MONTH_BETWEEN 
B)  MONTHS_BETWEEN 
C)  MTH_BETWEEN 
D)  MNTH_BETWEEN 
A)  MONTH_BETWEEN 
B)  MONTHS_BETWEEN 
C)  MTH_BETWEEN 
D)  MNTH_BETWEEN

Question 10

Single-row functions return one row of results for each group or category of rows processed.

Accepted Answer

A) True 
 B)False

Question 11

Use MON in the format argument to spell out the specified month.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following functions can be used to determine the next occurrence of a specific day of the week after a given date?

Accepted Answer

A)  NEXT_DATE 
B)  DATE_NEXT 
C)  NEXT_DAY 
D)  NEXT_DDD 
A)  NEXT_DATE 
B)  DATE_NEXT 
C)  NEXT_DAY 
D)  NEXT_DDD

Question 13

To indicate that minutes should be displayed, include ____________________ in the time element format argument.

Accepted Answer

The answer of To indicate that minutes should be displayed,...

Question 14

The DECODE function allows the user to specify different actions to be taken, depending on the value being used for the comparison.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following functions allows for different options, depending upon whether a NULL value exists?

Accepted Answer

A)  NVL 
B)  IFNL 
C)  IFNVL 
D)  NVL2 
A)  NVL 
B)  IFNL 
C)  IFNVL 
D)  NVL2

Question 16

If the two values compared by the NULLIF function are equal, what value does the function return?

Accepted Answer

A)  The first value in the comparison 
B)  NULL 
C)  The second value in the comparison 
D)  Both values in the comparison 
A)  The first value in the comparison 
B)  NULL 
C)  The second value in the comparison 
D)  Both values in the comparison

Question 17

Which of the following format elements will display 1:00 p.m. as 13?

Accepted Answer

A)  HH 
B)  HR 
C)  HH24 
D)  24 
A)  HH 
B)  HR 
C)  HH24 
D)  24

Question 18

Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle11g?

Accepted Answer

A)  TO_CHAR 
B)  TO_DATE 
C)  DEFAULT 
D)  DATE 
A)  TO_CHAR 
B)  TO_DATE 
C)  DEFAULT 
D)  DATE

Question 19

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 will display the shipping location as: Shipcity, Shipstate Shipzip

Accepted Answer

A)  SELECT INITIALCAP(CONCAT(shipcity, shipstate, shipzip))
FROM orders; 
B)  SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,
CONCAT(' ', shipzip)))))
FROM orders; 
C)  SELECT INITCAP((CONCAT(shipcity, shipstate, shipzip))
FROM orders; 
D)  SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,
CONCAT(' ', CONCAT(shipzip))))))
FROM orders; 
A)  SELECT INITIALCAP(CONCAT(shipcity, shipstate, shipzip))
FROM orders; 
B)  SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,
CONCAT(' ', shipzip)))))
FROM orders; 
C)  SELECT INITCAP((CONCAT(shipcity, shipstate, shipzip))
FROM orders; 
D)  SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate,
CONCAT(' ', CONCAT(shipzip))))))
FROM orders;

Question 20

To indicate that the three-letter abbreviation for day of the week should be displayed, include ____________________ in the date element format argument.

Accepted Answer

The answer of To indicate that the three-letter abbreviation for...

The INITIALCAP function can be used to convert character strings to mixed-case characters.

When functions are nested, the $\underline {\text { inner }}$ function is solved first. _________________________

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

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY'), -4, 4) in the SELECT clause, which of these functions will be executed first?

Identify the single-row functions used with NULL values and describe their purpose.

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table?

Which of the following functions can be used to substitute another value for a NULL value during calculations?

Case conversion functions can only be used in the SELECT clause of a SELECT statement.

Which of the following functions is used to determine the number of months between two date values?

Single-row functions return one row of results for each group or category of rows processed.

Use MON in the format argument to spell out the specified month.

Which of the following functions can be used to determine the next occurrence of a specific day of the week after a given date?

To indicate that minutes should be displayed, include ____________________ in the time element format argument.

The DECODE function allows the user to specify different actions to be taken, depending on the value being used for the comparison.

Which of the following functions allows for different options, depending upon whether a NULL value exists?

If the two values compared by the NULLIF function are equal, what value does the function return?

Which of the following format elements will display 1:00 p.m. as 13?

Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle11g?

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 will display the shipping location as: Shipcity, Shipstate Shipzip

To indicate that the three-letter abbreviation for day of the week should be displayed, include ____________________ in the date element format argument.

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 INITIALCAP function can be used to convert character strings to mixed-case characters.

When functions are nested, the inner ‾\underline {\text { inner }} inner ​ function is solved first. _________________________

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

If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY'), -4, 4) in the SELECT clause, which of these functions will be executed first?

Identify the single-row functions used with NULL values and describe their purpose.

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table?

Which of the following functions can be used to substitute another value for a NULL value during calculations?

Case conversion functions can only be used in the SELECT clause of a SELECT statement.

Which of the following functions is used to determine the number of months between two date values?

Single-row functions return one row of results for each group or category of rows processed.

Use MON in the format argument to spell out the specified month.

Which of the following functions can be used to determine the next occurrence of a specific day of the week after a given date?

To indicate that minutes should be displayed, include ____________________ in the time element format argument.

The DECODE function allows the user to specify different actions to be taken, depending on the value being used for the comparison.

Which of the following functions allows for different options, depending upon whether a NULL value exists?

If the two values compared by the NULLIF function are equal, what value does the function return?

Which of the following format elements will display 1:00 p.m. as 13?

Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle11g?

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 will display the shipping location as: Shipcity, Shipstate Shipzip

To indicate that the three-letter abbreviation for day of the week should be displayed, include ____________________ in the date element format argument.

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

When functions are nested, the $\underline {\text { inner }}$ function is solved first. _________________________