微软认证
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_Ge
题目
You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.
However, the existing SQL server computers in your office are configured to use the
SQL_Latin1_General_CP1_CI_AS collation.
You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.
What should you do?
A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.
B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.
C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.
D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.
相似问题和答案
第1题：
. You have a server that runs Windows Server 2003 Service Pack 2 (SP2).You back up the files on the server by using the following schedule:·Full backup every Sunday·Differential backup at 01:00 every Monday to FridayYou want to restore the version of a file stored on the server at the start of the business day on Wednesday. You are unsure when the file was last modified.You need to restore the appropriate version of the file by using the minimum number of tapes.Which backup jobs should you review to locate the correct version of the file? （）
A. the differential backup from Tuesday
B. the differential backup from Wednesday and then the full backup from Sunday
C. the full backup from Sunday
D. the full backup from Sunday and then all other backups
第2题：
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently？（）
- A、 parallel image copy backup
- B、 backup with MAXPIECESIZE configured for the channel
- C、 parallel backup with MAXPIECESIZE configured for the channe
- D、 intrafile parallel backup
正确答案:D
第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 work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
- A、The backup status will be marked expired in RMAN recovery catalog.
- B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
- C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
- D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
- E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
正确答案:C
第5题：
ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）
- A、parallel image copy backup
- B、backup with MAXPIECESIZE configured for the channel
- C、parallel backup with MAXPIECESIZE configured for the channel
- D、intrafile parallel backup
正确答案:D
第6题：
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
第7题：
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
第8题：
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）
A. parallel image copy backup
B. backup with MAXPIECESIZE configured for the channel
C. parallel backup with MAXPIECESIZE configured for the channel
D. intrafile parallel backup
第9题：
You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
- A、restore the tablespace from the backup; there is no need to apply the redo information
- B、restore the full database to recover the data up to the point when you performed the backup
- C、restore the tablespace from the backup， and then perform a recovery using the backup control file
- D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
正确答案:D
第10题：
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You have set the recovery model of DB1 to Full. At 2：00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11：00. When you perform this back up， you must make sure that the overall backup will not be affected. What'；s more， you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence. In the options below， which Transact-SQL statement should you use？（）
- A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn';
- B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL;
- C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD;
- D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY;
正确答案:D