1Z0-063 Online Practice Questions and Answers

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

Examine the command:

RMAN> LIST FAILURE;

Which statement is true about this command?

A. It lists failures only for the CDB root database.

B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.

C. It lists failures for the CDB and all the PDBs in this CDB.

D. It lists failures only if RMAN is connected to a PDB.

You issue the RMAN command:

RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

Which statement is true about the execution of the command?

A. The resulting backupset has backup pieces that cannot exceed 300 MB.

B. RMAN uses multiplexing to perform the backup.

C. RMAN always performs this type of backup in parallel.

D. The backup succeeds only if the USERS tablespace is locally managed.

E. The backup set size is limited to 300 MB.

You use RMAN to take regular backups for your database.

Examine the RMAN commands:

RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPITED BACKUP;

Which statement is true?

A. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.

B. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.

C. All backups that have exceeded the age set by the RMAN retention policy are deleted.

D. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

A. It generates a log file containing the fixes that can be made to the source database.

B. It recompiles all invalid PLSQL and Java code.

C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

D. It provides a summary of the upgrade results.

E. It generates fixup scripts to be run on the source database before upgrade.

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.

Which two are benefits of unified auditing in full mode? (Choose two.)

A. The audit trail is in a single format.

B. All audit data is written to both the traditional locations and to the unified location.

C. The audit trail is read-only.

D. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

E. The audit trail uses less space.

Examine this parameter in a database's PFILE:

DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/'

You execute this command: Which three are true after successful database creation? (Choose three.)

A. Local Undo is enabled.

B. The files created for both the root and seed databases use Oracle Managed Files (OMF).

C. PDB$SEED is open read-only.

D. PDB$SEED is mounted.

E. USERS will be the default tablespace for PDB$SEED.

F. CDB$ROOT is open read/write.

One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You

connect to CDB$ROOT as SYS and execute these commands successfully:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;

SQL> CREATE ROLE C##CONNECT;

SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which three are true? (Choose three.)

A. The C##CONNECT role can be granted different roles and privileges in each PDB.

B. C##ADMIN has the orcl123 password in all PDBs.

C. The C##CONNECT role is granted to the C##ADMIN user in all PDBs.

D. CREATE SESSION is granted to the C##ADMIN user in all PDBs.

E. The C##CONNECT role is a local role defined only in CDB$ROOT.

Which two statements are true about a common user? (Choose two.)

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

B. A common user with the create user privilege can create other common users, as well as local users.

C. A common user can be granted only a common role.

D. A common user can have a local schema in a PDB.

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Which two statements are true about unified auditing? (Choose two.)

A. A unified audit trail captures audit information from unified audit policies and audit settings.

B. Unified auditing is enabled by executing make 璮 ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME.

C. Audit records are created for all users except sys.

D. Audit records are created only for the DML and DDL operations performed on database objects.

E.

Unified auditing is enabled by setting the audit_trail parameter to db, extended.

F.

A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Examine these Data Pump commands to export and import objects from and to the same database.

The dba has not yet created users hr1 and oe1.

$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table $ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1

What will happen when running these commands?

A. expdp will fail because no path has been defined for the dumpfile.

B. expdp will succeed but impdp will fail because the users do not exist.

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):

1.

Start the RMAN client by using the RMAN target / command.

2.

Start the RMAN client by using the OSB user.

3.

RMAN creates the backup pieces.

4.

Run the RMAN backup command with the sbt channels.

5.

OSB creates a backup job and assigns a unique identifier.

6.

OSB creates a backup job request through the OSB sbt library.

7.

OSB stores metadata about RMAN backup pieces in the OSB catalog.

8.

OSB starts the backup operation.

9.

OSB updates the RMAN catalog.

Identify the required steps/operations performed in correct order.

A. 1, 4, 6, 5, 8, 3, 9

B. 1, 6, 4, 5, 8, 3, 9

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

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

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user

executes the following commands to create and grant privileges on a procedure:

CREATE OR REPLACE PROCEDURE create_test_v(v_emp_idNUMBER,v_enameVARCHAR2,

v_SALARYNUMBER,v_dept_idNUMBER)

BEGIN

INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);

END;

/

GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;

How can you prevent users having the execute privilege on the create_test_v procedure from inserting

values into tables on which they do not have any privileges?

A. Create the create_test procedure with definer's rights.

B. Grant the execute privilege to users with grant option on the create_test procedure.

C. Create the create_test procedure with invoker's rights.

D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Examine the resources consumed by a database instance whose current Resource Manager plan is

displayed.

SQL> SELECT name, active_sessions, queue_length,

consumed_cpu_time, cpu_waits, cpu_wait_time

FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

A. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.