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 8081

Examine the structure of STUDENT table. Name Null? Type. STUD-ID NOT NULL NUMBER(3) NAME NOT NULL VARCHER2(25) ADDRESS VARCHER2(50) GRADUATION DATE.Which statement inserts a new row into the STUDENT table?

Option A

INSERT INTO student VALUES(101, 'Smith');

Option B

INSERT INTO student VALUES(101, '100 Main Street', '17-JUN-99', 'Smith');

Option C

INSERT INTO test VALUES(101, 'Smith', '100 Main Street', '17-JUN-99');

Option D

INSERT INTO student (stud-id,address,gradulation) VALUES(101, 'Smith', '100 Main Street', '17-JUN-99');

Option E

INSERT INTO student ( (stud-id,address,name,gradulation) VALUES(101, '100 Main Street','Smith', '17- JUN-99');

Correct Answer E
Explanation Explanation/Reference: Explanation: Answer E is correct because you need to show ALL columns and in correct order for values which you try to insert into table STUDENT. Incorrect Answers: A: You need to show ALL columns for values, which you try to insert into table STUDENT. B: You need to show columns in correct order for values, which you try to insert into table STUDENT. In this statement Name is located in wrong place according table definition. C: This statement contains wrong table name TEST, not STUDENT. D: This statement shows list of only 3 columns when there are 4 values need to be inserted into table row. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 120-122 Chapter 4: Creating Oracle Database Objects


Question ID 8082

Examine the structure of the STUDENT table. NAME NULL TYPE STUDENT_ID NOT NULL NUMBER(3) NAME NOT NULL VARCHAR2(25) ADDRESS VARCHAR2(50) GRADUATION DATE Graduation column is a foreign key column to the graduate table. Examine the data in the GRADUATE 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

UPDATE student SET stud-id=999, graduation= '29-MAY-2001' WHERE stud-id=101;'

Option B

UPDATE student SET name= 'Smith', graduation= '29-MAY-2001' WHERE stud-id=101;

Option C

UPDATE student SET name= 'Smith', graduation= '15-AUG-2000' WHERE stud-id=101

Option D

UPDATE student SET stud-id=NULL, address= '100 Main Street' WHERE graduation= '20-JAN-1999'

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because there is no '15-AUG-2000' value in the graduate table. Foreign constraint for this statement will be violated because parent key not found. Incorrect Answers: A: There is '29-MAY-2001' in the graduate table and foreign constraint will not be violated. B: There is '29-MAY-2001' in the graduate table and foreign constraint will not be violated. D: There is '20-JUN-1999' in the graduate table and foreign constraint will not be violated. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 428-433 Chapter 9: Managing Database Objects II

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