You must display details of all users whose username contains the string 'ch_'.
Which query generates the required output? (Choose the best answer.)

Which three statements are correct regarding indexes? (Choose three.)

Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?

Which three statements are true regarding group functions? (Choose three.)

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)

You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result? (Choose two.)