Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the
SQL statement? (Choose three.)
A.
It does not release the storage space used by the table.
B.
You can roll back the deletion of rows after the statement executes.
C.
You can NOT roll back the deletion of rows after the statement executes.
D.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement
executes will display an error.
E.
You must be the owner of the table or have DELETE ANY TABLE system privileges to
truncate the DEPT table
F.
It releases the storage space used by the table.
E is not correct. It should be “DROP ANY TABLE”
refer : http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10006.htm
Prerequisites
To truncate a table or cluster, the table or cluster must be in your schema or you must have DROP ANY TABLE system privilege.
maybe the transcription is incorrect because istrue you cannot truncate tables if you arent the owner with the delete any table privs.
just 2 statements are correct C and F
Yes..
Correct Answer: C, E, F
Cleared Oracle Database 11g 1Z0-051 exam last weekend!
Scored 90%! (The passing score is 60%)
There were 64 questions in my actual 1Z0-051 test.
Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.
Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!
I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive:
drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!
These seem old and out of date. Some are copies from Transcender test that is out of date also.