Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 71:

  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?

  

  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.
  C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
  E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

• Question 72:

  For which two requirements would you use the Database Resource Manager?

  A. limiting the CPU used per database call
  B. specifying the maximum number of concurrent sessions allowed for a user
  C. specifying the amount of private space a session can allocate in the shared pool of the SGA
  D. limiting the degree of parallelism of operations performed by a user or group of users
  E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
  D. limiting the degree of parallelism of operations performed by a user or group of users
  E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

  ---

  Limit the degree of parallelism of any operation performed by members of a group of users. Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.

• Question 73:

  You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.

  Which method or feature should you use?

  A. Database Replay
  B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
  C. Active Session History (ASH) report
  D. SQL Performance Analyzer
  B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

  ---

  References: http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm

• Question 74:

  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.
  A. All the read-only tablespaces should be taken offline.

  ---

  Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery.

  References:

  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV227

• Question 75:

  You created a database with DBCA by using one of the Oracle supplied templates.

  Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

  A. USERS
  B. SYSTEM
  C. SYSAUX
  D. EXAMPLE
  A. USERS

  ---

  This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

• Question 76:

  You execute the commands to configure settings in RMAN:

  RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

  RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DRVICE TYPE DISK TO 2;

  Then you issue the following command to take a backup:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of these commands? (Choose the best answer.)

  A. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.
  B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
  C. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
  D. It backs up the data files and archived logs, making one copy of each data file and archived log on disk and media.
  B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

• Question 77:

  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.
  D. The statistics_level parameter is set to basic.

  ---

  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 78:

  Examine the commands executed to monitor database operations:

  $> conn sys/oracle@prod as sysdba

  SQL> VAR eid NUMBER

  SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');

  Which two statements are true?

  A. Database operations will be monitored only when they consume a significant amount of resource.
  B. Database operations for all sessions will be monitored.
  C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  D. Only DML and DDL statements will be monitored for the session.
  E. All subsequent statements in the session will be treated as one database operation and will be monitored.
  C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
  E. All subsequent statements in the session will be treated as one database operation and will be monitored.

  ---

  C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. Note:

  * The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring. *(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.

  / (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.

  / (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.

• Question 79:

  You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

  A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
  B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
  C. by using Active Session History (ASH) data and performing hang analysis
  D. by running ADDM in diagnostic mode
  B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

• Question 80:

  In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.

  Reports are also generated by joining multiple tables.

  Which table organization or type would provide the best performance for this hybrid workload?

  A. heap table with a primary key index
  B. external table
  C. hash clustered table
  D. global temporary table
  E. index clustered table
  E. index clustered table

  ---

  Do not cluster tables if the application joins them only occasionally or modifies their common column values frequently. Modifying a row's cluster key value takes longer than modifying the value in an unclustered table, because Oracle might

  need to migrate the modified row to another block to maintain the cluster.

  References:

  http://docs.oracle.com/cd/B28359_01/server.111/b28274/data_acc.htm#i7690