单选题You need to create a partitioned table to store historical data and you issued the following command：   CREATE TABLE purchase_interval PARTITION BY RANGE （time_id） INTERVAL （NUMTOYMINTERVAL（1，’month’）） STORE IN （tbs1，tbs2，tbs3） （ PARTITION p1 VALUES LE

第1题：

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.

第2题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

• A、The tablespace TBS1 is full.
• B、The user is not the owner of the SYSTEM tablespace.
• C、The user does not have quota on the TBS1 tablespace.
• D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• E、The user does not have sufficient privileges to create table on the default permanent tablespace.

第3题：

The INV_HISTORY table is created using the command：   SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0  values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））；   The following data has been inserted into the INV_HISTORY table ：   INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000   You would like to store the data belonging to the year 2006 in a single partition and issue the command：   SQL> ALTER TABLE inv_history MERGE PARTITIONS  FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py；  What would be the outcome of this command？（）

• A、 It executes successfully，and the transition point is set to ’1-apr-2006’.
• B、 It executes successfully，and the transition point is set to ’15-apr-2006’.
• C、 It produces an error because the partitions specified for merging are not adjacent.
• D、 It produces an error because the date values specified in the merge do not match the date values stored in the table.

第4题：

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

• A、 create a hash cluster to store the data
• B、 create an index cluster to store the data
• C、 create a partitioned table to store the data
• D、 create a sorted hash cluster to store the data
• E、 create a heap table with rowid to store the data

第5题：

An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

• A、 Use a single partition key for the table.
• B、 Compress data before storing it in the table.
• C、 Create additional partition keys for the table.
• D、 Continually remove unnecessary data from the table.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

• A、 Set DYNAMIC_SAMPLING to level 4
• B、 Set the STATISTICS_LEVEL parameter to BASIC
• C、 Set the INCREMENTAL value to TRUE for the partition table
• D、 Increase the value of STALE_PERCENT for the partition table

第14题：

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

• A、A syntax error will result as you cannot specify more than one partition in the same statement
• B、All data in p1 and p3 partitions are removed and the table definition is changed
• C、All data in p1 and p3 partitions are removed, but the table definition remains unchanged
• D、Only the first partition (p1) will be dropped as only one can be dropped at any time

第15题：

Evaluate the following SQL statement used to create the PRODUCTS table：   CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value） （PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN  （150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））  COMPRESS FOR ALL OPERATIONS；   Which statement is true regarding this command？（）  

• A、 It executes successfully but partition pruning cannot happen for this partition key.
• B、 It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
• C、 It produces an error because compression cannot be used for the TOTAL_VALUE partition key. 
• D、 It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

第16题：

 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.

第17题：

You are the network administrator for . Your network includes a computer named TestKingSrv1, which runs Windows Server 2003 and Windows XPProfessional in a dual boot configuration. TestKingSrv1 has two basic disks, which are configured as shown in the following table. You need to create a 10 GB partition on Server 1 to store user data. TestKingSrv1 must retain its dual boot functionality. What should you do?（）

• A、Convert both disks to dynamic disks. Create a 10 GB extended volume by using the unused space on Disk 1 and Disk 2.
• B、Back up Partition 2 on Disk2. Remove Partition 2 from Disk 2 and restore it on Disk 1 by using the unused space on Disk 1. Create a 10 GB partition on Disk 2
• C、Back up partition 2 on Disk 1. Remove Partition 2 from Disk 1 and restore it on Disk 2 by using the unused space on Disk 2. Create a 10 GB partition on Disk 1.
• D、Convert both disks to dynamic disks. Back up Volume 2 on Disk 2. Remove Volume 2 from Disk 2 and restore it on Disk 1 by using the unused space on Disk 1. Create a 10 GB volume on Disk 2.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：