PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg
QUESTION 71
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?
A. A job is specified as part of a program definition.
B. A program can be used in the definition of multiple jobs.
C. A program and job can be specified as part of a schedule definition.
D. A program and schedule can be specified as part of a job definition.
E. A program and window can be specified as part of a job definition.
Answer: BCD
QUESTION 72
Which two statements are true regarding Oracle Data Pump?
A. EXPDP and IMPDP are the client components of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
Answer: AB
QUESTION 73
Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost. Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set D3ID of the target database in RMAN.
2. Start the database instance by using the startup force nomount command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore theSPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in nomount state.
Identify the required steps in the correct order.
A. 1, 2, 5, 3, 6, 4
B. 1, 2, 3, 5, 6, 4
C. 2, 1, 5, 7, 3, 4
D. 2, 1, 5, 6, 7, 4, 3
Answer: C
QUESTION 74
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.
Identify the required steps in the correct order.
A. 1, 6, 4
B. 2, 3, 7, 5
C. 1, 2, 6, 4
D. 1, 2, 3, 6, 5
Answer: C
QUESTION 75
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, youset 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: A
QUESTION 76
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Answer: A
QUESTION 77
You notice a performance change in your production Oracle 12c database. You want to knowwhich 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: B
QUESTION 78
You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A. USERS
B. SYSTEM
C. SYSAUX
D. EXAMPLE
Answer: A
QUESTION 79
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 dumpfile.
B. expdp will succeed but impdp 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
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
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.
Answer: AB
QUESTION 82
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 exceptsys
B. all users except scott
C. all users except sys and scott
D. all users except sys, system, and scott
Answer: B
QUESTION 83
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.
create_pendingarea();
PL/SQL procedure successfully completed.
SQL>execd bms_resource_manager,
create_consumergroup
(consumer_group=>’OLTP,,comment=>,onlineuser’)
PL/SQL procedure successfully completed.
SQL>execdbras_resource_raanager.
create_plan(plan=>’PRIU3ER3′,comment=>’dssprio’);
SQL>exec Dbms_resource_manager.
create_plan_directive(plan=>’PRIU3ER3′,
group_or_subplan=>’
OLTP’,comraent=>’onlinegrp’CPU_Pl=>60);
PL/SQL procedure successfully completed.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager.
validate_pending_area ();
What is the reason for the error?
A. The pending area is automatically submitted when creating plan directives.
B. The procedure must be executed before creating any plan directive.
C. The sys_group group is not included in the resource plan.
D. The other_groups group is not included in the resource plan.
E. Pending areas can not be validated until submitted.
Answer: B
QUESTION 84
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile ORA-01110:data file 11:’/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf’ To repair the failure, you open an RMAN session for the target database CDBSROOT.
You execute the following as the first command:
RMAN>REPAIRFAILURE;
Which statement describes the consequence of the command?
A. The command performs the recovery and closes the failure.
B. The command produces an error because RMAN is not connected to the target database pdb_1.
C. The command produces an error because the advise failure command was not executed before the REPAIRFAILUER command.
D. The command executes successfully, performs recovery, and opens PDB_1.
Answer: D
PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)
BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg