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. |
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 |
Question ID 4947 | Evaluate the SQL statement: |
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 |
Correct Answer | A,D,F |