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

第1题：

ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

• A、vector 
• B、database view 
• C、database table 
• D、transactional trigger 
• E、PL/SQL table of records 
• F、multi-dimensional array

第2题：

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.

第3题：

第4题：

The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

• A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
• E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
• F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

第5题：

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

• A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
• E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

第6题：

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.

第7题：

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.

第8题：

You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）

• A、Select the block that contains the data to appear in the pie chart. 
• B、Select the table that contains the data to appear in the pie chart. 
• C、Select the view that contains the data to appear in the pie chart. 
• D、Nothing. The wizard will automatically create the pie chart based on the highlighted data.

第9题：

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

第10题：

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.