1. Which of these initialization parameters in used for Oracle Managed Files (OM

Question

1. Which of these initialization parameters in used for Oracle Managed Files (OMF)? (Choose all correct answers.)

A. DB_CREATE_FILE_DEST

B. DB_CREATE_ONLINE_FILE_DEST

C. DB_CREATE_ONLINE_LOG_DEST

D. DB_CREATE_ONLINE_LOG_DEST_n

E. CONTROL_FILES

2.   You launch a Data Pump job with expdp and then exit from the session. Which of the following is true? (Choose all correct answers.)

A. The job will continue running in the background.

B. The job will terminate.

C. You cannot monitor the job once you have exited.

D. You can reattach to the job to monitor it.

E. The job will pause but can be restarted.

3. Under which of these circumstances might Flashback Database be of use?

A. To recover a dropped table

B. To recover a dropped schema

C. To recover a damaged datafile

D. To reverse a bad transaction

E. All of the above

4. Which of the following files should be multiplexed, for safety? (Choose all correct answers.)

A. System tablespace datafiles

B. Control file

C. Initialization parameter file

D. Archive logfiles

5. Which of the following is correct about Flashback Database? (Choose two correct answers.)

A. You should set the FLASHBACK_BUFFER_SIZE parameter.

B. You must create the flashback log files.

C. You must set the DB_RECOVERY_FILE_DEST parameter.

D. You must issue ALTER SYSTEM FLASHBACK ON.

E. You must issue ALTER DATABASE FLASHBACK ON.

Explanation / Answer

1-A- DB_CREATE_FILE_DEST - it defines the location of the default file system directory or oracle asm disk group where the data base creates datafiles or temp files. it is also used as the default location for redo log and control files.
D- DB_CREAATE_ONLINE_LOG_DEST_n -It defines the location of the default file system directory or oracle ASM disk group for redo log files and control file creation when no file specification is given in the create operation. by changing n we can use the initialization parameter multiple times.

2-A-The job will continue running in the background.
D-You can reattach to the job to monitor it.

3-D-To reverse a bad transaction.

4-B-Control File
D-Archive Logfiles.

5-B-you must create the flashback log files.
C-you must set the DB-RECOVERY_FILE_DEST parameter.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.