Exit demo 1Z0-063 Oracle Database 12c: Advanced Administration PDF format · free preview

Oracle 1Z0-063 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-063.html

Question 1
Multiple choice

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

A.

to store backup information of multiple databases in one place

B.

to restrict the amount of space that is used by backups

C.

to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

D.

to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog

E.

to automatically delete obsolete backups after a specified period of time

Question 2
Multiple choice

Which two statements are true regarding Oracle Data Pump? (Choose two.)

A.

EXPDP and IMPDP are the client components of Oracle Data Pump.

B.

DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

C.

Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D.

Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

E.

EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Question 3
Multiple choice

Which two statements are true about making RMAN image copies of a database? (Choose two.)

A.

They can only be written to disk.

B.

They can be made only when the database is running in NOARCHIVELOG mode.

C.

They can be made only when the database is in MOUNT state.

D.

They consist of all used and unused blocks in the data files.

E.

They can be made only when the database is running in ARCHIVELOG mode.

Question 4
Single choice

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.

The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.

A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.

In the CATDB12c database, you execute the commands:

What is the outcome of the import?

A.

It fails because the target database and recovery catalog database are of different versions.

B.

It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

C.

It succeeds but the database is not automatically registered in the RC12c catalog.

D.

It fails because RMAN is not connected to the target database with DBID=1423241.

Question 5
Single choice

You issue the command:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which statement is true about the command?

A.

It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

B.

It creates a file that contains the SQL statement, which is required to re-create the control file.

C.

It updates the alert log file with the location and contents of the control file.

D.

It creates a binary backup of the control file.

Question 6
Single choice

You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

A.

It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

B.

It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

C.

It executes successfully and continues to store metadata related to the EMPLOYEES table.

D.

It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Question 7
Single choice

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has
multiple pluggable databases (PDB):

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

A.

The command fails and gives an error because object privileges cannot be granted to a common user.

B.

The command fails because container is not set to current.

C.

The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.

D.

The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.

E.

The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.

Question 8
Multiple choice

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)

A.

The root and seed databases are included in the duplication.

B.

Only the SALES PDB is duplicated as the non-CDB CDBDUP.

C.

A backup of the SALES PDB must exist before the execution of the command.

D.

An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

E.

RMAN must be connected to a recovery catalog for the execution of the command.

Question 9
Single choice

You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

Which statement is true about the database that is created?

A.

It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

B.

It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

C.

It is created as a PDB that must be plugged into an existing CDB.

D.

It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

Question 10
Single choice

Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.

What must you do to make the database operational in OUSERVER1?

A.

Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.

B.

Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.

C.

Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.

D.

Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

Showing 10 of 276 questions · Unlock the full set