Free Oracle 1z0-063 Exam Dumps Questions & Answers

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A.  Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
• B.  Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
• C.  Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• D.  Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.

Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.

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

Examine the command to back up the ASM metadata:
ASMCMD> md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

• A.  when one or more disks in an ASM disk group are lost
• B.  when one of the disks in a disk group is accidentally unplugged
• C.  when the data file on an ASM disk group gets corrupted
• D.  when all the ASM disk groups for the ASM instance are lost
• E.  when one or more file directory paths are accidentally deleted from an ASM disk group

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.  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.
• 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.  expdp will fail because no path has been defined for the dumpfile.

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods for recovering the truncated table data? (Choose two.)

• A.  Tablespace Point-in-Time Recovery
• B.  Table Point-in-Time Recovery
• C.  Flashback Database
• D.  Flashback Transaction Backout
• E.  Database Point-in-Time Recovery