违法和不良信息举报 联系客服
免费注册 登录

Where can you obtain information about full database backup 

题目
单选题
Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）
A

V$BACKUPSET

B

RC_DATABASE

C

V$BACKUP_SET

D

RC_BACKUP_SET

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案：A, D

第2题：

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？（）

  • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
  • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
  • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
  • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

正确答案:C

第3题：

You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.

A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

You want to ensure that the journalists can query the database. What should you do?

A．Create a new full-text catalog for the Articles database

B．Rebuild the full-text catalog for the Articles database

C．Create a new full-text index on the table that holds the text for the articles

D．Repopulate the full-text index on the table that holds the text for the articles


正确答案：D
解析：Explanation: Backing up a database does not back up full-text index data in full-text catalogs. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. However, if full-text indexes have been defined for tables, the metadata for the full-text index definitions are stored in the system tables in the database containing the full-text indexes. After a database backup is restored, the full-text index catalogs can be re-created and repopulated.

Note 1:
Setting up a full-text search is a three-step procedure:

1. Make sure that the full-text indexing feature has been installed with your SQL Server.
The full-text index is installed as a service in the system. It would not have to be reinstalled after restoring a database.

2. Create a catalog in the operating system to store the full-text indexes.
A catalog can contain the indexes from one or more tables, and it is treated as a unit for maintenance purposes. In general, you shouldn't need more than one catalog per database.
The catalog is saved outside the database on separate files

3. Before you can implement a full-text search in a given database, you must ensure that the full-text search indexes are populated regularly.
In this scenario we must recreate the index by repopulating the full-text catalog.

Note 2: A SQL Server 2000 full-text index provides support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. The full-text indexes are contained in full-text catalogs. Full-text catalogs and indexes are not stored in the database to which they belong. The catalogs and indexes are managed separately by the Microsoft Search service. Backing up a database does not back up full-text index data in full-text catalogs. However, if full-text indexes have been defined for tables, the meta. data is backed up when a database backup is created.

Incorrect Answers:
A: The catalog already exists. The catalog is stored outside SQL server and would not be affected by the failure and restoration of the database.

B: Rebuildning the full text catalog will not enable the Journalist to run the full-text queries. The catalogs would have to be repopulated as well.

C: The index should be repopulated since it already exists from the backup. There is no need to recreate it.

第4题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  • A、 online redo log files
  • B、 alert log files
  • C、 control file
  • D、 datafiles associated with the SYSTEM tablespace

正确答案:C

第5题：

Which of the following are correct about block media recovery？（）

  • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
  • B、 Logical corruptions are repairable by BMR
  • C、 Physical corruptions are repairable by BMR
  • D、 RMAN can use any backup for a BMR restore
  • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

正确答案:A,C

第6题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

  • A、To store the backup information of multiple database
  • B、To restrict the amount of space that is used by the backups
  • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
  • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

正确答案:A,D

第7题：

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  • A、 V$BACKUP_CORRUPTION
  • B、 V$COPY_CORRUPTION
  • C、 V$DATABASE_BLOCK_CORRUPTION
  • D、 RC_BACKUP_CORRUPTION

正确答案:C

第8题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案：A, D

第9题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第10题：

You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

  • A、Information about each Oracle Net connection.
  • B、Information about each entry in theLinstener.orafile
  • C、Information about the changed done in the database
  • D、Information about the different listeners in your system
  • E、Information about all thenondatabasefiles required to operate the database

正确答案:A

更多相关问题
相关内容