databases Online Quiz - 32
Description: databases Online Quiz - 32 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results?
Which two are character manipulation functions? (Choose two.)
Which clause should you use to exclude group results?
Which is an /SQL*Plus command?
What does the TRUNCATE statement do?
Which substitution variable would you use if you want to reuse the variable value without prompting the user each time?
Which two statements about views are true? (Choose two)
Evaluate the SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed?
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?