Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 131:

  You restore and recover your database to a new host by using an existing RMAN open database backup.

  Which step must you perform next?

  A. Execute catproc.sqi to recompile invalid PL/SQL modules.

  B. Open the database with the resetlogs option.

  C. Set a new database identifier (DBID) for the newly restored database.

  D. Use the RMAN set newname and switch commands to switch to new files.

  Correct Answer: B

  Reference: https://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007514

• Question 132:

  Which two statements are true about unified auditing?

  A. A unified audit trail captures audit information from unified audit policies and audit settings.

  B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

  C. Audit records are created for all users except sys.

  D. Audit records are created only for the DML and DDL operations performed on database objects.

  E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.

  F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

  Correct Answer: AB

  In unified auditing, the unified audit trail captures audit information from a variety of sources. Audit records (including SYS audit records) from unified audit policies and AUDIT settings Fine-grained audit records from the DBMS_FGA PL/SQL package Oracle Database Real Application Security audit records Oracle Recovery Manager audit records Oracle Database Vault audit records Oracle Label Security audit records Oracle Data Mining records Oracle Data Pump Oracle SQL*Loader Direct Load Enable theunified auditing executable. UNIX: Run the following command: make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace References: https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG343 https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-848908988E1181F6.htm#TDPSG55281 https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024

• Question 133:

  Which three statements are true about persistent lightweight jobs?

  A. A user cannot set privileges on them.

  B. They generate large amounts of metadata.

  C. They may be created as fully self-contained jobs.

  D. They must reference an existing Scheduler Program.

  E. The are useful when users need to create a large number of jobs quickly.

  Correct Answer: ADE

  Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either `PLSQL_BLOCK' or `STORED_PROCEDURE'. References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668

• Question 134:

  You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

  Which two statements are true?

  A. The memory_max_target parameter is automatically set to 500 MB.

  B. The pga_aggregate_target and sga_target parameters are automatically set to zero.

  C. The value of the memory_max_target parameter remains zero for the database instance.

  D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

  E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

  Correct Answer: AD

  Reference:

  http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11200 (See the second

  note on the page)

• Question 135:

  Your database supports an OLTP workload. Examine the output of the query:

  SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttr estimated_mttr

  0 76

  To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.

  What is the effect of this setting on the database?

  A. Automatic checkpoint tuning is disabled.

  B. The frequency of log switches is increased.

  C. The overhead on database performance is increased because of frequent writes to disk.

  D. The MTTR advisor is disabled.

  Correct Answer: C

  Reference: http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

• Question 136:

  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, 2015.

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

  On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager

  Interface.

  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.

  Correct Answer: D

• Question 137:

  Your database is running in archive log mode and Automatic Undo Management is enabled.

  Which two tasks should you perform before enabling Flashback Database?

  A. Enable minimal supplemental logging.

  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

  C. Enable the recyclebin.

  D. Enable undo retention guarantee.

  E. Enable Fast Recovery Area.

  Correct Answer: BE

  Section: About Flashback Database Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. To take advantage of this feature, you must set up your database in advance to create flashback logs. References:https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582

• Question 138:

  You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.

  You set the value of the initialization parameter resumable_timeout to 3600.

  Which two statements are true?

  A. A resumable statement can be suspended and resumed only once during execution.

  B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

  C. A suspended statement will report an error if no corrective action has taken place during a timeout period.

  D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

  E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

  Correct Answer: CD

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm

• Question 139:

  Examine the command and its output:

  SQL> DROP TABLE EMPLOYEE;

  SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

  RECYCLE_NAMEORIGINAL_NAMETYPE

  binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

  You then successfully execute the command:

  SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

  Which two statements are true?

  A. It flashes back the employee table and all the constraints associated with the table.

  B. It automatically flashes back all the indexes on the employes table.

  C. It automatically flashes back any triggers defined on the table.

  D. It flashes back only the structure of the table and not the data.

  E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

  Correct Answer: BC

  A table and all of its dependent objects (indexes, LOB segments, nested tables, triggers, constraints and so on) go into the recycle bin together, when you drop the table. Likewise, when you perform Flashback Drop, the objects are generally all retrieved together. Trigger automatically flashbacked. References: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594

• Question 140:

  Which two statements are true about service creation for pluggable databases (PDBs)?

  A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

  B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

  D. Only a common user can create additional services for a PDB.

  E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

  Correct Answer: AC