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 8073

The employee table contains these columns. LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPT_ID NUMBER(9) You need to display the names of the employees that are not assigned to the department. Evaluate this SQL statement. SELECT last_name, first_nameFROM employee WHERE dept_id is NULL Which change should you make to achieve the desired result?

Option A

Create an outer join. B. Change the column in

Option B

Change the column in the where condition.

Option C

Change the operator in the where condition

Option D

Add a second condition to the where condition

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because the NULL operator need to be changed in the WHERE condition to display correct result. Incorrect Answers: A: One table is used for query, so there is no reason to use outer join operation. B: The column in the WHERE condition is correct and don't need to be changed. D: Query does not require additional condition to extract correct data. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 10-11 Chapter 1: Selecting data from Oracle


Question ID 8074

Which statement about SQL is true?

Option A

Null values are displayed last in the ascending sequences.

Option B

Data values are displayed in descending order by default.

Option C

You cannot specify a column alias in an ORDER BY clause.

Option D

You cannot sort query results by a column that is not included in the SELECT list.

Option E

The results are sorted by the first column in the SELECT list, if the ORDER BY clause is not provided.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because of null values are displayed last in the ascending sequences. Incorrect Answers: B: Data values are displayed in ASCENDING order by default. C: It is possible to specify a column alias in an ORDER BY clause (but not in a GROUP BY clause). D: You can sort query results by a column that is not included in the SELECT list. E: The results will not be sorted at all, if the ORDER BY clause was not used in query. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 18-19 Chapter 8: Selecting Data from Oracle

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