1Z0-063 Online Practice Questions and Answers

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.

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

What is the outcome?

A. RMAN uses the push method to transfer image copies.

B. RMAN uses the push method to transfer backup sets.

C. RMAN uses the pull method to restore files using backup sets.

D. RMAN uses the pull method to restore files using image copies.

Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

A. consistent whole database backup

B. backup of noncritical tablespaces without shutting down the instance

C. backup of the database without shutting down the instance

D. backup of only those blocks that have changed since the last backup while database is mounted

E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

One of your container databases (CDBs) has five pluggable databases (PDBs).

COMMON_USER_PREFIX is C##.

These commands executed successfully while connected as SYS to CDB$ROOT:

SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;

SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;

SQL> GRANT c##role1 to system CONTAINER=ALL;

Which three are true? (Choose three.)

A. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

B. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED.

C. The c##role1 role will always have the same privileges in all current and future PDBs.

D. The C##DBA_ADMIN user is a local user in CDB$ROOT.

E. SYSTEM is able to create views in any PDB as a result of being a DBA user.

F. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

You want to create a guaranteed restore point for your databases by executing the command:

SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

Identify two prerequisites for the successful execution of this command. (Choose two.)

A. A database backup must be taken.

B. Fast Recovery Area must be enabled.

C. Undo retention guarantee must be enabled

D. The recyclebin must be enabled for the database.

E. Flashback Database must be enabled.

F. The database must be running in ARCHIVELOG mode.

Examine the RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A. It fails because there is no connection to a recovery catalog.

B. It succeeds only if the target database is in MOUNT state.

C. It succeeds and creates multisection backup sets that are used for active database duplication.

D. It fails because no parallel channels are allocated for the auxiliary database.

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

Examine the command executed to back up pdb2_1:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

A. It fails because archive log files cannot be backed up using a connection to a PDB.

B. It succeeds but only the data files belonging to the pdb2_1 pluggable database are backed up.

C. It succeeds and all data files belonging to PD32_1 are backed up along with the archive log files.

D. It fails because the pluggable clause is missing.

View the Exhibit showing steps to create a database resource manager plan.

SQL>execute dbms_resource_manager.create_pendingarea();

PL/SQL procedure successfully completed.

SQL>exec dbms_resource_manager, create_consumergroup

(consumer_group=>'OLTP,,comment=>,onlineuser')

PL/SQL procedure successfully completed.

SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio');

SQL>exec

Dbms_resource_manager.create_plan_directive

(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60);

PL/3QLproceduresuccessfullycompleted.

After executing the steps in the exhibit you execute this procedure, which results in an error:

SQL> EXECUTE dbms_resource_manager. validate_pending_area ();

What is the reason for the error?

A. The pending area is automatically submitted when creating plan directives.

B. The procedure must be executed before creating any plan directive.

C. The sys_group group is not included in the resource plan.

D. The other_groups group is not included in the resource plan.

E. Pending areas can not be validated until submitted.

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.

What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

A. All the read-only tablespaces should be taken offline.

B. All the read-only tablespaces should be restored separately.

C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

D. All the read-only tablespaces should be made online with logging disabled.

Users report this error message when inserting rows into the orders table: ERROR at line1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES

You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

A. drop and re-create the index

B. coalesce the order.ind index

C. coalesce the indexes tablespace

D. perform an on line table rebuild using dbms_redefinition

E. rebuild the index online moving it to another tablespace that has enough free space for the index