Question 1

​Which of the following represents the number of days that have passed since January 1,4712 B.C.?

Accepted Answer

A)  ​Cartesian date 
B)  ​Julian date 
C)  ​Extended date 
D)  ​none of the above 
A)  ​Cartesian date 
B)  ​Julian date 
C)  ​Extended date 
D)  ​none of the above

Question 2

​Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

Accepted Answer

A)  ​DECODE 
B)  ​DCD 
C)  ​IFTHEN 
D)  ​SELECTIF 
A)  ​DECODE 
B)  ​DCD 
C)  ​IFTHEN 
D)  ​SELECTIF

Question 3

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

​Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Accepted Answer

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

Question 5

​Which of the following keywords will return the value of the date according to the computer?

Accepted Answer

A)  ​SYSTEMDATE 
B)  ​SYSDATE 
C)  ​DATE 
D)  ​DATESYS 
A)  ​SYSTEMDATE 
B)  ​SYSDATE 
C)  ​DATE 
D)  ​DATESYS

Question 6

​Which of the following functions is similar to using the (| |)symbol to combine the contents of two character strings?

Accepted Answer

A)  ​CONCAT 
B)  ​CONCATENATION 
C)  ​CAT 
D)  ​CONCATEN 
A)  ​CONCAT 
B)  ​CONCATENATION 
C)  ​CAT 
D)  ​CONCATEN

Question 7

Which of the following functions can be used to convert a character string to upper-case letters?​

Accepted Answer

A)  ​UPPER 
B)  ​UP 
C)  ​UPPERCASE 
D)  ​UPPERCAP 
A)  ​UPPER 
B)  ​UP 
C)  ​UPPERCASE 
D)  ​UPPERCAP

Question 8

Contents of the CUSTOMERS table
   ​
Note: The ST column name is truncated,this represents the STATE column.
-Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as:
City,State Zip​

Accepted Answer

A)  SELECT INITCAP(CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',zip)))))
FROM customers; 
B)  SELECT CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',CONCAT(zip)))))
FROM customers; 
C)  SELECT INITCAP(CONCAT(city,',',state,' ',zip))
FROM customers; 
D)  ​none of the above 
A)  SELECT INITCAP(CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',zip)))))
FROM customers; 
B)  SELECT CONCAT(city,CONCAT(',',CONCAT(state,
CONCAT(' ',CONCAT(zip)))))
FROM customers; 
C)  SELECT INITCAP(CONCAT(city,',',state,' ',zip))
FROM customers; 
D)  ​none of the above

Question 9

The MONTHS_BETWEEN function can be used to determine the number of months between two dates​

Accepted Answer

A) True 
 B)False

Question 10

The NULLIF function is often combined with the NVL2 function to display a descriptive status._________________________​

Accepted Answer

A) True 
 B)False

Question 11

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The RTRIM function can be used to remove a specific set of characters from the right side of a set of data values._________________________​

Accepted Answer

A) True 
 B)False

Question 14

​Which of the following is a table provided in Oracle which can be helpful for testing functions?

Accepted Answer

A)  ​DUMMY 
B)  ​DUM 
C)  ​DUAL 
D)  ​EMPTY 
A)  ​DUMMY 
B)  ​DUM 
C)  ​DUAL 
D)  ​EMPTY

Question 15

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

​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 ship date for order 1006 as April 2,2002?

Accepted Answer

A)  ​SELECT order#,TO_CHAR(shipdate,'Month DD,YYYY')
FROM orders; 
B)  ​SELECT order#,TO_DATE(shipdate,'Month DD,YYYY')
FROM orders; 
C)  SELECT order#,TO_CHAR(shipdate,'Month DY,YYYY')
FROM orders; 
D)  SELECT order#,TO_DATE(shipdate,'Month DY,YYYY')
FROM orders; 
A)  ​SELECT order#,TO_CHAR(shipdate,'Month DD,YYYY')
FROM orders; 
B)  ​SELECT order#,TO_DATE(shipdate,'Month DD,YYYY')
FROM orders; 
C)  SELECT order#,TO_CHAR(shipdate,'Month DY,YYYY')
FROM orders; 
D)  SELECT order#,TO_DATE(shipdate,'Month DY,YYYY')
FROM orders;

Question 17

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

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 19

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 20

Include DAY in a format argument of the TO_CHAR function to spell out the day of the week in the specified date._________________________​

Accepted Answer

A) True 
 B)False

Which of the following represents the number of days that have passed since January 1,4712 B.C.?

Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

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

Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Which of the following keywords will return the value of the date according to the computer?

Which of the following functions is similar to using the (| |)symbol to combine the contents of two character strings?

Which of the following functions can be used to convert a character string to upper-case letters?

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as: City,State Zip

The MONTHS_BETWEEN function can be used to determine the number of months between two dates

The NULLIF function is often combined with the NVL2 function to display a descriptive status._________________________

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.

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

The RTRIM function can be used to remove a specific set of characters from the right side of a set of data values._________________________

Which of the following is a table provided in Oracle which can be helpful for testing functions?

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

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 ship date for order 1006 as April 2,2002?

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

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?

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?

Include DAY in a format argument of the TO_CHAR function to spell out the day of the week in the specified date._________________________

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

​Which of the following represents the number of days that have passed since January 1,4712 B.C.?

​Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

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

​Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

​Which of the following keywords will return the value of the date according to the computer?

​Which of the following functions is similar to using the (| |)symbol to combine the contents of two character strings?

Which of the following functions can be used to convert a character string to upper-case letters?​

Contents of the CUSTOMERS table ​ Note: The ST column name is truncated,this represents the STATE column. -Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as: City,State Zip​

The MONTHS_BETWEEN function can be used to determine the number of months between two dates​

The NULLIF function is often combined with the NVL2 function to display a descriptive status._________________________​

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.​

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

The RTRIM function can be used to remove a specific set of characters from the right side of a set of data values._________________________​

​Which of the following is a table provided in Oracle which can be helpful for testing functions?

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

​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 ship date for order 1006 as April 2,2002?

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

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

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?

Include DAY in a format argument of the TO_CHAR function to spell out the day of the week in the specified date._________________________​

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

Which of the following represents the number of days that have passed since January 1,4712 B.C.?

Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?

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

Which of the following format argument elements indicates that the name of the day of the week for the specified date should be displayed?

Which of the following keywords will return the value of the date according to the computer?

Which of the following functions is similar to using the (| |)symbol to combine the contents of two character strings?

Which of the following functions can be used to convert a character string to upper-case letters?

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Based upon the contents of the CUSTOMERS table,which of the following will display the shipping location as: City,State Zip

The MONTHS_BETWEEN function can be used to determine the number of months between two dates

The NULLIF function is often combined with the NVL2 function to display a descriptive status._________________________

The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.

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

The RTRIM function can be used to remove a specific set of characters from the right side of a set of data values._________________________

Which of the following is a table provided in Oracle which can be helpful for testing functions?

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

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 ship date for order 1006 as April 2,2002?

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

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?

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?

Include DAY in a format argument of the TO_CHAR function to spell out the day of the week in the specified date._________________________