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

第1题：

Write a memo in about 50 words. You are Human Resources Manager. Your company is going to provide the staff with training in E-Commerce. There will be two course levels: intermediate level and advanced level. The training course will be given on Saturdays for five weeks. Write a memo to department managers: ·Informing them of the coming training course; ·Asking them to encourage the staff to participate; ·Asking them to help obtain the names of the interested staff.
To: Department Managers
From: (your name)
Subject: E-Commerce Training Course
Date: April 18, 2013
From March 20 an E-Commerce course will be held on Saturdays for five weeks. There will be 2 groups: intermediate level and advanced level. Please encourage your staff to attend the training course and send me the names of all interested staff by next Friday. These staff will take a test the week before the training course starts.
略

第2题：

Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）

• A、12; only top-level statements and stored procedure events are logged
• B、111; top-level statements and all lower-level statements are logged
• C、3; only the top-level statements are logged
• D、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event

第3题：

第4题：

You work in a company which is named Wiikigo Corp. The company 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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

• A、You should configure the database for Read Committed Snapshot isolation. 
• B、You should modify the stored procedure to use the Snapshot isolation level 
• C、You should configure the database for Auto Update Statistics asynchronously 
• D、You should modify the stored procedure to use the Repeatable Read isolation level

第5题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

• A、The sp_executesql batches are not being recovered from the procedure cache.
• B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
• C、One new stored procedure is created by a database administrator.
• D、Ad hoc batches are not being recovered from the procedure cache.

第6题：

从水面到甲板之间的高度称之为干舷。（）

• A、The height from the bottom of a vessel to the weather deck is called freeboard.
• B、The depth from water level to the bottom of a vessel is called freeboard.
• C、The length from the bow to stern of a vessel is called freeboard.
• D、The height from water level to the main deck is called freeboard.

第7题：

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.

第8题：

第9题：

You work in a company which is named Wiikigo Corp. The company 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. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（）  

• A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. 
• B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. 
• C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header 
• D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

第10题：