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

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


参考解析

解析: 暂无解析

相关考题:

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

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

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

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

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.

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

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 fieldB、neglected to place a formula in a validation eventC、neglected to place a formula in a translation eventD、combined a text field and a time field in formula

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

Which of the following abilities does a view NOT provide?()A、Change which columns showB、Open a view from another databaseC、Contain custom controlsD、Identify a column to act as a link

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

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.

Which two statements about creating constraints are true? ()A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

Which two statements about creating constraints are true?()A、Constraint names must start with SYS_CB、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.

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

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

单选题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?()AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate 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.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.

单选题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?()Aentered text in a number fieldBneglected to place a formula in a validation eventCneglected to place a formula in a translation eventDcombined a text field and a time field in formula

单选题Which of the following abilities does a view NOT provide?()AChange which columns showBOpen a view from another databaseCContain custom controlsDIdentify a column to act as a link

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

单选题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?()Acreate a view action that has the following formula:@command([create];”video”)Bcreate a form action that has the following formula:@command([compose];”video”)Ccreate a view action that has the following formula:@command([compose];”video”)Dcreate a database action that has the following formula:@command([compose];”video”)

单选题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?()Ause @texttorichtextBuse a richtext title fieldCuse the @text(fieldname) in the  column formulaDnothing rich text display in the views

多选题Which two statements about views are true?()AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.

多选题Which two statements about creating constraints are true?()AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view

单选题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?()Aselect the parenthesis when negative value in the view properties box Bselect the parenthesis when negative value in the column properties box Cuse the @function @negative to set this in the column formula in the view Duse a formula to format the value in the field on the form that will be displaying in the view

单选题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?()ADefine 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.BDefine the new column as NOT NULL with a default value of ’Undefined.’CDefine the new column as NULL. Use application logic to enforce the data constraint.DDefine the new column as NULL with a default value of ’Undefined.’

多选题Which two statements are true regarding views?()AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA 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

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