Question 1

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

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

Accepted Answer

A)  ​LOW 
B)  ​LOWER 
C)  ​SMALLER 
D)  ​SMALLCAP 
A)  ​LOW 
B)  ​LOWER 
C)  ​SMALLER 
D)  ​SMALLCAP

Question 3

The INSTR function is used to return a portion of a character string.​

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

The ____________________ function is used to determine the next occurrence of a specific day of the week after a given date.​

Accepted Answer

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

Question 6

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

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

Accepted Answer

A) True 
 B)False

Question 8

The ROUND function can be used to truncate numeric data._________________________​

Accepted Answer

A) True 
 B)False

Question 9

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 10

Contents of the CUSTOMERS table
   ​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

Accepted Answer

A)  ​SELECT LOWER(name)FROM customers; 
B)  ​SELECT LOWER(firstname)|| ' ' || LOWER(lastname)FROM customers; 
C)  ​SELECT CONCAT(LOWER(firstname),' ',LOWER(lastname))FROM customers; 
D)  ​none of the above 
A)  ​SELECT LOWER(name)FROM customers; 
B)  ​SELECT LOWER(firstname)|| ' ' || LOWER(lastname)FROM customers; 
C)  ​SELECT CONCAT(LOWER(firstname),' ',LOWER(lastname))FROM customers; 
D)  ​none of the above

Question 11

The ____________________ function is used to return a portion of a string.​

Accepted Answer

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

Question 12

To indicate that the numeric value of the day of the year for a date is being specified,include DAY in format argument of the TO_DATE function.​

Accepted Answer

A) True 
 B)False

Question 13

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.​

Accepted Answer

A) True 
 B)False

Question 14

Contents of the CUSTOMERS table
   ​
Note: The ST column name is truncated,this represents the STATE column.
-​Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

Accepted Answer

A)  SELECT customer#,city,SUBSTR(state,'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
B)  SELECT customer#,city,SUBSTR( 'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
C)  SELECT customer#,city,REPLACE( 'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
D)  SELECT customer#,city,REPLACE(state,'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
A)  SELECT customer#,city,SUBSTR(state,'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
B)  SELECT customer#,city,SUBSTR( 'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
C)  SELECT customer#,city,REPLACE( 'FL','FLORIDA')FROM customers
WHERE state = 'FL'; 
D)  SELECT customer#,city,REPLACE(state,'FL','FLORIDA')FROM customers
WHERE state = 'FL';

Question 15

Which of the following statements will produce the value 21.1?​

Accepted Answer

A)  ​SELECT ROUND(21.12,1)FROM dual; 
B)  ​SELECT ROUND(21.12,-1)FROM dual; 
C)  ​SELECT ROUND(21.12,0)FROM dual; 
D)  ​none of the above 
A)  ​SELECT ROUND(21.12,1)FROM dual; 
B)  ​SELECT ROUND(21.12,-1)FROM dual; 
C)  ​SELECT ROUND(21.12,0)FROM dual; 
D)  ​none of the above

Question 16

​A(n)____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

Accepted Answer

The answer of ​A(n)____________________ is a predefined block of code...

Question 17

Describe the order in which Oracle12c resolves nested functions.​

Accepted Answer

The inner function is solved f

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ function is used to combine two sets of character strings into one set.​

Accepted Answer

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

Question 20

The NVL2 function allows different options to be selected,based upon whether a NULL value exists._________________________​

Accepted Answer

A) True 
 B)False

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

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

The INSTR function is used to return a portion of a character string.

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

The ____________________ function is used to determine the next occurrence of a specific day of the week after a given date.

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

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

The ROUND function can be used to truncate numeric data._________________________

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

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

The ____________________ function is used to return a portion of a string.

To indicate that the numeric value of the day of the year for a date is being specified,include DAY in format argument of the TO_DATE function.

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

Which of the following statements will produce the value 21.1?

A(n)____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

Describe the order in which Oracle12c resolves nested functions.

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

The ____________________ function is used to combine two sets of character strings into one set.

The NVL2 function allows different options to be selected,based upon whether a NULL value exists._________________________

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 functions can be used to determine the next occurrence of a specific day of the week after a given date?

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

The INSTR function is used to return a portion of a character string.​

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

The ____________________ function is used to determine the next occurrence of a specific day of the week after a given date.​

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

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

The ROUND function can be used to truncate numeric data._________________________​

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

Contents of the CUSTOMERS table ​ Note: The ST column name is truncated,this represents the STATE column. -​Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

The ____________________ function is used to return a portion of a string.​

To indicate that the numeric value of the day of the year for a date is being specified,include DAY in format argument of the TO_DATE function.​

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.​

Contents of the CUSTOMERS table ​ Note: The ST column name is truncated,this represents the STATE column. -​Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

Which of the following statements will produce the value 21.1?​

​A(n)____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

Describe the order in which Oracle12c resolves nested functions.​

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

The ____________________ function is used to combine two sets of character strings into one set.​

The NVL2 function allows different options to be selected,based upon whether a NULL value exists._________________________​

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 functions can be used to determine the next occurrence of a specific day of the week after a given date?

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

The INSTR function is used to return a portion of a character string.

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

The ____________________ function is used to determine the next occurrence of a specific day of the week after a given date.

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

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

The ROUND function can be used to truncate numeric data._________________________

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

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table?

The ____________________ function is used to return a portion of a string.

To indicate that the numeric value of the day of the year for a date is being specified,include DAY in format argument of the TO_DATE function.

You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.

Contents of the CUSTOMERS table Note: The ST column name is truncated,this represents the STATE column. -Which of the following statements will display the value of FL assigned to the state column as FLORIDA?

Which of the following statements will produce the value 21.1?

A(n)____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

Describe the order in which Oracle12c resolves nested functions.

The ____________________ function is used to combine two sets of character strings into one set.

The NVL2 function allows different options to be selected,based upon whether a NULL value exists._________________________