Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)

A. A segment cannot span data files.

B. A data file can belong to only one tablespace.

C. An extent cannot span data files.

D. The size of an Oracle data block in a data file should be the same as the size of an OS block.

You have successfully taken a database backup by using the command:

RMAN> BACKUP AS BACKUPSET DATABASE;

Now you execute this command:

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

What is the outcome?

A. It fails because an incremental level 1 backup always searches for an image copy as level 0 backup.

B. It fails because an incremental level 0 backup does not exist.

C. It takes a backup of blocks that have been formatted since the last full database backup.

D. It takes an incremental level 0 backup of the database.

E. It first takes an incremental level 0 backup and then an incremental level 1 backup.

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

A. You cannot specify how partitioned tables should be handled during an import operation.

B. Only data can be compressed during an export operation.

C. Existing dump files can be overwritten during an export operation.

D. Tables cannot be renamed during an import operation.

E. Metadata that is exported and imported can be filtered based on objects and object types.

Your database is configured in ARCHIVELOG mode.

Examine the RMAN configuration parameters:

Examine the command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two are true? (Choose two.)

A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command

B. It creates image copies of the archivelogs

C. It creates a backupset of archive log files

D. It creates image copies of the database files

E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300

to 400 and make it persistent for your database instance.

You plan to use the ALTER SYSTEM command.

Which two methods can be used? (Choose two.)

A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.

B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.

C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.

D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.

F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.