Free Oracle 1z1-063 Exam Dumps Questions & Answers

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A.  statistics recommendations
• B.  SQL profile recommendations
• C.  SQL statement restructure recommendations
• D.  creation of materialized views to improve query performance

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? (Choose two.)

• A.  A suspended statement will report an error if no corrective action has taken place during a timeout period.
• B.  Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C.  Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
• D.  A resumable statement can be suspended and resumed only once during execution.
• E.  Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

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 succeed but impdp will fail because the users do not exist.
• B.  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.
• C.  expdp will fail because no path has been defined for the dumpfile.
• D.  inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.
Identify the minimum requirement for accomplishing the task.

• A.  All tablespaces in the database must be locally managed.
• B.  Redo log groups must have at least two members each.
• C.  The database must be configured in ARCHIVELOG mode.
• D.  An RMAN channel must be configured to device-type disk.

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)

• A.  PFILE and password file in MOUNT state
• B.  data files while the database is open
• C.  online redo log files while the database is open
• D.  data files while the database is in NOMOUNT state
• E.  data blocks in data files that have changed since the previous backup