Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 181:

  Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

  You execute this command:

  SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

  Which statement is true?

  A. The minimum size for the standard buffer cache is 100 MB.

  B. The maximum size for the standard buffer cache is 100 MB.

  C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.

  D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

  E. The minimum size for all buffer caches is 100 MB.

  Correct Answer: A

  If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

• Question 182:

  You created a tablespace with this statement:

  CREATE BIGFILE TABLESPACE adtbs DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

  The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

  Which two alter statements will achieve this?

  A. ALTER TA3LESPACE adtbs RESI2E 20G;

  B. ALTER TA3LESPACE adtbs ADD DATAFILE;

  C. ALTER TABLESPACE adtbs AUTOEXTEND ON;

  D. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

  E. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

  Correct Answer: AC

  References: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

• Question 183:

  Which two statements are true regarding the Oracle Data Pump export and import operations?

  A. You cannot export data from a remote database.

  B. You can rename tables during import.

  C. You can overwrite existing dump files during export.

  D. You can compress data but not metadata during export.

  Correct Answer: BC

  However, in Oracle 11g there is a new parameter, reuse_dumpfiles, which overwrites any created dump file in a specified folder. This parameter accepts two values: Y and N. Default is N. If the parameter was set to Y, then Data Pump overwrites the files that already exist. Reference: http://www.dba-oracle.com/T_rman_167_expdp_reuse_dumpfiles_parameter.htm

• Question 184:

  Examine the command:

  $expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp,

  dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull

  Which statement is true about the execution of the command?

  A. It fails because the log file parameter is not specified.

  B. It fails because no absolute path is specified for the log file and dump file.

  C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

  D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

  Correct Answer: D

  It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.

• Question 185:

  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

  Correct Answer: B

• Question 186:

  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.

  Correct Answer: CE

• Question 187:

  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.

  Correct Answer: CE

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

  Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:

  SQL>STARTUP

  Which two statements are true about the successful execution of the command?

  A. All redo log files are opened.

  B. The root, the seed, and all the PDBs are opened in read-write mode.

  C. All the PDBs are opened in read-write mode.

  D. All the PDBs are in closed state.

  E. Only the root database is opened in read-write mode.

  Correct Answer: AE

  The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

• Question 189:

  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

  Correct Answer: B

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

  3. Start analyzing the data captured by the policy.

  6. Stop analyzing the data.

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

  5. Compare the used and unused privileges' lists.

  4. Revoke the unused privileges.

• Question 190:

  Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which statement is true about the execution of this command to back up the database?

  A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

  B. All data files belonging to pdb2_1 are backed up along with the archive log files.

  C. Only the data files belonging to pdb2_ are backed up.

  D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

  Correct Answer: C

  Reference: http://docs.oracle.com/database/121/BRADV/rcmcnctg.htm#BRADV005