Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »
Which three statements are true about single-row functions? (Choose three.) A. They return a single result row per table B. The argument can be a column name, variable, literal or an expression C. They can accept only one argument D. They can be nested to any level E. The data type returned can be different from the data… Read More »
Which statement is true about aggregate functions? A. The MAX and MIN functions can be used on columns with character data types B. Aggregate functions can be nested to any number of levels C. The AVG function implicitly converts NULLS to zero D. Aggregate functions can be used in any clause of a SELECT statement Correct Answer: B
Which two statements are true about single row functions? (Choose two.) A. MOD : returns the quotient of a division operation B. FLOOR : returns the smallest integer greater than or equal to a specified number C. TRUNC : can be used with NUMBER and DATE values D. CONCAT : can be used to combine any number of… Read More »
Which three statements are true about single-row functions? (Choose three.) A. They can be used only in the WHERE clause of a SELECT statement B. The argument can be a column name, variable, literal or an expression C. The data type returned can be different from the data type of the argument D. They can be nested to… Read More »
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server C. CURRENT_DATE returns… Read More »
Which two statements are true about single row functions? (Choose two.) A. MOD : returns the quotient of a division operation B. FLOOR : returns the smallest integer greater than or equal to a specified number C. TRUNC : can be used with NUMBER and DATE values D. CONCAT : can be used to combine any number of… Read More »
Which two functions are performed by a listener? A. creating a user session in the System Global Area (SGA) B. returning the results of processing from the server process to the user process C. maintaining the connection to a client’s user process until the user request is completed D. verifying the service name in an incoming user request… Read More »
Which statement is true about aggregate functions? A. Aggregate functions can be used in any clause of a SELECT statement B. The AVG function implicitly converts NULLS to zero C. The MAX and MIN functions can be used on columns with character data types D. Aggregate functions can be nested to any number of levels Correct Answer: D
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system… Read More »