OCP 11G认证考试
单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）A Opening the database in RESTRICTED modeB Opening the dat
题目
Opening the database in RESTRICTED mode
Opening the database with the RESETLOGS option
Setting a new DBID for the newly restored database
Restoring the server parameter file (SPFILE) to the new host
相似问题和答案
第1题：
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
A. Reregistering the target database in recovery catalog
B. Transporting the new tablespaces to the recovery catalog database
C. Syncronizing the recovery catalog with the target database control file
D. Performing a fresh backup of the target database to include the new data files in the catalog database
第2题：
Which two statements are true regarding the database in ARCHIVELOG mode？（）
- A、You have to shut down the database to perform the backups.
- B、Archiving information is written to the data files and redo log files.
- C、You can perform complete database backups without closing the database.
- D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
- E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
正确答案:C,E
第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
解析：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 have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
- A、The database would open normally.
- B、The database would not open， and it would stop at mount stage.
- C、The database would open after automatically performing instance recovery.
- D、The database would not open， and you have to perform database recovery to open it.
正确答案:C
第5题：
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）
- A、AFTER CREATE
- B、AFTER SUSPEND
- C、BEFORE CREATE
- D、AFTER TRUNCATE
- E、BEFORE SUSPEND
- F、AFTER INSERT OR DELETE OR DELETE
- G、BEFORE INSERT OR DELETE OR DELETE
正确答案:B
第6题：
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.you are responsible for managing a mailbox server named -ex01 that contains one mailbox database.A Company.com user named kara lang informs you that her mailbox contains a number of corrupted e-mail messages.you are in the process of recovering the e-mail messages of kara lang； however， other e-mail messages in the mailbox database should not be deleted.What should you do？（）
- A、You should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.
- B、You should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Export-Mailbox cmdlet should be run.
- C、You should consider creating a new Mailbox Recovery Database. Then a backup of the database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.
- D、You should consider creating a database availability group （DAG）. Then a backup of the mailbox database file should be restored. Thereafter the Restore-Mailbox cmdlet should be run.
正确答案:C
第7题：
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQL>ALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）
- A、 The log sequence is reset to 0.
- B、 All the online redo logs are deleted.
- C、 All the archived redo logs from a previous incarnation become useless.
- D、 The full database backup taken from a previous incarnation can be used in future.
- E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
正确答案:D
第8题：
A. Opening the database in RESTRICTED mode
B. Opening the database with the RESETLOGS option
C. Setting a new DBID for the newly restored database
D. Restoring the server parameter file (SPFILE) to the new host
第9题：
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）
- A、The backups would be consistent.
- B、The backups would be inconsistent.
- C、The backups would be possible only if the database is running in ARCHIVELOG mode.
- D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
- E、The backups need to be restored and the database has to be recovered in case of a media failure
正确答案:B,C,E
第10题：
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
- A、adding a new user to the database
- B、dropping a user from the database
- C、dropping a table from the database
- D、dropping a data file from a tablespace
- E、adding a new tablespace to the database
正确答案:D,E