Multiple choice

How to create a table space?

  1. With alter database command

  2. With alter system command

  3. Using create command

  4. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Tablespaces are created using the CREATE TABLESPACE command in SQL. ALTER DATABASE and ALTER SYSTEM modify existing structures. The 'create' command is the standard DDL statement for creating new database objects like tablespaces.