CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Online 1z0-067 Questions Video

Page: 7 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 25

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Options:

A.

A DBA can check specific tables with the DMU

B.

The database to be migrated must be opened read-only.

C.

The release of the database to be converted can be any release since 9.2.0.8.

D.

The DMU can report columns that are too long in the converted characterset

E.

The DMU can report columns that are not represented in the converted characterset

Question 26

Which three statements are true about common roles? (Choose three.)

Options:

A.

A common role can be granted only to a common user

B.

Only system privileges can be granted to a common role to a container database (CDB)

C.

Object privileges can be granted to a common role in a pluggable database (PDB)

D.

A common rule cannot be created by a local user

E.

A common user that is granted a common role can grant the role to other common and local users in a PDB

Question 27

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.

Options:

A.

1, 4, 3, 2, 5

B.

1, 3, 4, 5, 2

C.

4, 3, 1, 2, 5

D.

4, 3, 5, 1, 2

Question 28

Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.

Identify two events that can occur at the time of a log switch. (Choose two.)

Options:

A.

All active transactions are rolled back and the database instance shuts down.

B.

The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.

C.

The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.

D.

An entry is written in the alert log and the database instance is automatically placed in MOUNT state.

E.

The log switch hangs until free space is available in the fast recovery area.

Page: 7 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF