1z0-078 Exam Dumps | You want to create a tablespace, SALES, with these requirements: 1. Its data file has an alias name sales.dbf.

<< Prev Question Next Question >>

Question 8/32

You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

A. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

B. Create the current yr directory in the root directory (+).

C. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.

D. Create the current yr directory in the +data disk group.

E. Add the autoextend on clause to the command.

Question 8/32

LEAVE A REPLY

Download PDF File