单选题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  s

第1题：

nancy used a rich text field on a form to capture data. she would like to display the data in a view. which of the following should she do?（）

• A、use @texttorichtext
• B、use a richtext title field
• C、use the @text（fieldname） in the  column formula
• D、nothing rich text display in the views

第2题：

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.

第3题：

jayne has asked her domino server administrator to enable doc locking on the server. which one of the following must she do to enable it for her application?（）

• A、 enable the “allow doc locking “ db property 
• B、 create a view column for the locked doc view icon 
• C、 add a profile doc to the db to manage the locked doc 
• D、 enable doc locking at the view level for each view in the db

第4题：

Which of the following abilities does a view NOT provide？（）

• A、Change which columns show
• B、Open a view from another database
• C、Contain custom controls
• D、Identify a column to act as a link

第5题：

when eduar tried open the coming attractions view. he got the following error message: incorrect data type for operator or @function: text expected. What did he do to cause this to happen?（）

• A、entered text in a number field
• B、neglected to place a formula in a validation event
• C、neglected to place a formula in a translation event
• D、combined a text field and a time field in formula

第6题：

 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 

第7题：

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

第8题：

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 thr column formula in the view  
• B、 Select currency on the numbers tab in the view properties box 
• C、 Select currency on the numbers tab in the column properties box 
• D、 Select currency on the numbers tab in the field properties box 

第9题：

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

第10题：

Which two statements are true regarding views?（）

• A、A subquery that defines a view cannot include the GROUP BY clause 
• B、A view that is created with the subquery having the DISTINCT keyword can be updated 
• C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
• D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table