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 8106

The product table contains these columns. ID NUMBER(9) PK COST NUMBER(7,2) SALE_PRICE NUMBER(7,2) Management has asked you to calculate the net revenue per unit for each product, if the cost of each product is increased by 10% and the sale price of each product is increased by 25%. You issue this SQL statement. SELECT id, sale_price * 1.25 - cost * 1.10FROM product; Which conclusion can you draw from the results?

Option A

Only the required results are displayed.

Option B

The results provide more information than management requested.

Option C

A function needs to be included in the SELECT statement to achieve the desired result.

Option D

The order on the operations in the calculation needs to be changed to achieve the required results.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because only the requested results will be displayed. Incorrect Answers: B: This query returns only information requested by management. C: There is no need to use additional function to display desired results. D: The order of operations is correct and does not need to be changed. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 6-8 Chapter 1: Selecting data from Oracle


Question ID 8107

You want to create report to show different jobs in each department. You do not want to display any duplicate roles in the report. Which SELECT statement do you use to create the report?

Option A

SELECT deptno, job FROM emp;

Option B

SELECT no duplicate deptno, job FROM emp;

Option C

SELECT distinct deptno, job FROM emp;

Option D

CREATE report DISPLAY deptno, job FROM emp;

Option E

SELECT distinct deptno, distinct job FROM emp;

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because this query uses keyword DISTINCT which allows to avoid duplications in displayed results. Incorrect Answers: A: This statement returns results with duplications. B: NO DUPLICATE is wrong syntax in SELECT statement. D: CREATE REPORT is wrong syntax in SELECT statement. E: Keyword DISTINCT does not need to be used for each column in the list of SELECT statement. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 70-71 Chapter 2: Advanced Data Selection in Oracle

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