Oracle Exam 1Z0-078 Topic 12 Question 20 Discussion

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

Question #: 20
Topic #: 12

[All 1Z0-078 Questions]

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

AThe DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

Bnewtemplate must be defined for the +DATA disk group.

CExisting data files in TBS1 must also use the same template.

DUser-defined subdirectories ORCL and USERS must already exist.

EThe +DATA disk group should not be part of Flex ASM.

Show Suggested Answer

Suggested Answer: B, C, F

by Laurel at Jun 29, 2024, 06:52 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-078 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tess

6 days ago

Flex ASM, huh? Better make sure the +DATA disk group isn't part of that, or this whole thing might fall apart. Gotta love these tricky database questions!

upvoted 0 times

...

Elmer

16 days ago

Wait, aren't we supposed to create the user-defined subdirectories ORCL and USERS beforehand? That's odd, I thought the command would handle that for us.

upvoted 0 times

...

Lizbeth

17 days ago

I think option A and C are needed, as the existing data files in TBS1 must use the same template.

upvoted 0 times

...

Hmm, looks like we need to set the DB_CREATE_FILE_DEST parameter and define the newtemplate for the +DATA disk group. Existing data files in TBS1 should also use the same template. Simple enough, right?

upvoted 0 times

...

Leonie

20 days ago

I disagree, I believe option B and D are the correct choices.

upvoted 0 times

...

Gail

25 days ago

I think option A and B are required for the command to succeed.

upvoted 0 times

...

Oracle Exam 1Z0-078 Topic 12 Question 20 Discussion

Contribute your Thoughts:

Tess

Elmer

Lizbeth

King

Leonie

Gail