While selecting files during an interactive restore with ufsrestore， you are interrupted by a junior  administrator before you can complete the file selection process and start the restore. After answering the administrator’s question， you realize that y

第1题：

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

第2题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第3题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

• A、 You must ensure that the SALES database is mounted or open.
• B、 You must restore a backup control file to perform a block media recovery.
• C、 You must take the tools01.dbf data file offline before you start a block media recovery.
• D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

第4题：

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

• A、Start the instance and open the database, instance recovery automatically recovers control files 
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
• C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
• D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
• E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第5题：

You are the desktop administrator for your company. Laura is a user in the company's accounting department. Laura uses a Windows XP Professional computer. Laura installs a new software application that was listed on her Add or Remove Programs list. Laura reports that the new application now opens whenever she double-clicks any file that has a .doc file name extension. She also reports that 24 new icons appear on the New menu when she right-clicks her desktop. Laura asks you to reconfigure her computer so that Microsoft Word opens when she double-clicks files that have a .doc file name extension. She also wants you to remove the new icons from the New menu. You instruct Laura to uninstall the new application. After she uninstalls the application, she reports that she can no longer open .doc files by double-clicking them. She also reports that the unwanted icons on the New menu are still present. You reinstall the new application, and it continues to open when Laura double-clicks .doc files. You want to restore the .doc file association and to remove the unwanted icons from the New menu on Laura's computer. You want to accomplish these tasks as quickly as possible. You also want to ensure that none of Laura's other documents or personal settings are affected. What should you do?（）

• A、Restore the computer to the restore point that was created when Laura installed the new application.
• B、Restore the System State data to Laura's computer from a backup tape. 
• C、Use the Windows XP Professional CD-ROM to perform an Automated System Recovery (ASR) restore. 
• D、Restart the computer by using the last known good configuration. 

第6题：

You are the network administrator for You administer a Windows Server 2003 computer named TestKing2. User profiles are stored on TestKing2. A user named Sandra reports that she accidentally deleted a folder named TestKingStuff from her user profile. She needs to have her TestKingStuff folder restored. Other users are accessing TestKing2, and you do not want to negatively affect their work. You locate the latest backup that contains the files that you need to restore. You need to restore Sandra's TestKingStuff folder. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）

• A、Restore Sandra's TestKingStuff folder, and clear the Restore junction points, but not the folders and the file data they reference check box.
• B、Restore the Documents and Settings folder that contains the TestKingStuff folder.
• C、Restore Sandra's TestKingStuff folder, and choose an alternate location for the restoration.
• D、Restore Sandra's TestKingStuff folder, and choose the original location for the restoration.

第7题：

You are a network administrator for You manage a Windows Server 2003 computer named Testking1. Folder Redirection is enabled for the users' My Documents folders. A user named Peter deletes all the files and folders in his My Documents folder before he leaves TestKing. Peter's manager asks you to recover documents. You do not know if Peter made modifications to the permissions on the files. You need to restore Peter's My Documents folder so that his manager can access the files. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）

• A、Perform a default restoration.
• B、Run the Automated System Recover (ASR) wizard.
• C、Perform a restoration, and enable the Restore security option.
• D、Perform a restoration, and disable the Restore security option

第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 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? （） 

• A、You should configure a certificate 
• B、You should configure the SQL Server Agent service to use the NetworkService account.
• C、You should configure the job step to use a proxy account 
• D、You should configure the SQL Server Agent service to use a local Windows account

第9题：

You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.  What should you do？（）

• A、Create a System Restore point.
• B、Perform an Automated System Recovery （ASR） backup and restore.
• C、In the Backup and Restore Center window， click the Back up files button.
• D、In the Backup and Restore Center window， click the Back up computer button.

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

• A、Start the instance and open the database， instance recovery automatically recoverscontrol files
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
• C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
• D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
• E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第14题：

John, a junior workflow developer, has approached you for advice on a workflow process that he is defining. He is unclear about the implications of selecting the Runnable checkbox while defining the Process Activity. What advice would you offer?（）

• A、Runnable allows the workflow engine to compile the process.
• B、Runnable allows the process to be included as a stand-alone subprocess.
• C、Runnable allows the workflow engine to check its status during process execution.
• D、Runnable allows the workflow engine to define this as a top-level process and initiate it

第15题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第16题：

You are performing a Weekly backup and you want to be sure that you backup everything including the registry， boot files， and COM. How can you do this with the least amount of administrative effort？（）

• A、Configure the backup to backup the system state area.
• B、Configure the backup to backup the system partition.
• C、Create a batch file to run RDISK.EXE /s-before backup starts.
• D、Create a batch file to run RDISK.EXE /s- after backup is started.

第17题：

You are a network administrator for ExamSheet.net's Windows 2000 network.  Your computer is installed with Windows 2000 Professional. You schedule a task that will copy files from your computer to another computer on the network. You notice that the task is not completing correctly. You manually copy the files from your computer to other computers on the network without any errors. You verify that all of your other tasks are working correctly. You want the task to complete successfully.  What should you do? （）

• A、Start the Remote Procedure Call （RPC） Locater service and configure the service to start automatically.
• B、Start the RunAs service and configure the service to start automatically.
• C、Configure the Task Scheduler service account to use the local Administrator account and password. Restart the service.
• D、Use Scheduled Tasks to configure the task to run under the security context of your account.

第18题：

You are the network administrator for The network consists of a single Active Directory domain named A member server named TestKingA runs Windows Server 2003. You need to use the Backup utility to back up all data on TestKingA three times per day. Files that are currently opened by applications must not be backed up. What should you do?（）

• A、Run a differential backup.
• B、. Disable volume shadow copies.
• C、Select the Exclude Files option.
• D、Select the Compute selection information before backup and restore operations option

第19题：

You are the network administrator for You administer a Windows Server 2003 computer named TestKing2. contains a shared folder named TestKingProjects. You use the Backup utility once each day to back up the TestKingProjects folder. You discover that a database file in the TestKingProjects folder is corrupt. You confirm that the file corruption is not the result of a virus. You need to replace the corrupted file by using the latest backup. You do not know whether the file was corrupted before or after the latest backup was completed. You need to verify that the file in the backup can be opened successfully before you overwrite the existing file. What should you do?（）

• A、In the Backup utility, select the Verify data after backup option.
• B、Run the Ntbackup //TestKing2/TestKingProjects /v:yes command.
• C、Restore the file to a temporary folder. Verify that the database file contains the correct data. Copy the restored file to the TestKingProjects folder.
• D、Restore the file to a temporary folder. Use the Windiff utility to compare the file in the temporary folder to the file in the TestKingProjects folder. Copy the restored file to the TestKingProjects folder.

第20题：

You are the desktop administrator for your company. All client computers run Windows XP Professional. Currently, 10 of the computers in the graphics department contain two processors. You want to install a second processor in each of the remaining computers in the graphics department. You install a second processor in a test computer. When you start the computer, the start process begins normally and then terminates. You receive the following error message: "STOP: 0x00000079 HAL_MISMATCH." When you restart the computer, it stops again, and you receive the same error message. You remove the second processor, and the computer starts normally. When you attempt to install a second processor in a different test computer, the same STOP error occurs. You need to eliminate the error so that you can install the second processor on all of the computers. What should you do?（） 

• A、Before you install the second processor, install the multiprocessor HAL on each computer. 
• B、Before you install the second processor, configure the each computer's system BIOS for multiprocessor APM.
• C、After you install the second processor, restart each computer by using the Recovery console, and copy the multiprocessor HAL files from the Windows XP Professional CD-ROM. 
• D、After you install the second processor, start each computer in safe mode. Configure the SSDP Discovery Service startup parameter to Manual.

第21题：

第22题：

第23题：