单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming

第1题：

第2题：

第3题：

第4题：

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）

• A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
• B、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
• C、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
• D、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

第5题：

A financial customer has three data centers that are four kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds.  Which solution satisfies the customer’s recovery time objective（）

• A、DS8700 systems at each site running Metro Mirror
• B、DS8700 systems at each site running Global Mirror
• C、DS5300 systems at each site running Global Mirror
• D、XIV systems at each site running Remote Mirroring

第6题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

• A、You cannot roll back this statement.
• B、All pending transactions are committed.
• C、All views based on the DEPT table are deleted.
• D、All indexes based on the DEPT table are dropped.
• E、All data in the table is deleted, and the table structure is also deleted.
• F、All data in the table is deleted, but the structure of the table is retained.
• G、All synonyms based on the DEPT table are deleted.

第7题：

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）

• A、 Create an INSERT trigger to assign the default value to each item in the table. 
• B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
• C、 Create an UPDATE trigger to update the default value for each new item in the table. 
• D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

第8题：

You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. Some client computers run Windows XP Professional, and the rest run Windows NT 4.0 Workstation. TestKing includes departments for accounting, design, marketing, and sales. Each department has a corresponding organizational unit (OU). A member server named Testking1 can be accessed only by user accounts in the Accounting, Design, Marketing, and Sales OUs. You install Terminal Server on Testking1. Then you install four new applications on Testking1. Each application is intended for users in only one of the four departments. You need to ensure that each application can be accessed only by users in the appropriate department. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?（）

• A、In the Default Policy Group Policy object (GPO), configure the Start program on connection policy to be the program path and file name of the application to start when the user logs on.
• B、In each OU, set the Environment property for each user to the program path and file name of the application that corresponds to the OU.
• C、On Testking1, select the RDP-Tcp connection properties. Set the program path and file name of the application to start when the user logs on.
• D、Create one Group Policy object (GPO) for each department. Link each GPO to the corresponding OU. For each GPO, configure the Start program on connection policy to run the application that corresponds to the appropriate department.

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

第16题：

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

• A、REFERENCES
• B、SELECT
• C、UPDATE
• D、ALTER

第17题：

A financial customer has three data centers that are approximately five kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds between the three sites. Which of the following solutions satisfies the customer's recovery time objective?（）

• A、DS8700 systems at each site running Metro Mirror
• B、DS5300 systems at each site running Metro Mirror
• C、DS5100 systems at each site running Global Mirror
• D、XIV systems at each site running synchronous mirroring

第18题：

Evaluate the following statements：   CREATE TABLE purchase_orders （po_id NUMBER（4），  po_date TIMESTAMP， supplier_id NUMBER（6）， po_total NUMBER（8，2），  CONSTRAINT order_pk PRIMARY KEY（po_id）） PARTITION BY RANGE（po_date）  （PARTITION Q1 VALUES LESS THAN （TO_DATE（？1-apr-2007？d-mon-yyyy？）， PARTITION Q2 VALUES LESS THAN  （TO_DATE（？1-jul-2007？d-mon-yyyy？），  PARTITION Q3 VALUES LESS THAN（TO_DATE（？1-oct - 2007？d-mon-yyyy？）， PARTITION Q4 VALUES LESS THAN （TO_DATE（？1-jan-2008？d-mon-yyyy？））；  CREATE TABLE purchase_order_items （po_id NUMBER（4） NOT NULL， product_id NUMBER（6） NOT NULL， unit_price NUMBER（8，2）， quantity NUMBER（8）， CONSTRAINT po_items_fk FOREIGN KEY  （po_id） REFERENCES purchase_orders（po_id）） PARTITION BY REFERENCE（po_items_fk）；   What are the two consequences of the above statements？（）

• A、 Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
• B、 Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. 
• C、 Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
• D、 The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by  automatically duplicating the key columns.
• E、 Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

第19题：

You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）

• A、Ensure that the Close method is called on each connection object after it has finished executing.
• B、Ensure that each connection object is left open after it has finished executing.
• C、Increase the Max Pool Size value inside the connection string.
• D、Increase the Min Pool Size value inside the connection string.
• E、Increase the Connection Lifetime value inside the connection string.
• F、Increase the value of the ConnectionTimeout property of the SqlConnection object.

第20题：

You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend？（）

• A、 Use a separate table for each date.  Delete eachtable when it is one week old.
• B、 Use a separate table for each week.  Delete each table when it is one week old.
• C、 Use a single table， partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.
• D、 Use a single table， partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.

第21题：

第22题：

第23题：