Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 191:

  You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.

  How can you detect the cause of the degraded performance?

  A. Enable Memory Access Mode, which reads performance data from SGA.

  B. Use emergency monitoring to fetch data directly from SGA for analysis.

  C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

  D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

  E. Run ADDM in diagnostic mode.

  Correct Answer: B

  Reference: https://oracle-base.com/articles/12c/emergency-monitoring-em12c

• Question 192:

  You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

  CONNECT/AS SYSDBA ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE; SHUTDOWNIMMEDIATE

  You then restart the instance and get an error: STARTUP ORA-01031:insufficientprivileges

  Why does the startup command return the error shown?

  A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command

  B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command

  C. because the threaded architecture requires authentication using a password file before issuing a startup command

  D. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

  E. because the threaded architecture requires restarting the listener before issuing a startup command

  Correct Answer: C

  The first pitfall is, when you try to configure your database for such use. You need a connection which is

  authenticated trough the password file. Otherwise you will get are error similar to this.

  Reference:

  https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threaded-oracle/

• Question 193:

  You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

  Examine the steps required to recover the database:

  1.Restore an autobackup of the server parameter file. 2.Restore the control file.

  3. Start up the database instance in nomount state.

  4.Mount the database.

  5.Restore the data files.

  6.Open the database with the resetlogs option.

  7.Recover the data files.

  8.Set DBID for the database.

  Identify the required steps in the correct order.

  A. 1, 8, 3, 2, 4, 5, 7, 6

  B. 8, 1, 3, 2, 4, 5, 7, 6

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

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

  E. 8, 1, 3, 2, 4, 5, 6

  Correct Answer: D

• Question 194:

  Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

  A. A PDB opened in restricted mode allows only local users to connect.

  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

  C. When a CDB is in mount state, PDBs are automatically placed in mount state.

  D. All PDBs must be shut down before shutting down a CDB instance.

  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

  Correct Answer: BCE

  Reference: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb-12cr1

• Question 195:

  A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

  Which table organization allows for generating the bills with minimum degree of row sorting?

  A. a hash cluster

  B. an index cluster

  C. a partitioned table

  D. a sorted hash cluster

  E. a heap table with a rowid column

  Correct Answer: D

  The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.

• Question 196:

  You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

  From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

  What could be the reason for this?

  A. The event parameter was not set.

  B. The sql_trace parameter is set to false.

  C. Enterprise Manager was not used.

  D. The statistics_level parameter is set to basic.

  E. The t:kid_statistics parameter is set to false.

  Correct Answer: D

  To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to

  TYPICAL or ALL.

  Reference:

  http://www.dba-oracle.com/t_dbms_server_alert.htm

• Question 197:

  You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_1 and pdb_2.

  While opening pdb_1, you get an error:

  SQL> alter pluggable database pdb_1 open;

  ORA-01157: cannot identify/lock data file 11-see DBWR trace file ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf'

  To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:

  RMAN>REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failure.

  B. The command produces an error because RMAN is not connected to the target database pdb_1.

  C. The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.

  D. The command executes successfully, performs recovery, and opens PDB_1.

  Correct Answer: C

  Usage Notes Repairs are consolidated whenever possible so that a single repair can fix multiple failures.

  Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session

  to successfully repair each of the identified failures. You typically iterate through a REPAIR session with

  the following commands: -REPAIR FAILURE; -LIST FAILURE; -ADVISE FAILURE; -REPAIR FAILURE;

  Reference:

  http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199

• Question 198:

  What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  A. statistics recommendations

  B. SQL profile recommendations

  C. SQL statement restructure recommendations

  D. creation of materialized views to improve query performance

  Correct Answer: B

  Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: ... During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically. References: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

• Question 199:

  Examine the command used to perform an incremental level-0 backup:

  RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;

  To enable block change tracking, after the incremental level 0 backup, you issue the command:

  SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE'/mydir/rman_change_track.f';

  To perform an incremental level-1 cumulative backup, you issue the command:

  RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

  Which two statements are true in the preceding situation?

  A. The block change tracking data is used only from the next incremental backup.

  B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

  C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

  D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

  E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

  Correct Answer: CE

• Question 200:

  Which four actions are possible during an Online Datafile Move operation?

  A. Creating and dropping tables in the datafile being moved

  B. Performing file shrink of the data file being moved

  C. Querying tables in the datafile being moved

  D. Performing Block Media Recovery for a data block in the datafile being moved

  E. Flashing back the database

  F. Executing DML statements on objects stored in the datafile being moved

  Correct Answer: ACEF

  "The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile's underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature." Reference: http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-move-datafile.html