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 1633

You have decided to disable the PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column.
What happens when you try to enable the constraints after the update is completed?
 

Option A

A.    You need to recreate the constraints once they are disabled.
 

Option B

B.    The indexes on both the columns with the PRIMARY KEY constraint and the CHECK constraint are automatically re-created.

 

Option C

C.    Any existing rows that do not confirm with the constraints are automatically deleted.
 

Option D

D.    All the existing column values are verified to confirm with the constraints and an error message is generated if any existing values do not confirm.
 

Option E

E. Only the future values are verified to confirm with the constraints, leaving the existing values unchecked.

Correct Answer D
Explanation


Question ID 1634

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 declaration section:
DECLARE
TYPE dept_record_type IS RECORD
(dno NUMBER,
name VARCHAR2(20));
dept_rec dept_record_type;
How do you retrieve an entire row of the DEPT table using the DEPT_REC variable?
 

Option A

A.    SELECT *
INTO dept_rec.dno, dept_rec.name, dept_rec.loc
FROM dept
WHERE deptno = 10;
 

Option B

B.    You can not retrieve the entire row using the DEPT_REC variable declared in the code.
 

Option C

C.    SELECT deptno, dname, loc INTO dept_rec
FROM dept
WHERE deptno = 10;

 

Option D

D.    SELECT * INTO dept_rec
FROM dept
WHERE deptno = 10;

Correct Answer B
Explanation

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