Multiple choice

When creating a new database by issuing CREATE DATABASE, what should be done to prevent users from using the SYSTEM tablespace for sorting operations?

  1. Create an undo tablespace

  2. Create a default temporary tablespace

  3. Create a tablespace with the UNDO keyword

  4. Create a tablespace with the TEMPORARY keyword
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Create a default temporary tablespace

Keep practicing — related questions