首页计算机考试Oracle认证
(多选题)

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? ()

AThe database opens normally.

BThe database prompts for a database recovery.

CThe database writer writes to a trace file, indicating that the temporary file is not found.

DThe database gets mounted and throws an error indicating that the temporary file requires recovery.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()

    答案解析

  • (多选题)

    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?()

    答案解析

  • (单选题)

    Your database is in the NOARCHIVELOG mode. Since last night’s offline backup, the logs in group 1 have been written to twice. This morning, the SYSTEM data file has become corrupted. Up to what point can it be recovered?()

    答案解析

  • (单选题)

    You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?()

    答案解析

  • (多选题)

    You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?()

    答案解析

  • (单选题)

    Which of the following calendaring syntax expressions would evaluate to the last day of every month?()  

    答案解析

  • (单选题)

    Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?()  

    答案解析

  • (单选题)

    Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()

    答案解析

  • (单选题)

    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8.30 a.m. With reference to this scenario, what would you do to recover the database?()

    答案解析

快考试在线搜题