当前位置:1z0-043题库

问题:

[单选]

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.  
On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.  
When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()

A .  The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
B .  The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
C .  The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
D .  The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.

When defining a function activity, what is true about the Result Type?() (Choose two.) Result Type is optional.。 Result Type is mandatory.。 Result Type can be changed after it is assigned to the function activity.。 Result Type should belong to the same item type as the function activity。 分部工程验收应在施工单位进行一次系统的整体检查验收的基础上,由()组织进行联合检查验收。 业主。 施工单位。 项目法人。 监理单位。 What is the purpose of the recover command?()   Recover database datafiles from physical disk backup sets.。  Recover required incremental backups from physical disk backup sets.。  Recover required archived redo logs from physical disk backup sets.。  Apply incremental backups to recover the database. 。  Apply archived redo logs to recover the database.。 水利水电工程所需材料宜由()负责采购,主要工程设备(如闸门、启闭机、水泵、水轮机、电动机)可由发包人另行组织招标采购。 监理人。 设计人。 发包人。 承包人。 A file system has been corrupted and needs to be restored.  Which file contains the ufsdump levels for this file system? ()  /etc/backup。  /etc/ufsdump。  /etc/dumpdates。  /etc/fsdumpdate。

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.  
On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.  
When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()

参考答案:

  参考解析

本题暂无解析

在线 客服

相关内容

相关标签