which four options would you select for creating this tablespace?

A new tablespace, EMP_NEW, has to be created. The tablespace must conform to the following specifications:
1. It should store the details of the employees in the company.
2. It should grow when full.
3. The extents should be managed within the tablespace by the Oracle server./li> Using Enterprise Manager, which four options would you select for creating this tablespace? (Choose four.)

A new tablespace, EMP_NEW, has to be created. The tablespace must conform to the following specifications:
1. It should store the details of the employees in the company.
2. It should grow when full.
3. The extents should be managed within the tablespace by the Oracle server.

Using Enterprise Manager, which four options would you select for creating this tablespace? (Choose four.)

A.
The tablespace should be temporary.

B.
The tablespace should be permanent.

C.
The tablespace status should be read-only.

D.
The tablespace status should be read/write.

E.
The extent management should be locally managed.

F.
The extent management should be dictionary managed.

G.
The datafile associated with the tablespace should have the “Automatically extend datafile when full” option enabled.



Leave a Reply 0

Your email address will not be published. Required fields are marked *