QUESTION: 25

Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1.Create media families for data files and archived redo log files.
2.Configure database backup storage selectors or RMAN media management parameters.
3.Create an OSB user preauthorized for RMAN operations.
4.Configure RMAN Access to the OSB SBT.
5.Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.

1, 4, 3, 2, 5
1, 3, 4, 5, 2
4, 3, 1, 2, 5
4, 3, 5, 1, 2

Answer(s): A

Show Answer Next Question

QUESTION: 26

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

password-mode encryption
dual-mode encryption
transparent encryption
default encryption

Answer(s): A

Reference:

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH(t o make password encrypted backups)

Show Answer Next Question

QUESTION: 27

The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.

2, 4, 5
2, 1, 4, 3, 5
1, 2, 3, 4, 5
1, 2, 4, 5

Answer(s): B

Show Answer Next Question

QUESTION: 28

You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

USERS
SYSTEM
SYSAUX
EXAMPLE

Answer(s): A

Explanation:

This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

Show Answer Next Question

Free Oracle 1Z0-067 Exam Questions (page: 8)

QUESTION: 25

QUESTION: 26

Reference:

QUESTION: 27

QUESTION: 28

Explanation:

1Z0-067 Exam Discussions & Posts