多项选择题

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A. The database writer writes to a trace file， indicating that the temporary file is not found.
B. The database prompts for a database recovery.
C. The database opens normally.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.

点击查看答案

上一题目录下一题

相关考题

多项选择题

What are the prerequisites for enabling Flashback Database？（）

A. The database must be started in the MOUNT EXCLUSIVE state.
B. The database must have multiplexed control files.
C. The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
D. The database must be in ARCHIVELOG mode.
E. The database must be in the NOMOUNT state.
F. The database must be opened in RESTRICTED mode.

单项选择题

The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

A. The Oracle database will not perform block checking for any of the data blocks.
B. The Oracle database will perform block checking for the default permanent tablespace only.
C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

多项选择题

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？（）

A. log buffer
B. Java pool
C. Large pool
D. Fixed SGA
E. Shared pool
F. Streams pool
G. Keep buffer cache
H. Database buffer cache