1z0-067 Oracle Exam Questions and Free Practice Test

Question 13

ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is read into memory.

C. The data remains encrypted when it is stored in the redo logs

D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Correct Answer:C

Question 14

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1.Start the RMAN client by using the RMAN target / command. 2.Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN backup command with the sbt channels. 5.OSB creates a backup job and assigns a unique identifier. 6.OSB creates a backup job request through the OSB sbt library.
7.OSB stores metadata about RMAN backup pieces in the OSB catalog. 8.OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

A. 1, 4, 6, 5, 8, 3, 9

B. 1, 6, 4, 5, 8, 3, 9

C. 2, 4, 6, 5, 8, 3, 7

D. 2, 4, 5, 8, 3, 7, 9

Correct Answer:C
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece. https://docs.oracle.com/cd/E26569_01/doc.104/e21476/osb_rman_backup.htm#OBADM190

Question 15

For which three pieces of information can you use the RMAN list command?

A. stored scripts in the recovery catalog

B. available archived redo log files

C. backup sets and image copies that are obsolete

D. backups of tablespaces

E. backups that are marked obsolete according to the current retention policy

Correct Answer:ABD
About the LIST Command: The primary purpose of the LIST command is to list backup and copies. For example, you can list: -Backups and proxy copies of a database, tablespace, datafile, archived redo
log, or control file -Backups that have expired -Backups restricted by time, path name, device type, tag, or recoverability -Archived redo log files and disk copies http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

Question 16

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?

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 TBS 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
2018-04-01T21:59:00.52
2018-04-01T21:59:00.53
2018-04-01T21:59:00.56
2018-04-01T21:59:00.56
2018-04-01T21:59:00.56
The threshold for activating tiering policies is based on two parameters: TBS PERCENT USED
TBS PERCENT FREE
Both values can be controlled by the DBMS_ILM_ADMIN package.
TBS PERCENT USED and TBS PERCENT FREE default to 85 and 25, respectively. Hence, whenever the source tablespace’s usage percentage goes beyond 85 percent, any tiering policy specified on its
objects will be executed and objects will be moved to the target tablespace until the source tablespace becomes at least 25 percent free. Note that it is possible to add a custom condition to tiering policies to enable movement of data based on conditions other than how full the tablespace is.
In addition, the READ ONLY option must be explicitly specified for the target tablespace. 2018-04-01T21:59:00.56

Question 17

Which two statements are true when row-archival management is enabled?

A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

C. The row archival visibility session parameter defaults to all rows.

D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Correct Answer:BD

Question 18

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR base is shared across multiple instances.

B. The ADR base keeps all diagnostic information in binary format.

C. The ADR can be used to store statspack snapshots to diagnose database performance issues.

D. The ADR can be used for problem diagnosis even when the database instance is down.

E. The ADR is used to store Automatic Workload Repository (AWR) snapshot

Correct Answer:AD

START 1z0-067 EXAM