Examine the following RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS

ARCHIVELOG;

Which perquisite must be met before accomplishing the backup?

A. Provide a password for the encryption.

B. Set up an Oracle wallet for the encryption.

C. No setup is required as it is a default encryption method.

D. Both Oracle wallet and password must be set up for the encryption.

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS

SQL> ALTER TABLE altb SHRINK SPACE COMPACT;

Table altered.

SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;

BLOCKS

View the Exhibit and examine the output and commands executed on the ALTB table.

Why does the number of blocks for the table remain the same after the shrink operation?

A. because the table did not contain migrated or chained rows

B. because the row IDs remain the same for all rows during the shrink operation

C. because the progress of the shrink operation is not saved in the bitmap blocks of the table

D. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

A. SORT_AREA_SIZE

B. HASH_AREA_SIZE

C. BITMAP_MERGE_AREA_SIZE

D. CREATE_BITMAP_AREA_SIZE

E. PGA_AGGREGATE_TARGET

In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching.

B. It can be installed and uninstalled via OPatch unlike conventional patching.

C. It takes more time to install or uninstall compared with conventional patching.

D. It does not require down time to apply or remove unlike conventional patching.

E. It is not persistent across instance startup and shutdown unlike conventional patching.

You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP =>'group1', COMMENT => 'New Group'); This command errors out displaying the following message: ERROR at line 1: ORA-29371: pending area is not active ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error?

A. activate the Pending Area before creating the consumer group

B. create the Pending Area before creating the consumer group

C. increase the size of the database buffer cache to accommodate the Pending Area

D. increase the size of the shared pool to accommodate the Pending Area

E. increase the size of the large pool to accommodate the Pending Area