AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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
Explanation Explanation/Reference: Explanation: Answer D is correct because it will display the hire_date in the format : 10 of October 1999, using string mask of TO_CHAR function. Incorrect Answers: A: Information will not be displayed correctly, syntax is wrong. B: Information will not be displayed correctly, syntax is wrong. C: Information will not be displayed correctly, result will be : 10th of October 1999. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 31-32 Chapter 1: Selecting Data from Oracle


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
Explanation Explanation/Reference: Explanation: Answer B is correct because ORDER BY clause will sort hire date from earliest to latest by default. Incorrect Answers: A: Results will not be sorted at all. C: Clause GROUP BY will not sort results, it used for different purposes. D: Keyword DESC of ORDER BY clause will sort the hire date from latest to earliest, not vice versa. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 19-20 Chapter 1: Selecting Data from Oracle

Send email to admin@getfreedumps for new dumps request!!!