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

第1题：

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

第2题：

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

第3题：

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）.

第4题：

You work in a company which 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 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）  

• A、You should implement Differential backup 
• B、You should implement Database snapshots
• C、You should implement Primary filegroup backup 
• D、You should implement Transaction log backup

第5题：

. 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 Friday You 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

第6题：

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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） 

• A、You should backup the master database
• B、You should backup the default.trc file
• C、You should backup the SQL Server registry hive.
• D、You should backup the resource database 

第7题：

You work in a company which 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. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least.  So what action should you perform to achieve this goal?（）  

• A、You should restore the full backup 
• B、You should restore the database snapshot from 16:30 hours. 
• C、You should restore the database snapshot from 17:30 hours 
• D、You should restore both the full backup and the differential backup. 

第8题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover.  What should you do? （） 

• A、The contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS) 
• B、You should restore a backup to the active node 
• C、You should get rid of the shared array from the active node 
• D、From the active node, you have to uplug the network cable(s)

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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; 

第16题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1.  In the options below, which Transact-SQL statement should you use? （）  

• A、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak'; 
• B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION; 
• C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 
• D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION,DIFFERENTIAL;

第17题：

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. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

• A、You should use database snapshots 
• B、You should use database backup and restore 
• C、You should use database backup and restore along with compression 
• D、You should use schema-bound views in a read-only database. The database resides on the same instance.

第18题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up？（）

• A、DATA
• B、INSTALL 
• C、LOG 
• D、BINN

第19题：

Your network consists of a single Active Directory domain. You have a server named Server1. Server1 has only one hard disk drive. You run a full backup at 02:00 every Monday. You run an incremental backup at 02:00 every Tuesday to Sunday. You run an Automated System Recovery (ASR) backup every day at 13:00. Server1’s hard disk drive fails on Wednesday at 15:00. You need to recover Server1 to its latest configuration by using the minimum amount of administrative effort. What should you restore? （）

• A、Monday’s full backup, then Tuesday’s incremental backup, and then Wednesday’s incremental backup
• B、Monday’s full backup and then Wednesday’s ASR backup
• C、Monday’s full backup and then Wednesday’s incremental backup
• D、Wednesday’s ASR backup

第20题：

第21题：

第22题：

第23题：