单选题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?（）Ause the @function @decimal in the column formula in the view Bselec

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

相似考题

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

2.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 @texttorichtextB、use a richtext title fieldC、use the @text（fieldname） in the  column formulaD、nothing rich text display in the views

3. 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 boxD、 use the @function @decimal to format the value in the field on the form that will display in the view 

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

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题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题：

    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.

    正确答案:B

  • 第2题：

    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

    正确答案:D

  • 第3题：

    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

    正确答案:C

  • 第4题：

    Which two statements about views are true?（）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第5题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level.
    • C、Constraints can be created after the table is created.
    • D、Constraints can be created at the same time the table is created.
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

    正确答案:C,D

  • 第6题：

    which one of the following best describes the use of hidden column formula?（）

    • A、views can be hidden based on a formula 
    • B、hidden columns are not a supported feature 
    • C、table columns can be hidden based on a formula  
    • D、view columns can be displayed or hidden based on a formula 

    正确答案:D

  • 第7题：

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


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


    正确答案： D,E
    解析： 暂无解析

  • 第11题：

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


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    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


    正确答案： D,B
    解析： 暂无解析

  • 第13题：

    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

    正确答案:B

  • 第14题：

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

    正确答案:C

  • 第15题：

    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

    正确答案:C,D

  • 第16题：

    Which two statements about creating constraints are true? （）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level
    • C、Constraints can be created after the table is created
    • D、Constraints can be created at the same time the table is created
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

    正确答案:C,D

  • 第17题：

    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

    • A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
    • B、Define the new column as NOT NULL with a default value of ’Undefined.’
    • C、Define the new column as NULL. Use application logic to enforce the data constraint.
    • D、Define the new column as NULL with a default value of ’Undefined.’

    正确答案:B

  • 第18题：

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


    正确答案： B
    解析： 暂无解析

  • 第19题：

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


    正确答案： A
    解析： 暂无解析

  • 第20题：

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


    正确答案： C
    解析： 暂无解析

  • 第21题：

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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level

    C

    Constraints can be created after the table is created

    D

    Constraints can be created at the same time the table is created

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view


    正确答案： C,D
    解析： 暂无解析

  • 第23题：

    单选题
    You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）
    A

    Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.

    B

    Define the new column as NOT NULL with a default value of ’Undefined.’

    C

    Define the new column as NULL. Use application logic to enforce the data constraint.

    D

    Define the new column as NULL with a default value of ’Undefined.’


    正确答案： D
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容