Exam 1z0-078 topic 1 question 32 discussion

Actual exam question from Oracle's 1z0-078

Question #: 32
Topic #: 1

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

Show Suggested Answer

Suggested Answer: BC 🗳️

by [deleted] at April 4, 2025, 10:23 a.m.

Comments

Submit Cancel

shaw2000

5 days, 20 hours ago

Selected Answer: BC

You must create the directory inside the ASM disk group: ALTER DISKGROUP DATA ADD DIRECTORY '+DATA/CURRENT_YR'; ASM directories do not exist unless created explicitly. The tablespace creation must specify both the disk group and the alias name: CREATE TABLESPACE sales DATAFILE '+DATA/CURRENT_YR/sales.dbf' SIZE 100M; Without a DATAFILE clause, Oracle stores the file in the default location with a system-generated name.

upvoted 1 times

...