Derek has created a view in the products.nsf database. Derek wants the markup column in the view to display the selling price of the cost. He wants this value to display in currency. Which one of the following should derekl do? （）A、 use the @currenty in t

第1题：

You are the network administrator for The network consists of a single Active Directory domain named The TestKing Staff department has a Windows 2003 computer that functions as a file server. The computer contains a folder named TestKingData. Auditing is enabled on the TestKingData folder. The TestKing Staff department reports that confidential files were deleted from the folder. You need to identify the user who deleted the confidential files. What should you do?（）

• A、In Event Viewer, create a new log view from the security log. Filter the log view to display only success audits.
• B、In Event Viewer, create a new log view from the security log. Filter the log view to display only failure audits.
• C、In Event Viewer, create a new log view from the system log. Filter the log view to display only success audits.
• D、In Event Viewer, create a new log view from the system log. Filter the log view to display only failure audits.

第2题：

An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）

• A、odmget
• B、odmadd
• C、odmshow
• D、odmcreate

第3题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第4题：

Your company’s client computers run Windows 7.   Your company’s network has a wireless access point （WAP）. A user reports that he regularly loses connectivity to the WAP.    You need to display information about client connectivity to the WAP.   What should you do？（）

• A、Use Event Viewer to view events from a source of WlanConn.
• B、Use Event Viewer to view events from a source of WLAN AutoConfig.
• C、Use auditpol.exe to enable failed attempts in the Object Access category.
• D、Use auditpol.exe to enable successful attempts in the Object Access category.

第5题：

tony wants to create a duplicate of the video application. He wants to keep a version of the data on the same server as the production application but does not want any new documents or documents modifications to be replicated into his new database once he creates it. Which one of the following should tony do to create his archive?（）

• A、create a new copy of the database
• B、create a replica of the database
• C、Use the windows explorer to create a copy of the database file.
• D、Create a replica copy of the database and disable replication on the database file.

第6题：

tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）

• A、create a view action that has the following formula：@command（[create]；”video”）
• B、create a form action that has the following formula：@command（[compose]；”video”）
• C、create a view action that has the following formula：@command（[compose]；”video”）
• D、create a database action that has the following formula：@command（[compose]；”video”）

第7题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect. Which action should be performed？（）

• A、A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.
• B、On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.
• C、A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.
• D、On the Price column， a foreign key constraint is created to a table that valid prices are included.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

which one of the following should maria do to display the release date in a text column?（）

• A、used the number and time format options 
• B、used the @date to text functions to convert time to text 
• C、concatenated the date types using mathematical operators 
• D、used the @text functions to convert time and number data to text in text columns 

第14题：

 Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）

• A、 use the @function @decimal in the column formula in the view 
• B、 select decimal on the numbers tab in the view properties box 
• C、 select decimal on the numbers tab in the column properties box
• D、 use the @function @decimal to format the value in the field on the form that will display in the view 

第15题：

A bank wants to maximize the security of employee computer data displayed on their screen.Which of the following would BEST accomplish these goals?（）

• A、Keyboard filters
• B、Privacy filters
• C、Screensavers
• D、Secure display drivers

第16题：

tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）

• A、select the parenthesis when negative value in the view properties box 
• B、select the parenthesis when negative value in the column properties box 
• C、use the @function @negative to set this in the column formula in the view 
• D、use a formula to format the value in the field on the form that will be displaying in the view

第17题：

cindy has created a private agent. she wants her colleagues to be able to use it. which one of the following should she do to achieve this?（）

• A、 change the agent property to shared 
• B、 copy the agent to a domino 6 server 
• C、 change the agent property to shared code 
• D、 delete the agent. She must create it again as a shared agent

第18题：

mary would like to display a collapsed section on her video catalog form, she has created a section buy when she display the form in the client the section always opens expanded. which one of the following should mary do to collapse the section?（）

• A、 nothing. Sections always open expanded 
• B、 modify the section default properties to collapsed 
• C、 modify the form propenties to display all sections collapsed 
• D、 modify the section opened for reading property to auto-collapse 

第19题：

Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named Share A.  You want to respond to the user’s problem as quickly as possible by using an administrative tool. However， you cannot remember the server location of Share A.  What should you do？（）

• A、Use Windows Explorer to display the file paths of your shared folders.
• B、Use Storage in Computer Management to view logical drive properties.
• C、Use Event Viewer in Computer Management to search for shared folder error messages.
• D、Use System Tools in Computer Management to display the file paths of your shared folders.

第20题：

第21题：

第22题：

第23题：