单选题Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）A SRW.BREAK B SRW.SET_ALTER C SRW.REFERENCE D SRW.DO_SQL E SRW.RUN_REPORTF SRW.SET_FIELD

第1题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第2题：

Which of the following are types of routine objects?（）

• A、Package and function
• B、Function and userexit
• C、Procedure and package
• D、Function and procedure

第3题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

• A、UPDATE TABLE
• B、CREATE CLUSTER
• C、TRUNCATE TABLE
• D、ALTER TABLE MOVE
• E、INSERT INTO···VALUES
• F、ALTER TABLE···DROP COLUMN
• G、ALTER TABLE···DROP PARTITION

第4题：

36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第5题：

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.

第6题：

You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

• A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
• B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
• C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
• D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

第14题：

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 programme unit to store the function?（）

• A、Programme units. 
• B、PL/SQL libraries. 
• C、Database object. 
• D、Built in packages.

第15题：

You executed this command to create a temporary table：  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS；  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction （）

• A、The rows stay in the table only until session termination.
• B、The rows stay in the table only until the next transaction starts on the table.
• C、The rows are visible to all current sessions after the transaction is committed.
• D、The rows stay available for subsequent sessions after the transaction is committed

第16题：

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

第17题：

Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table.  Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）

• A、Grand privileges on the interim table.
• B、Invoke the dbms_redefinition.can_redef_table procedure.
• C、Invoke the dbms_redefinition.sync_interim_table procedure.
• D、Create any triggers， indexes， or constraints on the interim table.
• E、Create an empty interim table with all the desired characteristics.

第18题：

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 DB1 in the instance. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.)  01 CREATE PROCEDURE Sales.Procedure1  02 AS  03 IF OBJECT_ID('Service.Table') IS NOT NULL  04 DROP TABLE Service.Table;  06 CREATE TABLE Service.Table (  07 Id int PRIMARY KEY CLUSTERED,  08 Name varchar(100);  09 );  11 ...  12  GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions.  What action should you do perform?（）  

• A、Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. 
• B、Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. 
• C、You should give the user the ALTER permission on the Service schema 
• D、You should give the CREATE TABLE permission and permit the user to drop the Service.Table table. 

第19题：

第20题：

第21题：

第22题：

第23题：