单选题A UDT is a data type which:（）A must contain unique values.B cannot be CAST to other data types.C is created using the CREATE DISTINCT command.D contains a value that was automatically calculated from values in other columns.

第1题：

Your web application uses a simple architecture in which servlets handle requests and then forward to aJSP using a request dispatcher. You need to pass information calculated by the servlet to the JSP；furthermore， that JSP uses a custom tag and must also process this information. This information mustNOT be accessible to any other servlet， JSP or session in the webapp. How can you accomplish this goal？（）

• A、Store the data in a public instance variable in the servlet.
• B、Add an attribute to the request object before using the request dispatcher.
• C、Add an attribute to the context object before using the request dispatcher.
• D、This CANNOT be done as the tag handler has no means to extract this data.

第2题：

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 found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）

• A、database table 
• B、transactional trigger 
• C、stored procedure 
• D、FROM clause query 
• E、client-side procedure

第3题：

The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）

• A、Column definitions cannot be altered to add DEFAULT values.
• B、A change to the DEFAULT value affects only subsequent insertions to the table.
• C、Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
• D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

第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题：

Which two statements regarding a SQL profile are true？（）

• A、 It is built by Automatic Tuning Optimizer.
• B、 It cannot be stored persistently in the data dictionary.
• C、 It can be used by the query optimizer automatically.
• D、 It can be created manually by using the CREATE PROFILE command.

第6题：

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

• A、The tablespace has two data files.
• B、An error is reported and tablespace creation fails.
• C、Data files are created with names generated by the instance.
• D、The tablespace can be extended without specifying the data file.
• E、Data files belonging to the USERS tablespace cannot be renamed.

第7题：

You design a Business Intelligence （BI） solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）

• A、 Filter data by using expressions.
• B、 Specify the default values for each parameter.
• C、 Create an available values list for each parameter.
• D、 Create report parameters by using query parameters to filter data at the data source.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

A UDT is a data type which:（）

• A、must contain unique values.
• B、cannot be CAST to other data types.
• C、is created using the CREATE DISTINCT command.
• D、contains a value that was automatically calculated from values in other columns.

第15题：

In which case would you use a FULL OUTER JOIN?（）

• A、Both tables have NULL values.
• B、You want all unmatched data from one table.
• C、You want all matched data from both tables.
• D、You want all unmatched data from both tables.
• E、One of the tables has more data than the other.
• F、You want all matched and unmatched data from only one table.

第16题：

Which two statements are true about a bitmap index？ （）

• A、It is recommended for the columns that have unique values.
• B、It can be converted to a B-tree index by using the ALTER INDEX command.
• C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
• D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

第17题：

In which two scenarios do you use SQL* Loader to load data?（）

• A、Transform the data while it is being loaded into the database.
• B、Use transparent parallel processing without having to split the external data first.
• C、Load data into multiple tables during the same load statement.
• D、Generate unique sequential key values in specified columns.

第18题：

The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）

• A、Column definitions cannot be altered to add DEFAULT values.
• B、A change to the DEFAULT value affects only subsequent insertions to the table.
• C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
• D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

第19题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup. You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content.  The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do？ （）

• A、 Modify the content type of Markup as Continuous.
• B、 Create a data mining dimension in the SSAS database from OrderDetails.
• C、 Create a data profile by using SQL Server 2008 Integration Services （SSIS）.
• D、 Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.

第20题：

第21题：

第22题：

第23题：

第24题：