READ Free Dumps For Oracle- 1z0-001
Question ID 8154 | Examine the table instance chart for the employee table. EMPLOYEE Column ID_NO NAME SALARY DEPT_NO name Key type PK FK NN, NN UU Nulls/unique FK table DEPARMENT FK column DEPT_NO Data type NUM NUM NUM DATE VARCHAR2 Length 9 25 8,2 3 You need to display the hire_date values in this format: 10 of October 1999 Which SELECT statement can you use? |
Option A | SELECT hire_date('fmDD "of"MONTH YYYY') "Date Hired" FROM employee; |
Option B | SELECT hire_date('DD "of"MONTH YYYY') "Date Hired" FROM employee; |
Option C | SELECT TO_CHAR (hire_date,'DDspth of MONTH YYYY') "Date Hired" FROM employee; |
Option D | SELECT TO_CHAR(hire_date,'fmDD "of" MONTH YYYY') "DATE HIRED" FROM employee; |
Correct Answer | D |
Question ID 8155 | Examine the table instance chart for the employee table. Column ID_NO NAME SALARY DEPT_NO name Key type PK FK NN, NN UU Nulls/unique FK table DEPARMENT FK column DEPT_NO Data type NUM NUM NUM DATE VARCHAR2 Length 9 25 8,2 3 You want to display employee hire date from the earliest to latest. Which SQL statement would you use? |
Option A | SELECT hire_date. FROM employee; |
Option B | SELECT hire_date. FROM employee ORDER BY hire_date; |
Option C | SELECT hire_date. FROM employee GROUP BY hire_date; |
Option D | SELECT hire_date. FROM employee ORDER BY hire_date DESC; |
Correct Answer | B |