Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 211:

  You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

  For which database users is the audit policy now active?

  A. all users except sys

  B. all users except scott

  C. all users except sys and scott

  D. all users except sys, system, and scott

  Correct Answer: B

• Question 212:

  Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:

  SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH; Which two statements are true about the statistics level parameter?

  A. It is immediately set to all in the SPFILE and the CDB instance.

  B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.

  C. It is immediately set to all only for cd3Sroot.

  D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.

  E. It is set to all for all PDBs only in the SPFILE.

  Correct Answer: AD

  When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only. Their system-wide state is not changed.

• Question 213:

  Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

  A. Reduced logical I/O

  B. Reduced virtual memory utilization

  C. Improved Serial Execution performance

  D. Reduced physical I/O

  E. Reduced CPU utilization

  Correct Answer: BE

• Question 214:

  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

  Correct Answer: C

  The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery

  catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.

  Reference:

  https://docs.oracle.com/cd/E26569_01/doc.104/e21476/osb_rman_backup.htm#OBADM190

• Question 215:

  You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

  A. The backup must be performed in mount state.

  B. The tablespace must be taken offline.

  C. All files must be backed up as backup sets.

  D. The database must be backed up as an image copy.

  Correct Answer: A

  If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement Reference: https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459

• Question 216:

  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.

  Correct Answer: B

  ORA-39165: Schema not found error will be resulted

• Question 217:

  Which two statements are true about a multitenant architecture?

  A. Each pluggable database (PDB) has its own initialization parameter file.

  B. A PDB can have a private undo tablespace.

  C. Log switches occur only at the container database level.

  D. A PDB can have a private temporary tablespace.

  E. Each PDB has a private control file.

  Correct Answer: CD

  You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.

• Question 218:

  Examine the command to create a pluggable database (PDB):

  SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1

  FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX = '/disk2/oracle/

  pdb2';

  Which two statements are true?

  A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

  B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

  C. The tablespace specifications of pdb2 are the same as pdb1.

  D. All database objects belonging to common users in PD3I are cloned in PD32.

  E. pdb2 is created with its own private undo and temp tablespaces.

  Correct Answer: AC

  References: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586

• Question 219:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

  A. tracking the most recent read time for a table segment in a user tablespace

  B. tracking the most recent write time for a table segment in a user tablespace

  C. tracking insert time by row for table rows

  D. tracking the most recent write time for each block in a table segment

  E. tracking the most recent read time for a table segment in the sysauxtablespace

  F. tracking the most recent write time for a table segment in the sysauxtablespace

  Correct Answer: ABD

  Tracking of segment-level reads and writes At the block level, Heat Map tracks only the most recent modification time stamp.

• Question 220:

  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 no filename check to recover the database to the new host

  C. by using the RMAN duplicate command with dbid and set nekname 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

  Correct Answer: B

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#CHDGFABD