Oracle Database Administration 2019 Certified Professional — Question 77

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.)

Answer options

• A. Create the CURRENT_YR directory in the root directory (+).
• B. Create the CURRENT_YR directory in the +DATA disk group.
• C. Add the DATAFILE ‘+DATA/CURRENT_YR/sales.dbf’ clause to the command.
• D. Add the AUTOEXTEND ON clause to the command.
• E. Add the DATAFILE ‘/CURRENT_YR/sales.dbf’ clause to the command.

Correct answer: B, C

Explanation

Option B is correct because the CURRENT_YR directory must be created in the +DATA disk group to meet the storage requirement. Option C is also correct as it specifies the correct path for the data file in the command. Options A and E are incorrect since they do not place the directory in the correct disk group, and option D is irrelevant to the specified requirements.