Exam 1z0-082 topic 1 question 174 discussion

Actual exam question from Oracle's 1z0-082

Question #: 174
Topic #: 1

TBS1 is a permanent user-defined tablespace. Oracle Managed Files (OMF) is not used in this database.

Examine this command:

DROP TABLESPACE tbsl;

Which two will ensure that TBS1 is dropped and its datafiles are deleted from the file system? (Choose two.)

A. TBS1 must not contain any temp files.
B. There must be no uncommitted transactions involving segments stored in TBS1.
C. TBS1 must be READ WRITE.
D. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
E. TBS1 must be altered READ ONLY.

Show Suggested Answer

Suggested Answer: AD 🗳️

by SCCUser at Nov. 14, 2024, 2:40 p.m.

Comments

Submit Cancel

cf1f99b

1 month, 2 weeks ago

Selected Answer: BD

A is incorrect for permanent tablespaces. The presence of temp files is unrelated to dropping a permanent tablespace as temp files are associated with temporary tablespaces

upvoted 2 times