Which of the following are methods to automatically update the antivirus application?（） (Select TWO).A、Establish rules in the email scheduling program to perform updates.B、Select Update Now from the program options.C、Use the Automatic Update feature built

第1题：

A technician finished installing antivirus software. Which of the following should the technician perform NEXT?（）

• A、Run a full scan on the local disk.
• B、Remove infected files.
• C、Update antivirus signatures.
• D、Quarantine infected files

第2题：

Which of the following circumstances would automatically create a system restore point？（）

• A、installation of an unsigned driver
• B、a system crash
• C、installation of an application that uses Windows Installer or installation of Shield Pro version 6.0 or later
• D、installing an update by using the Windows Update or Automatic Updates
• E、each time the system is rebooted

第3题：

Computers on the network are frequently infected with viruses, malware, worms and Trojans.Which of the following should Mike, a technician, update automatically to prevent future problems?（）

• A、Antivirus signatures
• B、Antivirus engines
• C、Malware engines
• D、Virus encyclopedias

第4题：

In which four clauses can a subquery be used? （）

• A、in the INTO clause of an INSERT statement
• B、in the FROM clause of a SELECT statement
• C、in the GROUP BY clause of a SELECT statement
• D、in the WHERE clause of a SELECT statement
• E、in the SET clause of an UPDATE statement
• F、in the VALUES clause of an INSERT statement

第5题：

User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

• A、LOCK TABLE emp IN SHARE MODE；
• B、LOCK TABLE emp IN EXCLUSIVE MODE；
• C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
• D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
• E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

第6题：

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

• A、The command fails because SCOTT still has privileges.
• B、The command succeeds and privileges are revoked from JIM.
• C、The command fails because HR cannot revoke the privileges from JIM.
• D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

第7题：

Your company uses Windows Update to download and install security updates on client computers. When Microsoft releases a security update， you have the following requirements：   Establish which client computers require the security update.   Identify what changes will occur as a result of the security update.  Identify which applications might be affected by the security update.    You need to select the appropriate tool to detect application-compatibility issues.   What should you do？（）

• A、Use the Inventory Collector.
• B、Use the Setup Analysis Tool.
• C、Use the Update Compatibility Evaluator.
• D、Use the Windows Compatibility Evaluator.

第8题：

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 （SP2）. All client computers run Windows XP Professional Service Pack 3 （SP3）.Computer accounts for the client computers are located in three organizational units （OUs） named OU1， OU2， and OU3.  You install Windows Server Update Services （WSUS） 3.0 on a member server named Server1. On Server1， you create three WSUS computer groups named OU1， OU2， and OU3. You need to ensure that each client computer is assigned automatically to the WSUS computer group that corresponds to the OU in which the computer account resides.  Which two actions should you perform？（）

• A、From the Update Services console， configure the Computers options.
• B、From the Update Services console， configure the Automatic Approvals options.
• C、From the Default Domain Policy， configure the Windows Update settings.
• D、Create a new Group Policy object （GPO） for each OU. Configure the Windows Update settings in each GPO.

第9题：

Your network contains a Windows Server Update Services (WSUS) server named Server1. Server1 provides updates to client computers in two sites named Site1 and Site2. A WSUS computer group named Group1 is configured for automatic approval.You need to ensure that new client computers in Site2 are automatically added to Group1. Which two actions should you perform？（）

• A、Create a new automatic approval update rule.
• B、Modify the Computers Options in the Update Services console.
• C、Modify the Automatic Approvals options in the Update Services console.
• D、Configure a Group Policy object (GPO) that enables client-side targeting.

第10题：

第11题：

第12题：

第13题：

SQL Server2005触发器主要针对下列语句创建（）。

• A、SELECT、INSERT、DELETE
• B、INSERT、UPDATE、DELETE
• C、SELECT、UPDATE、INSERT
• D、INSERT、UPDATE、CREATE

第14题：

A server was recently updated with the latest antivirus definitions. Immediately after the update，the server begins to report ‘file not found’ errors for a mission critical application. Which of the following is the MOST likely reason for this？（）

• A、The update was done incorrectly and now the server needs to be restarted.
• B、The update has discovered viruses on the server and removed those virus files.
• C、The update requires a reboot for the files to process correctly.
• D、The update has quarantined files that are false positives.

第15题：

Which of the following is the correct procedure to update the BIOS on LS42 blades without using the AMM?（）

• A、Insert the Update eXpress Service Pack Installer (UXSPI) CD, boot the LS42 blade and follow the prompts 
• B、Boot the blade to the Bootable Media Creator (BoMC) CD and follow the prompts 
• C、Press F1 when the LS42 system is booting, select Update BIOS, insert the diskette into the diskette drive, and select OK 
• D、Use the Remote Supervisor Adapter virtual disk

第16题：

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）

• A、GRANT select, insert, update ON student_grades TO manager
• B、GRANT select, insert, update ON student_grades TO ROLE manager
• C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
• D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
• E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  
• F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

第17题：

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

• A、INSERT 
• B、SELECT 
• C、UPDATE 
• D、DELETE

第18题：

You manage a software update infrastructure by using Windows Server Update Services (WSUS) 3.0. All client computers run Windows XP Professional Service Pack 3 (SP3). The client computers receive Automatic Updates from the WSUS server, and they are configured to install Automatic Updates immediately. From the Update Services console, you approve a required security update for all client computers. You need to force a client computer to apply the required security update as soon as possible. Which tool should you use? （）

• A、Secedit
• B、Wuauclt
• C、Wsusutil
• D、Gpupdate

第19题：

Your network contains a Windows Server Update Services (WSUS) server.You need to ensure that the WSUS server automatically downloads service packs. What should you do first?（）

• A、From the Automatic Approvals options, modify the Update Rules list.
• B、From the Automatic Approvals options, modify the Advanced settings.
• C、From the Products and Classifications options, modify the Products settings.
• D、From the Products and Classifications options, modify the Classifications settings.

第20题：

You have a computer that runs Windows 7. The computer is configured to automatically download andinstall updates. You install Microsoft Office 2007. You need to ensure that service packs for Office areautomatically installed.  What should you do?（）

• A、From Windows Update， select Restore hidden updates.
• B、From Windows Update， select Get updates for other Microsoft products.
• C、Create a folder named Updates in C:///Program Files/Microsoft Office. Install the Office Update InventoryTool into the Updates folder.
• D、Download and install the Office 2007 administrative template and disable the Block updates from theOffice Update Site from applying policy.

第21题：

A technician has fixed a reported issue with a heavily used software program and users have verified that the program is working correctly. Which of the following should the technician do NEXT？（）

• A、Document the process and update the baseline.
• B、Test the theory of probable cause and verify with the software vendor.
• C、Establish a plan of action to be included in the business impact analysis.
• D、Implement the software manufacturer workaround.

第22题：

第23题：