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

第1题：

第2题：

Which of the following is NOT true about XML columns?（）

• A、Data can be retrieved by SQL.
• B、Data can be retrieved by XQuery.
• C、XML columns must be altered to accommodate additional parent and child relationships.
• D、Access to any portion of an XML document can be direct, without reading the whole document.

第3题：

第4题：

 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 

第5题：

lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）

• A、use a defaule formula of 1 
• B、use @elements and add 1 to the total 
• C、use the @count function instead of @elements 
• D、use @texttotime to ensure that all strings arte converted to date-time values 

第6题：

Which two statements are true regarding the USING clause in table joins?（）

• A、It can be used to join a maximum of three tables 
• B、It can be used to restrict the number of columns used in a NATURAL join 
• C、It can be used to access data from tables through equijoins as well as nonequijoins 
• D、It can be used to join tables that have columns with the same name and compatible data types

第7题：

helga is working with a multi-value field that has numeric values in a list. she would like to apply a formula to each item in the list, return the list which one of the following @fuctions can she use to accomplish this with one line of code?（）

• A、@transform  
• B、@Listprocess  
• C、@processlist 
• D、@listevaluate

第8题：

第9题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第10题：

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