1z0-063 Oracle Database 12c: Advanced Administration

Loading demo links...

Showing 7–9 of 15 questions

Question 7

Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

Select all that apply, then click Submit answer.

  • Use PDB$SEED for creating a PDB.

  • Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

  • Clone an existing PDB.

  • Use Enterprise Manager Database Express to create a PDB in an existing CDB.

  • Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Question 8

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Select an option, then click Submit answer.

  • By default, EM express is available for a database after database creation.

  • You can use EM express to manage multiple databases running on the same server.

  • You can perform basic administrative tasks for pluggable databases by using the EM express interface.

  • You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

  • You can create and configure pluggable databases by using EM express.

Question 9

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.

Select an option, then click Submit answer.

  • 3, 4

  • 2, 1, 4, 6

  • 3, 1, 4, 6

  • 1, 5, 2, 4, 6

  • 2, 6