READ Free Dumps For Oracle- 1z0-007
| Question ID 1657 |
Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)
|
| Option A | A. INTERVAL YEAR TO MONTH
|
| Option B | B. INTERVAL DAY TO SECOND |
| Option C | C. TIMESTAMP |
| Option D | D. INTERVAL MONTH TO DAY |
| Option E | E. TIMESTAMP WITH DATABASE TIMEZONE |
| Correct Answer | A,B,C |
| Question ID 1659 | Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? |
| Option A | A. SELECT ename, salary*12 'Annual Salary' FROM employees; |
| Option B | B. SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees |
| Option C | C. SELECT ename, salary*12 "Annual Salary" FROM employees; |
| Option D | D. SELECT ename, salary*12 AS Annual Salary FROM employees; |
| Correct Answer | C |