databases Online Quiz - 226
|Description: databases Online Quiz - 226|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which section of a PL/SQL block commences with the BEGIN keyword?
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?
SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?
Which statement describes the ROWID data type?
Can we abbreviate keywords across lines?e.g. DESCRIBE
What is the correct use of the Trunc command on a date?
Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?
Which of the following tasks can be performed by using the TO_CHAR function?
Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?
Which operators can be used in an outer join condition?