单选题You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A It is created as a nondisplay item. B The Lock Record property is set to Yes. C

第1题：

You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）

• A、REF cursor query. 
• B、Stored function. 
• C、From clause query. 
• D、Transactional trigger.

第2题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named named Dworks in the instance. The Dworks table has a table named BillDetails which has a clustered primary key named BillId on the BillId column. The BillDetails table has a single XML column named GoodsDetails. The XML column has an XML index and XML data are stored in this XML column. A new column named GoodsID is added to the BillDetails table. GoodsID must be included in the primary key.  So what action should you perform to achieve this goal？（）  

• A、You should drop the XML index on the table. Modify the primary key. Recreate the XML index 
• B、You should alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option. 
• C、You should move the XML data to a temporary table. Clear the XML data from the original table by setting the GoodsDetails column to NULL. Modify the primary key. Repopulate the ProductSpecs column. 
• D、You should disable the XML index on the GoodsDetails column. Modify the primary key.Enable the XML index on the ProductSpecs column.

第3题：

第4题：

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.

第5题：

Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）

• A、REF 
• B、TABLE 
• C、CLOB 
• D、VARRAY

第6题：

Your company Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform? （）

• A、 Create a nonclustered index on the Comments column. 
• B、 Execute the USE Master Transact-SQL statement. 
• C、 Create a full-text catalog. 
• D、 Create a full-text index on the Comments column.

第7题：

You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

• A、BFILE 
• B、REF column 
• C、Object table 
• D、Column object 
• E、INSTEAD-OF trigger

第8题：

You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）

• A、It is created as a nondisplay item. 
• B、The Lock Record property is set to Yes. 
• C、It cannot be referenced in item level triggers. 
• D、It is placed on the canvas with the highest sequence number.

第9题：

You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

• A、The Query Only property is set to Yes. 
• B、The Conceal Data property is set to Yes. 
• C、The Insert Allowed property is set to Yes. 
• D、The Update Allowed property is set to Yes.

第10题：

he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）

• A、Use the Data Block Wizard and base the relation on a REF pointer. 
• B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
• C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
• D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.