PrepAway - Latest Free Exam Questions & Answers

Category: 1Z0-063 (v.1)

Exam 1Z0-063: Oracle Database 12c Advanced Administration (update August 9th, 2017)

Identify the required steps in the correct order to ac…

A database instance uses an SPFILE, Examine the parameter:
NAME TYPE VALUE
control_files string /u01/app/oracle/oradata
/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata
/cdb1/disk2/control02.ctl

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.ctl,
/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.

PrepAway - Latest Free Exam Questions & Answers

Which statement is true about the command?

Examine the RMAN command:
RMAN> RUN (
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
)

Which statement is true about the command?

Identify the required steps in the correct order.

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.


Page 1 of 2212345...1020...Last »