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 1627

The structure of the DEPT table is as follows:
Name Null? Type
DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14)
LOC VARCHAR2(13)
Examine the code:
DECLARE
TYPE dept_record_type IS RECORD
(dno NUMBER,
name VARCHAR2(20));
dept_rec dept_record_type;
BEGIN
SELECT deptno, dname
INTO dept_rec
FROM dept
WHERE deptno = 10; END;
Which statement displays the name of the selected department?
 

Option A

A.    DBMS_OUTPUT.PUT_ LINE(dept_rec.name);
 

Option B

B.    DBMS_OUTPUT.PUT_ LINE(dname);
 

Option C

C.    DBMS_OUTPUT.PUT_ LINE(dept_rec.dname);
 

Option D

D.    DBMS_OUTPUT.PUT_ LINE(name);

 

Option E

E.    DBMS_OUTPUT.PUT_ LINE(dept_rec(name));

Correct Answer A
Explanation


Question ID 1628

You need to create a report to display the ship date and order totals of your ORDER table. If the order has not been shipped, your report must display 'Not Shipped'. If the total is not available, your report must display 'Not Available'.
In the ORDER table, the SHIPDATE column has a datatype of DATE. The TOTAL column has a datatype of NUMBER.
Which statement do you use to create this report?
 

Option A

A.    SELECT ordid, NVL(shipdate, 'Not Shipped'), NVL(total,'Not Available')
FROM order;

 

Option B

B.    SELECT ordid, shipdate "Not Shipped", total "Not Available"
FROM order;
 

Option C

C.    SELECT ordid, NVL(TO_CHAR(shipdate), 'Not Shipped'), NVL(TO_CHAR(total),'Not Available')
FROM order;
 

Option D

D.    SELECT ordid,TO_CHAR(shipdate, 'Not Shipped'), TO_CHAR(total,'Not Available')
FROM order;

Correct Answer C
Explanation

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