Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 71:

  Which two are true about data dictionary views and contents and output in a CDB? (Choose two.)

  A. DBA_views are a superset of CDB_views.
  B. CDB_views can be queried only from CDB$ROOT.
  C. Data dictionary metadata for user-created objects is contained in PDB system tablespaces.
  D. The data dictionary in CDB$ROOT stores only metadata for objects common to all its PDBs.
  E. Oracle-supplied data dictionary tables metadata is stored only in CDB$ROOT.
  B. CDB_views can be queried only from CDB$ROOT.
  E. Oracle-supplied data dictionary tables metadata is stored only in CDB$ROOT.

• Question 72:

  Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

  A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
  B. The PDB is closed and requires media recovery at the PDB level.
  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
  D. The PDB does not close and starts by using the default temporary tablespace defined for the CD.
  C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

• Question 73:

  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.
  A. The audit trail is in a single format.
  C. The audit trail is read-only.

• Question 74:

  Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).

  In PDB HR_PDB, common user C##ADMIN and local user B_ADMIN have only the CONNECT privilege.

  You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.

  You then execute the commands:

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

  SQL> CONN sys/oracle@HR_PDB as sysdba

  SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;

  Which three statements are true? (Choose three.)

  A. C##ADMIN can create and select any table in HR_PDB.
  B. B_ADMIN can create and select any table only in HR_PDB.
  C. A local role can be granted to c##role1 in a PDB
  D. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
  E. Role c##role1 will always have the same privileges in each PDB.
  F. B_ADMIN can create and select any table in both the root container and HR_PDB.
  A. C##ADMIN can create and select any table in HR_PDB.
  C. A local role can be granted to c##role1 in a PDB
  E. Role c##role1 will always have the same privileges in each PDB.

• Question 75:

  Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

  1.

  Create a policy to capture the privileges used by a user for privilege analysis.

  2.

  Generate a report with the data captured for a specified privilege capture.

  3.

  Start analyzing the data captured by the policy.

  4.

  Revoke the unused privileges.

  5.

  Compare the used and unused privileges' lists.

  6.

  Stop analyzing the data.

  Identify the correct sequence of steps.

  A. 1, 3, 5, 6, 2, 4
  B. 1, 3, 6, 2, 5, 4
  C. 1, 3, 2, 5, 6, 4
  D. 1, 3, 5, 2, 6, 4
  B. 1, 3, 6, 2, 5, 4

• Question 76:

  Consider the following scenario for your database:

  Backup optimization is enabled in RMAN.

  The recovery window is set to seven days in RMAN.

  The most recent backup to disk for the tools tablespace was taken on March 1, 2013.

  The tools tablespace is read-only since March 2, 2013.

  On March 15, 2013, you issue the RMAN command to back up the database to disk.

  Which statement is true about the backup of the tools tablespace?

  A. The RMAN backup fails because the tools tablespace is read-only.
  B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
  C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
  D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
  D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

• Question 77:

  Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

  You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

  How would you achieve this?

  A. by using the RMAN SWITCH command to set the new location for the data files
  B. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host
  C. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host
  D. by creating a new database in the new host, and then using the RMAN RECOVER command
  B. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

• Question 78:

  Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

  A. A PDB must be in MOUNT state or it must be unplugged.
  B. The data files associated with a PDB are automatically removed from disk.
  C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
  D. A PDB must be in closed state.
  E. The backups associated with a PDB are removed.
  F. A PDB must have been opened at least once after creation.
  A. A PDB must be in MOUNT state or it must be unplugged.
  C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

• Question 79:

  Identify three scenarios in which RMAN will use backup sets to perform active database duplication. (Choose three.)

  A. when the duplicate ... from active database command contains the section size clause
  B. when you perform active database duplication on a database with flashback disabled
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
  E. when you perform active database duplication on a database that has read-only tablespaces
  A. when the duplicate ... from active database command contains the section size clause
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

• Question 80:

  Which two are true about Oracle Secure Backup (OSB)? (Choose two.)

  A. It can be used to take proxy copies to tape.
  B. It can be used to take image copy backups to tape.
  C. It can be used to manage tape backup and restore operations for files.
  D. RMAN can backup up databases to OSB without requiring media manager channel parameters.
  E. It can be used to manage tape backup and restore operations for files systems.
  C. It can be used to manage tape backup and restore operations for files.
  E. It can be used to manage tape backup and restore operations for files systems.