Multiple choice

Which of the following statements is a correct statement about dropping a Tablespace in the Oracle database?

  1. The dropped tablespace can be rolled back.

  2. The objects and data in it will no longer be available after a tablespace has been dropped.

  3. The objects of the dropped tablespaces will be available to the users.

  4. These objects of the dropped tablespaces can be recovered.

  5. The tablespaces cannot be dropped.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is correct and the objects and data cannot be used if anyone drops that tablespace.

Keep practicing — related questions