Exam 1z0-051 topic 1 question 1 discussion

Actual exam question from Oracle's 1z0-051

Question #: 1
Topic #: 1

[All 1z0-051 Questions]

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

Show Suggested Answer

Suggested Answer: ADF 🗳️
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

by palif56347 at Dec. 19, 2023, 3:42 p.m.

Comments

Submit Cancel

alansari

2 months ago

Selected Answer: ADF

A - because it deletes all data from table and do auto-commit. D - due to its auto-commit, it can't be rollback F - You must have rights to delete or truncate table.

upvoted 1 times

...

Exam 1z0-051 All Questions

View all questions & answers for the 1z0-051 exam

Exam 1z0-051 topic 1 question 1 discussion

Comments

alansari

SY0-701