web analytics

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP 1Z0-067 Dumps With VCE and PDF Download (Question 16 – Question 30)

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)

BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM

QUESTION 16
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval. Which three are prerequisites to fulfill this requirement?

A.    Minimal supplemental logging must be enabled.
B.    The database must be running in archivelog mode.
C.    Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
D.    The flashback any table privilege must be granted to the user.
E.    The select any transaction privilege must be granted to the user.
F.    Therecycle binparameter must be set to on.

Answer: ABE
Explanation:
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612
To configure your database for the Flashback Transaction feature, you or your database administrator must:
With the database mounted but not open, enable ARCHIVELOG:
ALTER DATABASE ARCHIVELOG;
Open at least one archive log:
ALTER SYSTEM ARCHIVE LOG CURRENT;
If not done, enable minimal and primary key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
Granting Necessary Privileges
For Oracle Flashback Transaction Query
Grant the SELECT ANY TRANSACTION privilege.
For Oracle Flashback Query and Oracle Flashback Version Query
To allow access to specific objects during queries, grant FLASHBACK and SELECT privileges on those objects.
To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege.

QUESTION 17
Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

A.    expdp will fail because no path has been defined for the dump file.
B.    expdp will succeed butimpdp will fail because the users do not exist.
C.    inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
D.    impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Answer: B
Explanation:
ORA-39165: Schema not found error will be resulted

QUESTION 18
Which two statements are true about a multitenant architecture?

A.    Each pluggable database (PDB) has its own initialization parameter file.
B.    A PDB can have a private undo tablespace.
C.    Log switches occur only at the container database level.
D.    A PDB can have a private temporary tablespace.
E.    Each PDB has a private control file.

Answer: CD
Explanation:
You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.

QUESTION 19
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = (‘/disk1/oracle/pdb1/’, ‘/disk2/oracle/pdb2/’)
PATH_PREFIX = ‘/disk2/oracle/pdb2’;
Which two statements are true?

A.    The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
B.    Details about the metadata describing pdb2 are stored in an XML file in the’/disk2/oracle/pdb2/’ directory.
C.    The tablespace specifications of pdb2 are the same as pdb1.
D.    All database objects belonging to common users in PD3I are cloned in PD32.
E.    pdb2 is created with its own private undo and temp tablespaces.

Answer: AC
Explanation:
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586

QUESTION 20
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A.    tracking the most recent read time for a table segment in a user tablespace
B.    tracking the most recent write time for a table segment in a user tablespace
C.    tracking insert time by row for table rows
D.    tracking the most recent write time for each block in a table segment
E.    tracking the most recent read time for a table segment in the sysauxtablespace
F.    tracking the most recent write time for a table segment in the sysauxtablespace

Answer: ABD
Explanation:
Tracking of segment-level reads and writes.
At the block level, Heat Map tracks only the most recent modification time stamp.

QUESTION 21
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A.    Reduced logical I/O
B.    Reduced virtual memory utilization
C.    Improved Serial Execution performance
D.    Reduced physical I/O
E.    Reduced CPU utilization

Answer: BE
Explanation:
https://petesdbablog.wordpress.com/2013/07/09/12c-new-feature-multi-process-multi-threaded-oracle/
This Architecture have some Benefits:
CPU usage reduction
Memory usage reduction
Better performance for parallel executions / operations
Better system reliability

QUESTION 22
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN target / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN backup command with the sbt channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB sbt library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

A.    1, 4, 6, 5, 8, 3, 9
B.    1, 6, 4, 5, 8, 3, 9
C.    2, 4, 6, 5, 8, 3, 7
D.    2, 4, 5, 8, 3, 7, 9

Answer: C
Explanation:
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.
https://docs.oracle.com/cd/E26569_01/doc.104/e21476/osb_rman_backup.htm#OBADM190

QUESTION 23
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A.    The backup must be performed in mount state.
B.    The tablespace must be taken offline.
C.    All files must be backed up as backup sets.
D.    The database must be backed up as an image copy.

Answer: C

QUESTION 24
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

A.    all users except sys
B.    all users except scott
C.    all users except sys and scott
D.    all users except sys, system, and scott

Answer: B
Explanation:
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY … EXCEPT statements are overridden by the latest AUDIT POLICY … EXCEPT statement.

QUESTION 25
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

A.    It is immediately set to all in the SPFILE and the CDB instance.
B.    It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
C.    It is immediately set to all only for cd3Sroot.
D.    It is immediately set to all in all PDBs where the statistics_level parameter is not set.
E.    It is set to all for all PDBs only in the SPFILE.

Answer: AD
Explanation:
When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only. Their system-wide state is not changed.

QUESTION 26
You are administering a multitenant container database (CDB). Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

A.    by using the connect statement as a local user having only the set container privilege
B.    by using easy connect
C.    by using external authentication
D.    as a common user with the set container privilege
E.    by executing the alter session set container command as a local user

Answer: BD
Explanation:
https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13861

QUESTION 27
In which situation can you use Flashback Database?

A.    when undoing a shrink data file operation
B.    when retrieving a dropped tablespace
C.    when returning to a point in time before the restoration or re-creation of a control file
D.    when returning to a point in time before the most recent open resetlogs operation

Answer: B
Explanation:
TO BEFORE RESETLOGS
Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS.
Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later.
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

QUESTION 28
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace. You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

A.    It returns an error because there is no level 0 backup available for new data files.
B.    It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
C.    It performs a level-0 backup of all data files including those that belong to the new tablespace.
D.    It performs an image copy backup of all data files including those that belong to the new tablespace.
E.    It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Answer: B
Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

QUESTION 29
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

A.    The compatible initialization parameter is set to 10.2 or higher.
B.    There are no guaranteed restore points defined for the database.
C.    The default device for the backup must be set to disk.
D.    The tablespaces are locally managed.
E.    The fast recovery area is less than 50 percent free.

Answer: ABD
Explanation:
http://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89481
About Unused Block Compression
When employing unused block compression, RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated. So if a database table is dropped, RMAN will not back up the space that was occupied by that table until new objects are created in that space. Unused block compression is used automatically when the following conditions are true:
– The COMPATIBLE initialization parameter is set to 10.2 or higher.
– There are currently no guaranteed restore points defined for the database.
– The data file is locally managed.
– The data file is being backed up to a backup set as part of a full backup or a level 0 incremental backup.
– The backup set is created on disk, or Oracle Secure Backup is the media manager.

QUESTION 30
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A.    SQL Performance Analyzer
B.    SQL Access Advisor
C.    SQL Tuning Advisor
D.    Automatic Workload Repository (AWR) report
E.    Automatic Database Diagnostic Monitor (ADDM)

Answer: B
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160


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)

BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM