单选题The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level

第1题：

The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）

• A、Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. 
• B、Write server-side subprograms, and call the subprograms from the form application. 
• C、Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

第2题：

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 

• A、the DBNEWID utility
• B、the DBVERIFY utility
• C、the ANALYZE command
• D、the RMAN REPORT command
• E、the RMAN CROSSCHECK command
• F、the CHECK_OBJECT procedure of the DBMS_REPAIR package

第3题：

You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）

• A、functions
• B、packages
• C、procedures
• D、database triggers
• E、anonymous PL/SQL block

第4题：

 You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.  What should you do?（）

• A、 Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. 
• B、 Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. 
• C、 Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. 
• D、 Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

第5题：

TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）

• A、Remove all deterministic function calls from within the view.
• B、Remove all nondeterministic function calls from within the view.
• C、Schema-bind all functions that are called from within the view.
• D、Create the view and specify the WITH CHECK OPTION clause.

第6题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

• A、 Use a subreport.
• B、 Use a bookmark link.
• C、 Use the drilldown functionality.
• D、 Use a drillthrough report link.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）

• A、On the Oracle server. 
• B、Locally in each form module. 
• C、In an attached PL/SQL library 
• D、On your file network server.

第14题：

You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

• A、Before parameter form. 
• B、After parameter form. 
• C、Before report. 
• D、After report.

第15题：

Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?（）

• A、FIND_REPORT_OBJECT 
• B、CANCEL_REPORT_OBJECT 
• C、REPORT_OBJECT_STATUS 
• D、SET_PROPERTY OBJECT_PROPERTY

第16题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

• A、 Remove all deterministic function calls from within the view. 
• B、 Remove all nondeterministic function calls from within the view. 
• C、 Schema-bind all functions that are called from within the view. 
• D、 Create the view and specify the WITH CHECK OPTION clause.

第17题：

 Application developers in your company create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set.  Which permission set should you use? （）

• A、 Default 
• B、 SAFE 
• C、 EXTERNAL_ACCESS 
• D、 UNSAFE

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：