Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough. What could be a solution to make streaming happen during the backup?

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

For which three requirements would you use the Database Resource Manager? (Choose three.)

Examine the following command: SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command?

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?

Which three statements are true about Oracle Data Pump? (Choose three.)

You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command. CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20; How does the PCTFREE storage parameter influence data storage for this table?