Free 1Z0-063 Exam Dumps

No Installation Required, Instantly Prepare for the 1Z0-063 exam and please click the below link to start the 1Z0-063 Exam Simulator with a real 1Z0-063 practice exam questions.
Use directly our on-line 1Z0-063 exam dumps materials and try our Testing Engine to pass the 1Z0-063 which is always updated.

Exam Code: 1Z0-063
Exam Title: Oracle Database 12c: Advanced Administration
Vendor: Oracle
Exam Questions: 276
Last Updated: July 3rd,2024

Question 1

- (Exam Topic 1)
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)

A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
B. Setting the target tablespace to read-only after the segments are moved
C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
D. Taking the target tablespace offline after the segments are moved
E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Correct Answer:BC

Question 2

- (Exam Topic 2)
You use RMAN to take regular backups for your database. Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPITED BACKUP;
Which statement is true?

A. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated.
B. All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, is deleted.
C. All backups that have exceeded the age set by the RMAN retention policy are deleted.
D. All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from the repository.

Correct Answer:B

Question 3

- (Exam Topic 2)
Which two are prerequisites for performing Flashback Transaction? (Choose two.)

A. A supplemental log must be enabled for the primary key.
B. Undo retention guarantee must be configured for the database.
C. Fast Recovery Area must be enabled for the database.
D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
E. Row movement must be enabled.

Correct Answer:AD

Question 4

- (Exam Topic 1)
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)

A. The COMPATIBLE initialization parameter is set to 10.2 or higher.
B. There are no guaranteed restore points defined for the database.
C. The default device for the backup must be set to disk.
D. The tablespaces are locally managed.
E. The fast recovery area is less than 50 percent free.

Correct Answer:ABD

Question 5

- (Exam Topic 2)
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security

Correct Answer:B