PassLeader now are offering 100% pass ensure 1Z0-067 dumps! All 1Z0-067 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-067 VCE dumps and PDF dumps: http://www.passleader.com/1z0-067.html (188 Q&As –> 242 Q&As)
BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM
QUESTION 121
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.
Answer: CD
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm
QUESTION 122
Your database is running in archivelog 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.
Answer: BE
Explanation:
https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582
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.
QUESTION 123
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, 2013.
– The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
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.
Answer: D
QUESTION 124
You set the following parameters in the parameter file and restart the database instance:
NEMORY_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_targetand sga_target parameters are automatically set to zero.
C. The value of the memory_max_targetparameter remains zero for the database instance.
D. The lower limits of the pga_aggregate_target and sga_targetparameters 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.
Answer: CD
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11200 (See the second note on the page)
QUESTION 125
Your database supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttrestimated_mttr
———————- —————————
To ensure faster instance recovery, you set the fast_start_mttrjtargh:t 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.
Answer: C
Explanation:
http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm
QUESTION 126
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.
Answer: ADE
Explanation:
http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668
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’.
QUESTION 127
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.
Answer: B
Explanation:
https://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007514
QUESTION 128
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.
Answer: AB
Explanation:
https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG343
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
https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-8489-08988E1181F6.htm#TDPSG55281
Enable the unified auditing executable.
UNIX: Run the following command:
make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024
The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
QUESTION 129
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost. Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.
A. 7, 6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
Answer: D
Explanation:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245
“If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no datafiles have been restored, and open the database with the RESETLOGS option.”
QUESTION 130
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?
A. ASM disk groups with ASM disks consisting of Exadata Grid Disks
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Answer: AEG
Explanation:
HCC requires the use of Oracle Storage ?Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above.
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
QUESTION 131
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?
A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. taking a new snapshot and comparing it with a preserved snapshot
Answer: A
Explanation:
Comparing Current System Performance to a Baseline Period
You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes. The Advisor can analyze any Oracle RDBMS version 10.2.0.4 or later monitored by Cloud Control. The following procedure explains how to initiate a report from the Compare Period ADDM.
QUESTION 132
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?
A. maximum undo per consumer group
B. maximum idle time for a session in a PDB
C. parallel server limit
D. CPU
E. maximum number of sessions for a PDB
Answer: CD
QUESTION 133
Which three types of failures are detected by the Data Recovery Advisor (DRA)?
A. loss of a non-critical data file
B. loss of a control file
C. physical data block corruption
D. logical data block corruption
E. loss of an archived redo log file
Answer: ABC
Explanation:
Data Recovery Advisor can diagnose failures such as the following:
Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on Physical corruptions such as block checksum failures and invalid block header field values.
QUESTION 134
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(`SH’, ‘CUSTOMERS’)from dual statement.
2. Execute the dbms_stats.seed_col_usage (null,`SH’,500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage(`SH’, ‘customers’) from dual statement.
Identify the correct sequence of steps.
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
Answer: B
QUESTION 135
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST =’/u01/app/oracle/oradata/’
You execute the following command to create the CDB1. container database (CDB):
SQL>CREATEDATABASECDB1
DEFAULTTABLESPACE users
DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl
ENABLEPLUGGA3LEDATABASE
SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
SYSAUXDATAFILESSIZE100M;
Which three statements are true?
A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.
Answer: ABE
Explanation:
The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.
PassLeader now are offering 100% pass ensure 1Z0-067 dumps! All 1Z0-067 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-067 VCE dumps and PDF dumps: http://www.passleader.com/1z0-067.html (188 Q&As –> 242 Q&As)
BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM