Oracle Oracle Database SQL Fundamentals I 1z0-051题库.pdfVIP

s@lm@n Oracle Exam 1z0-051 Oracle Database: SQL Fundamentals I Version: 6.13 [ Total Questions: 292 ] 买题库 QQ:860424807 Oracle 1z0-051 : Practice Test Topic 1, Volume A Question No : 1 - (Topic 1) Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.) A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C. You can roll back the deletion of rows after the statement executes. D. You can NOT roll back the deletion of rows after the statement executes. E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error. F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table Answer: A,D,F Explanation: A: The TRUNCATE TABLE Statement releases storage space used by the table, D: Can not rollback the deletion of rows after the statement executes, F: You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the DEPT table. Incorrect answer: Cis not true Dis not true Eis not true Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-18 Question No : 2 - (Topic 1) You need to design a student registration database that contains several tables storing academic information. 2 买题库 QQ:860424807 Oracle 1z0-051 : Practice Test The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the students 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 k