web analytics

100% Pass Ensure 1Z0-067 Dumps with Free VCE and PDF (Question 76 – Question 90)

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 76
Which two statements are true about a common user?

A.    A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
B.    A common user with the create user privilege can create other common users, as well as local users.
C.    A common user can be granted only a common role.
D.    A common user can have a local schema in a PDB.
E.    A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: BD
Explanation:
http://www.oracle.com/technetwork/issue-archive/2014/14-nov/o64ocp12c-2349447.html

QUESTION 77
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. Which action must you take for recovery?

A.    Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
B.    Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
C.    Restore all the data files, recover them by using the recover database command, and open the database.
D.    Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer: B
Explanation:
https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140
See Example 3-6 Recovering a NOARCHIVELOG Database
STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE; # restore control file from consistent backup
ALTER DATABASE MOUNT;
RESTORE DATABASE; # restore data files from consistent backup
RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost
ALTER DATABASE OPEN RESETLOGS;

QUESTION 78
Which three statements are true about Oracle Restart?

A.    It can be configured to automatically attempt to restart various components after a hardware or software failure.
B.    While starting any components, it automatically attempts to start all dependencies first and in proper order.
C.    It can be configured to automatically restart a database in case of normal shutdown of the database instance.
D.    It can be used to only start Oracle components.
E.    It runs periodic check operations to monitor the health of Oracle components.

Answer: ABE
Explanation:
A is correct: http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software failure or whenever your database host computer restarts.
E is correct: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted.
B is also correct:
About Startup Dependencies
Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.

QUESTION 79
Examine the parameters for your database instance:
NAMETYPEVALUE
———————————————————————–
optimizer_adaptive_reporting_only  boolean  FALSE
optimizer_capture_sql_plan_baselines  boolean  FALSE
optimizer_dynamic_sampling  integer  2
optimizer_features_enable  string  12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?

A.    The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B.    The optimizer can re optimize a query only once using cardinality feedback.
C.    The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D.    The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E.    After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Answer: ACD

QUESTION 80
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the duplicate command?

A.    All archive redo log files are automatically copied to the duplicate database.
B.    The duplicate database has the same directory structure as the source database.
C.    The duplicate database is created by using the backups created during the execution of the duplicate command.
D.    The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
E.    The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Answer: BE

QUESTION 81
A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u0l/app/oracle/oradata/ORCL/temp01.dbf’
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

A.    Drop the tenpOi.dbf file, and then re-create the temp file.
B.    Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
C.    Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
D.    Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
E.    Create a new temporary tablespace and assign it as the default to the user.

Answer: BE

QUESTION 82
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?

A.    Enable temporary undo for the database.
B.    Enable undo retention guarantee.
C.    Increase the size of the redo log buffer.
D.    Enable Automatic Memory Management (AMM).
E.    Increase the size of the temporary tablespace.

Answer: AE
Explanation:
http://docs.oracle.com/database/121/ADMIN/undo.htm#CEGJGIAE

QUESTION 83
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.

Answer: AC

QUESTION 84
You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

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

Answer: B

QUESTION 85
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.

Answer: AC
Explanation:
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.
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594

QUESTION 86
Which parameter must be set to which value to implement automatic PGA memory management?

A.    Set memory_target to zero.
B.    Set STATISTICS_LEVEL to BASIC.
C.    Set pga_aggregate_target to a nonzero value.
D.    Set pga_aggregate_target and sga_target to the same value.
E.    Set sgajtarget to zero.

Answer: C
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm
When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management.

QUESTION 87
Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ‘ /u02/backup/%U’ ;
RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?

A.    The script is executed and bothDC1and chi channels are used for script execution.
B.    The execution of the script fails because multiple channels cannot exist simultaneously.
C.    The persistent configuration parameter,DC1, is overridden because a new channel is allocated in the RMAN run block.
D.    The new channel, chi, is ignored because a channel has been configured already.

Answer: C
Explanation:
https://docs.oracle.com/cd/B12037_01/server.101/b10770/rcmsynta4.htm

QUESTION 88
You create two Resource Manager plans, one for night time workloads, the other for day time. How would you make the plans switch automatically?

A.    Use job classes.
B.    Use scheduler windows.
C.    Use the mapping rule for the consumer groups.
D.    Set the switch_time plan directive for both plans.
E.    Use scheduler schedules.

Answer: B
Explanation:
The resource manager is only activated when a default resource plan is assigned. Only one resource plan can be active at any given time. Resource plan switches can be automated using scheduler windows or performed manually by setting the resource_manager_plan parameter using the alter system command as shown below.
http://www.dba-oracle.com/job_scheduling/resource_manager_plan.htm

QUESTION 89
Which three statements are true about Consolidated Database Replay?

A.    The workload capture and replay systems must have the same operating system (OS).
B.    Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
C.    A subset of the captured workload can be replayed.
D.    The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E.    Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: BCE
Explanation:
https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A154-6581C678FC8A.htm#RATUG105
These capture files are platform independent and can be transported to another system.
https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD3-79807968EA9E.htm#RATUG4199
You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs.
https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0A-B4F7F45C81F8.htm
https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12-C6D72232886A.htm

QUESTION 90
Which two statements are true about Flashback Version Query?

A.    The result of a query can be used as part of a DML statement.
B.    It can be used to create views.
C.    It can be used only if Flashback Data Archive is enabled for a table.
D.    It retrieves all versions of rows that exist in a time interval, including the start time and end time.
E.    It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: DE
Explanation:
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004


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