Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Oracle SQL

Computing

Quiz 10 :

Selected Single Row Functions

Quiz 10 :

Selected Single Row Functions

search
arrow
The ADD_MONTHS function is used to add one month to a specified date.
Free
True False
Answer:

Answer:

False

arrow
The LENGTH function is used to determine the number of rows in a table.
Free
True False
Answer:

Answer:

False

arrow
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.
Free
True False
Answer:

Answer:

True

arrow
The LTRIM function can be used to remove a specific number of characters from the left side of a set of data.
True False
Answer:
arrow
Case conversion functions can only be used in the SELECT clause of a SELECT statement.
True False
Answer:
arrow
Character functions can be used to change the case of characters or to manipulate characters.
True False
Answer:
arrow
The INSTR function is used to return a portion of a character string.
True False
Answer:
arrow
LOWER, UPPER, and INITCAP functions are all character manipulation functions.
True False
Answer:
arrow
Single-row functions return one row of results for each group or category of rows processed.
True False
Answer:
arrow
The INITIALCAP function can be used to convert character strings to mixed-case characters.
True False
Answer:
arrow
The REPLACE function is used to substitute one character string for another character string in a set of data.
True False
Answer:
arrow
A Julian date is the number of days that have passed between a specific date and January 1, 4712 B.C.
True False
Answer:
arrow
The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.
True False
Answer:
arrow
To calculate the difference between two date columns, you must use the TO_DATE function.
True False
Answer:
arrow
The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.
True False
Answer:
arrow
The LOWER function can be used to display upper-case characters in lower-case.
True False
Answer:
arrow
The NEXT_DAY function is used to determine the next occurrence of a specific day of the week that will occur after the specified date.
True False
Answer:
arrow
The MONTHS_BETWEEN function can be used to determine the number of months between two dates.
True False
Answer:
arrow
When a function is used in a SELECT statement, it only affects how the data are displayed in the results.
True False
Answer:
arrow
The CONCAT function is used to store the contents of two columns into one column.
True False
Answer:
Showing 1 - 20 of 133