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 1506

Examine the structure of the STUDENT table:
Name Null? Type        
        

STUD_ID NOT NULL NUMBER(3) NAME NOT NULL VARCHAR2(25) ADDRESS VARCHAR2(50)
GRADUATION DATE
Graduation column is a foreign key column to the GRADDATE table.
 
Examine the data in the GRADDATE table: GRADUATION
20-JAN-1999 12-MAY-1999 19-JAN-2000 25-MAY-2000 13-JAN-2001 29-MAY-2001
Which update statement produces the following error?
ORA-02291: integrity constraint (SYS_C23) violated - parent key not found
 

Option A

A.    UPDATE student SET name = 'Smith', graduation = '15-AUG-2000'
WHERE stud_id = 101;
 

Option B

B.    UPDATE studentD.UPDATE student SET stud_id = NULL,
address = '100 Main Street'
WHERE graduation = '20-JAN-1999';
 

Option C

C.    UPDATE student SET name = 'Smith', graduation = '29-MAY-2001'
WHERE stud_id = 101;
 

Option D

D.    UPDATE student SET stud_id = 999, graduation = '29-MAY-2001'
WHERE stud_id = 101;
 

Correct Answer A
Explanation


Question ID 1507

The EMPLOYEE table contains these columns: FIRST_NAMEVARCHAR2(25) COMMISSION NUMBER(3,2)
Evaluate this SQL statement: SELECT first_name, commission
FROM employee
WHERE commission = (SELECTcommission FROMemployee
WHEREUPPER(first_name) = 'SCOTT')
What would cause this statement to fail?
 

Option A

A.    Scott has a NULL commission value.
 

Option B

B.    There is no employee with the first name Scott
 

Option C

C.    The FIRST_NAME values in the database are in lowercase.
 

Option D

D.    Scott has a zero commission value.
 

Option E

E.    There is more than one employee with the first name Scott.
 

Correct Answer E
Explanation

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