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- 1z1-051





Question ID 4946

You need to design a student registration database that contains several tables storing academic information.
The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.
You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement
 
creates the foreign key?
 

Option A

A.    CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY students (student_id));
 

Option B

B.    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id));
 

Option C

C.    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));
 

Option D

D.    CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER (4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
 

Correct Answer D
Explanation


Question ID 4947

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
 

Option A

A.    It releases the storage space used by the table.
 

Option B

B.    It does not release the storage space used by the table.
 

Option C

C.    You can roll back the deletion of rows after the statement executes.
 

Option D

D.    You can NOT roll back the deletion of rows after the statement executes.
 

Option E

E.    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
 

Option F

F.    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate
 
the DEPT table
 

Correct Answer A,D,F
Explanation

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