A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl/. Examine the possible steps…

Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #193. The question stem and answer options stay visible for context.

Using DDL Statements to Create and Manage Tables

Question

A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/ control03.ctl/. Examine the possible steps that are in random order: 1. Shut down the database instance. 2. Issue ALTER SYSTEM SET CONTROL_FILES= /u01/app/oracle/oradata/cdb1/disk1/ control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02, /u01/app/oracle/ oradata/cdb1/disk3/control03.ctl' SCOPE=SPFILE;. 3. Issue ALTER SYSTEM SET CONTROL_FILES= /u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/ cdb1/disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl';. 4. Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/ control03.ctl'. 5. Mount the database. 6. Open the database. Identify the required steps in the correct order to accomplish the task.

Exhibit

Options

A3, 4
B2, 1, 4, 6
C3, 1, 4, 6
D1, 5, 2, 4, 6
E2, 6

Unlock 1Z0-063 to see the answer

You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock 1Z0-063 - $49.99 / 30 days Sign in

Topics

#control file multiplexing#SPFILE#ALTER SYSTEM CONTROL_FILES#database shutdown steps

Full 1Z0-063 Practice