You define the following regular expression of currency values:regex tx = new regex("^-?\d+(\.\d{2})?$")You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are als

第1题：

第2题：

How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）

• A、CALL getratews11('USA','CANADA')
• B、CALL expenses.getratews11('USA','CANADA')
• C、SELECT getratews11('USA','CANADA') FROM expenses
• D、SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency

第3题：

11. String test = “Test A. Test B. Test C.”；  12. // insert code here  13. String[] result = test.split（regex）；  Which regular expression inserted at line 12 will correctly split test into “Test A，” “Test B，” and “Test C”？（）

• A、 String regex = “”；
• B、 String regex = “ “；
• C、 String regex = “.*“.
• D、 String regex = “//s”
• E、 String regex = “//.//s*”；
• F、 String regex = “//w[ /.] +“；

第4题：

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

• A、Coalesce the application tables at a regular interval.
• B、Export and Import the application tables a regular interval.
• C、Drop and recreate the application tables at a regular interval.
• D、Move the application tables to a tablespace with less space usage.
• E、Distribute the application tables across multiple tablespaces depending on usage.
• F、Move the application tables to automatic segment space management tablespace.

第5题：

You are creating a DataTable. You use the following code segment to create the DataTable. (Line numbers are included for reference only.) 01 Dim dt As New DataTable("Products") 02 dt.Columns.Add(New DataColumn("Price", _ GetType(Decimal))) 03 dt.Columns.Add(New DataColumn("Quantity", _ GetType(Int32))) 04 Dim dc As DataColumn = New DataColumn("Total", _ GetType(Decimal)) 05 dt.Columns.Add(dc) You need to ensure that the Total column is set to the value of the Price column multiplied by the Quantity column when new rows are added or changed. What should you do? （）

• A、Add the following code segment after line 05. dc.ExtendedProperties("Total") = "Price * Quantity"
• B、Add the following code segment after line 05. dc.Expression = "Price * Quantity"
• C、Write an event handler for the DataTable's TableNewRow event that updates the row's Total.
• D、Write an event handler for the DataTable's ColumnChanged event that updates the row's Total.

第6题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as an application developer at Certkiller .com. Certkiller .com wants you to develop an application that stores and retrieves client information by means of a unique account number.You create a custom collection class， which implements the IDictionary interface，named ClientDictionary. The following code have been included into the new application. //Create Client objects Client c1 = new Client （"AReid"， "Andy Reid"， Status.Current）； Client c2 = new Client （"DAustin"， "Dean Austin"， Status.New）； //Create ClientDictionary object IDictionary cData = new ClientDictionary （）； cData.Add （"10001"， c1）； cData.Add （"10002"， c2）； You use the same method to add other Client objects to the collection. You need to ensure that you are able to retrieve client information associated with the account number 10111.What should you do？（）

• A、 Use the following code： Client foundClient；foundClient = （Client） cData.Find （"10111"）； 
• B、 Use the following code： Client foundClient；if （cData.Contains （"10111"）） foundClient = cData ["10111"]； 
• C、 Use the following code： Client foundClient；if （cData.Contains （"10111"））foundClient =（Client） cData ["10111"]； 
• D、 Use the following code： Client foundClient；foreach （string key in cData.Keys {if （key == "10111"）foundClient = （Client） cData.Values ["10111"]； }

第14题：

Through which action are Currency Codes created？  （）

• A、 select New Row in Currency Codes application
• B、 select Action Currency Codes in the Database Configuration application
• C、 select an Organization in the Currency Codes application and add a new row
• D、 select the Base Currency lookup in the Organizations application and add a new row

第15题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第16题：

Given： 11.String test = "Test A. Test B. Test C."； 12.// insert code here 13.String[] result = test.split（regex）； Which regular expression， inserted at line 12，correctly splits test into "Test A"，"Test B"，and "Test C"？（）

• A、String regex = ""；
• B、String regex = " "；
• C、String regex = ".*"；
• D、String regex = "//s"；
• E、String regex = "//.//s*"；

第17题：

You define the following regular expression of currency values: regex tx = new regex("^-?/d+(/./d{2})?$") You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are also required to use this code as the expression in a conditional statement and need to know which code segment to use. What should you do?（）

• A、The tx.Matches（Bill）
• B、The tx.Equals（Bill）
• C、The tx.Match（Bill）
• D、The tx.IsMatch（Bill）

第18题：

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 Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

• A、A new partition function should be created 
• B、You should change the existing partition scheme 
• C、You should use a Merge clause to change the existing partition function 
• D、You should use a Split clause to change the existing partition function 

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：