QUESTION $1$

Automatic segment space management on th tablespace causes which of the following table attribtes in that tablespace to be ignored?

A$.$

The whole storage clause

B$.$

NEXT and PCTINCREASE

C$.$

BUFFERPOOL and FREEPOOL

D$.$

PCTFREE and PCTUSED

$10$ points

QUESTION $2$

Choose the statement that is not resumable.

A$.$

ALTER TABLE $...$ SPLIT PARTITION

B$.$

SELECT

C$.$

INSERT INTO $...$ SELECT

D$.$

CREATE TABLESPACE

$10$ points

QUESTION $3$

How would you drop a tablespace if the tablespace were not empty?

A$.$

Rename all the objects in the tablespace, and then drop the tablespace.

B$.$

Remove the data files belonging to the tablespace from the disk.

C$.$

Use ALTER DATABASE DROP CASCADE;

D$.$

Use DROP TABLESPACE INCLUDING CONTENTS;