Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

A. It is overridden by LOG_CHECKPOINT_INTERVAL

B. If it is set to 0, the MTTR Advisor is disabled

C. A higher value increases the I/O overhead

D. It is applicable only when the database is in ARCHIVELOG mode

E. A lower value increases the time taken to perform instance recovery

Which is true about the Database Configuration Assistant (DBCA)?

A. It can register a database with Cloud Control and configure Database Control for the same database.

B. It can change the server mode from dedicated to shared and vice versa for an existing database.

C. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.

D. It can create new database templates only from existing templates or databases.

For which requirement should you configure shared servers?

A. accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory

B. submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory

C. using Recovery Manager (RMAN) to recover a database

D. performing bulk-load operations in a DSS environment with limited memory

E. accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory

database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: $ impdp system/manager directory = DB_DATA

dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"

The command fails displaying the following error:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA- 27037: unable

to obtain file status

What would you do to overcome the error?

A. Add the user, SYSTEM, to the schemas option.

B. Add the network_link = devdb.us.oracle.com option.

C. Change the dumpfile option to [email protected].

D. Replace the schemas option with the network_link = devdb.us.oracle.com

E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?

A. XML script

B. PL/SQL script

C. Operating system script

D. Recovery Manager (RMAN) script