Oracle Exam 1Z0-078 Topic 12 Question 43 Discussion

Actual exam question for Oracle's 1Z0-078 exam

Question #: 43
Topic #: 12

[All 1Z0-078 Questions]

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

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

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

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

DAdd the autoextend on clause to the command.

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

Show Suggested Answer

Suggested Answer: B, C

by Lajuana at Jul 14, 2025, 07:19 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

Should we also add the autoextend on clause to the command for flexibility?

upvoted 0 times

...

3 days ago

Wait, we need to create the directory in the disk group, not the root directory. Option B is the way to go.

upvoted 0 times

...

6 days ago

I agree with that. We also need to add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

upvoted 0 times

...

7 days ago

I think we need to create the current yr directory in the +data disk group.

upvoted 0 times

...