1Z0-063 Online Practice Questions and Answers

A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, parallelization for the backup set./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.

A. 3, 4

B. 2, 1, 4, 6

C. 3, 1, 4, 6

D. 1, 5, 2, 4, 6

E. 2, 6

You execute the command to recover your database:

Which statement is true?

A. It restores all data files from the specified time, and then applies the redo logs.

B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.

C. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.

D. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".

The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.

Which type of lock would this scenario lead to?

A. Exclusive table-level lock on the EMPLOYEES table

B. Row-exclusive lock on the row being updated

C. Null lock on the EMPLOYEES table

D. Null lock on the row being updated

Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

D. Only a common user can create additional services for a PDB.

E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

A. The script is executed and both DC1 and CH1 channels are used for script execution.

B. The execution of the script fails because multiple channels cannot exist simultaneously.

C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

D. The new channel, CH1, is ignored because a channel has been configured already.

Examine the RMAN command: Which statement is true about the command?

A. It creates compressed backup sets.

B. It uses asynchronous I/O for the backup.

C. It uses parallelization for the backup set.

D. It uses multisection backup.

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.

Which step should you perform next to start the upgrade of the database?

A. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

B. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.

C. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.

D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset

E. The DMU can report columns that are not represented in the converted characterset

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

Examine the steps required to recover the database:

1.

Restore an autobackup of the server parameter file.

2.

Restore the control file.

3.

Start up the database instance in nomount state.

4.

Mount the database.

5.

Restore the data files.

6.

Open the database with the resetlogs option.

7.

Recover the data files.

8.

Set D3ID for the database.

Identify the required steps in the correct order.

A. 1, 8, 3, 2, 4, 5, 7, 6

B. 8, 1, 3, 2, 4, 5, 7, 6

C. 1, 3, 2, 4, 8, 5, 6, 7

D. 8, 3, 2, 4, 5, 7, 6

E. 8, 1, 3, 2, 4, 5, 6

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A. The minimum size for the standard buffer cache is 100 MB.

B. The maximum size for the standard buffer cache is 100 MB.

C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.

D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

E. The minimum size for all buffer caches is 100 MB.