Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 3 of 4)

The video tutorial covers managing database free space by creating or modifying tablespaces and data files. It explains how to drop tablespaces, manage user privileges, and address table fragmentation. The tutorial introduces big file tablespaces, highlighting their advantages and considerations. It also details the process of creating both big and small file tablespaces using SQL statements and the DBCA tool.

What is the first option to enlarge free space in a database?

• Add a data file to an existing tablespace

• Create a new tablespace

• Resize an existing data file

• Make a data file auto-extensible

Which SQL statement is used to add a data file to an existing tablespace?

• ALTER TABLESPACE ADD DATA FILE

• ALTER SYSTEM ADD DATA FILE

• CREATE TABLESPACE ADD DATA FILE

• ALTER DATABASE ADD DATA FILE

What must a user have to drop a tablespace?

• CREATE TABLESPACE privilege

• SELECT privilege

• ALTER SYSTEM privilege

• DROP TABLESPACE privilege

What happens if you try to drop a non-empty tablespace without additional options?

• It drops the tablespace and its contents

• It fails to drop the tablespace

• It prompts for confirmation

• It deletes only the data files

Why might you move a table to a different tablespace?

• To increase the table's size

• To defragment the table

• To change the table's name

• To delete the table

What is a key advantage of big file tablespaces?

• They require less storage space

• They are faster to create

• They support larger data file sizes

• They allow multiple data files per tablespace

What is the relationship between tablespaces and data files in big file tablespaces?

• One-to-one

• Many-to-one

• One-to-many

• Many-to-many

What keyword is used to create a big file tablespace?

• EXTENDED FILE

• LARGE FILE

• BIG FILE

• SINGLE FILE

How can you change the default tablespace type after database creation?

• Using ALTER SYSTEM SET DEFAULT TABLESPACE

• Using ALTER DATABASE SET DEFAULT TABLESPACE

• Using CREATE DATABASE SET DEFAULT TABLESPACE

• Using MODIFY DATABASE SET DEFAULT TABLESPACE

What is the default tablespace type set during database creation?

• It is set to auto-extensible

• It depends on the database creation settings

• It is always small file

• It is always big file