Question 1

LOWER,UPPER,and INITCAP functions are all character manipulation functions._________________________​

Accepted Answer

A) True 
 B)False  False

Question 2

The ADD_MONTHS function is used to add one month to a specified date.​

Accepted Answer

A) True 
 B)False  False

Question 3

A Julian date represents the number of hours that have passed since January 1,4712 B.C._________________________​

Accepted Answer

A) True 
 B)False  False

Question 4

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

The 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 6

The format argument in the TO_CHAR function must be enclosed in double quotation marks._________________________​

Accepted Answer

A) True 
 B)False

Question 7

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 8

The UPPER function can be used to display upper-case characters in lower-case._________________________​

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ function allows a user to enter a date in a variety of formats,and then changes the value to the default Oracle12c internal storage format.​

Accepted Answer

The answer of The ____________________ function allows a user to...

Question 10

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.​

Accepted Answer

A) True 
 B)False

Question 11

Which of the following refers to a predefined block of code?​

Accepted Answer

A)  ​parameters 
B)  ​arguments 
C)  ​functions 
D)  ​syntax 
A)  ​parameters 
B)  ​arguments 
C)  ​functions 
D)  ​syntax

Question 12

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

Accepted Answer

There are two single-row functions that

Question 13

The ____________________ function is used to substitute a specified value for a NULL value.​

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.​

Accepted Answer

A) True 
 B)False

Question 17

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

The ____________________ keyword is used to return the value of the date according to the computer.​

Accepted Answer

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

Question 19

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 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 days...

LOWER,UPPER,and INITCAP functions are all character manipulation functions._________________________

The ADD_MONTHS function is used to add one month to a specified date.

A Julian date represents the number of hours that have passed since January 1,4712 B.C._________________________

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

The ROUND function can be used to round numeric data to the left or right of the decimal point._________________________

The format argument in the TO_CHAR function must be enclosed in double quotation marks._________________________

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

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

The ____________________ function allows a user to enter a date in a variety of formats,and then changes the value to the default Oracle12c internal storage format.

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

Which of the following refers to a predefined block of code?

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

The ____________________ function is used to substitute a specified value for a NULL value.

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

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.

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

The ____________________ keyword is used to return the value of the date according to the computer.

Which of the following is an accurate statement?

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

LOWER,UPPER,and INITCAP functions are all character manipulation functions._________________________​

The ADD_MONTHS function is used to add one month to a specified date.​

A Julian date represents the number of hours that have passed since January 1,4712 B.C._________________________​

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

The ROUND function can be used to round numeric data to the left or right of the decimal point._________________________​

The format argument in the TO_CHAR function must be enclosed in double quotation marks._________________________​

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

The UPPER function can be used to display upper-case characters in lower-case._________________________​

The ____________________ function allows a user to enter a date in a variety of formats,and then changes the value to the default Oracle12c internal storage format.​

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.​

Which of the following refers to a predefined block of code?​

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

The ____________________ function is used to substitute a specified value for a NULL value.​

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

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.​

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

The ____________________ keyword is used to return the value of the date according to the computer.​

Which of the following is an accurate statement?​

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

LOWER,UPPER,and INITCAP functions are all character manipulation functions._________________________

The ADD_MONTHS function is used to add one month to a specified date.

A Julian date represents the number of hours that have passed since January 1,4712 B.C._________________________

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

The ROUND function can be used to round numeric data to the left or right of the decimal point._________________________

The format argument in the TO_CHAR function must be enclosed in double quotation marks._________________________

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

The ____________________ function allows a user to enter a date in a variety of formats,and then changes the value to the default Oracle12c internal storage format.

A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.

Which of the following refers to a predefined block of code?

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

The ____________________ function is used to substitute a specified value for a NULL value.

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

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

The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.

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

The ____________________ keyword is used to return the value of the date according to the computer.

Which of the following is an accurate statement?

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