You want to create a tablespace,SALES, with these requirements:1.

Oracle 1z0-078 Question Answer

You want to create a tablespace,SALES, with these requirements:

1. Its data file has an alias namesales.dbf.

2. Its data file is stored in the directoryCURRENT_YRin the disk groupDATA.

Examine this command:

SQL> CREATE TABLESPACE sales;

Which two tasks must you perform to meet these requirements? (Choose two.)

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

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

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

Add the autoextend on clause to the command.

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

Oracle 1z0-078 Summary

Price: $52.5 ~~$149.99~~