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

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.

第2题：

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 

第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 box
• D、 use the @function @decimal to format the value in the field on the form that will display in the view 

第4题：

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

第5题：

Which three statements about subqueries are true? （）

• A、A main query can have more than one subquery.
• B、A subquery can have more than one main query.
• C、The subquery and main query must retrieve data from the same table.
• D、The subquery and main query can retrieve data from different tables.
• E、Only one column or expression can be compared between the subquery and main query.
• F、Multiple columns or expression can be compared between the subquery and main query.

第6题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第7题：

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 

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

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

第16题：

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

第17题：

Which three statements about subqueries are true?（）

• A、A single row subquery can retrieve only one column and one row.
• B、A single row subquery can retrieve only one row but many columns.
• C、A multiple row subquery can retrieve multiple rows and multiple columns.
• D、A multiple row subquery can be compared by using the ">" operator.
• E、A single row subquery can use the IN operator.
• F、A multiple row subquery can use the "=" operator.

第18题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：