Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Oracle
  3. Oracle Database 12c
  4. 1z0-063 - Oracle Database 12c: Advanced Administration
Note! Following 1z0-063 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-063 Exam Dumps - Oracle Database 12c: Advanced Administration

Go to page:
Question # 17

Which three statements are true about compression of backup sets? (Choose three.)

A.

Compressed backups can only be written to media.

B.

Binary compression creates performance overhead during a backup operation.

C.

Unused blocks below the high-water mark are not backed up.

D.

Compressed backups cannot have section size defined during a backup operation.

E.

It works only for locally managed tablespaces.

Full Access
Question # 18

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 resumable statement can be suspended and resumed only once during execution.

B.

Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

C.

A suspended statement will report an error if no corrective action has taken place during a timeout period.

D.

Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

E.

Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Full Access
Question # 19

Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A.

The PDB is closed and the temp file is re-created automatically when the PDB is opened.

B.

The PDB is closed and requires media recovery at the PDB level.

C.

The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.

D.

The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Full Access
Question # 20

Examine the backup requirement for your company:

1) Every Sunday, a backup of all used data file blocks is performed.

2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.

3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.

Which backup strategy satisfies the requirements?

A.

level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

B.

level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

C.

full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

D.

full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Full Access
Question # 21

You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

A.

It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

B.

It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

C.

It executes successfully and continues to store metadata related to the EMPLOYEES table.

D.

It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Full Access
Question # 22

Examine the command used to perform an incremental level-0 backup:

RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;

To enable block change tracking, after the incremental level 0 backup, you issue the command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING

FILE'/mydir/rman_change_track.f';

To perform an incremental level-1 cumulative backup, you issue the command:

RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

Which two statements are true in the preceding situation? (Choose two.)

A.

The block change tracking data is used only from the next incremental backup.

B.

The incremental level 1 backup fails because a block change tracking file is created after the level 0 backup.

C.

The incremental level 1 backup does not use change tracking data for accomplishing the backup.

D.

The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

E.

The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Full Access
Question # 23

Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.

Examine the steps to recover the online redo log group and move it to a new location.

1. Restore the corrupted redo log group.

2. Restore the database from the most recent database backup.

3. Perform an incomplete recovery.

4. Relocate the member of the damaged online redo log group to a new location.

5. Open the database with the RESETLOGS option.

6. Issue a checkpoint and clear the log.

Identify the required steps in the correct order.

A.

1, 3, 4, 5

B.

6, 3, 4, 5

C.

2, 3, 4, 5

D.

6, 4, 3, 5

Full Access
Question # 24

Which two are true about RMAN image copies? (Choose two.)

A.

The can only be written to disk.

B.

They are the only backup option available for database in NOARCHIVELOG mode.

C.

They can be encrypted using Transparent Data Encryption (TDE).

D.

They can be used as a level 0 incremental backup.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps