Statement对象提供了int executeQuery（String sqlStatement)方法，用于实现对数据库中数据的查询操作，执行后返回值为1。（）

此题为判断题(对，错)。

You are the administrator of SQL server 2000 computer. The server contains a database named MedicalRecords. Users access medical records by using the PatientID field. This field is the clustered primary key for the Patients table. When users try to access medical records, the database responds slowly. You examine the database options as shown in the exhibit.

You want to accelerate query response time and minimize administrative overhead. How should you reconfigure the database?

A．Create a SQL Server Agent job to execute the UPDATE STATISTICS statement, and schedule the job to run weekly.

B．Select the Auto Update Statistics check box.

C．Run the database maintenance plan wizard, and accept the default settings.

D．Rebuild the primary key as a nonclustered primary key.

E．Clear the Auto Create Statistics check box.

EvaluatethefollowingSQLstatementusedtocreatethePRODUCTStable：CREATETABLEproducts（product_idNUMBER（3）PRIMARYKEY，product_descVARCHAR2（25），qtyNUMBER（8，2），rateNUMBER（10，2），total_valueAS（qty*rate））PARTITIONBYRANGE（total_value）（PARTITIONp1VALUESLESSTHAN（100000），PARTITIONp2VALUESLESSTHAN（150000），PARTITIONp3VALUESLESSTHAN（MAXVALUE））COMPRESSFORALLOPERATIONS；Whichstatementistrueregardingthiscommand？（）

A.Itexecutessuccessfullybutpartitionpruningcannothappenforthispartitionkey.

B.ItproducesanerrorbecausetheTOTAL_VALUEcolumncannotbeusedasapartitionkey.

C.ItproducesanerrorbecausecompressioncannotbeusedfortheTOTAL_VALUEpartitionkey.

D.ItexecutessuccessfullybutthevaluesintheTOTAL_VALUEcolumnwouldnotbephysically storedinthepartitions.

A、ExecuteReader

B、ExecuteScalar

C、ExecuteNonQuery

D、EndExecuteReader

?Look at the statements below and the profiles of five executives on the opposite page.

?Which executive (A, B, C, D or E ) does each statement 1-8 refer to?

?For each statement 1-8, mark one letter (A, B, C, D or E ) on your Answer Sheet.

?You will need to use some of these letters more than once.

A Steve Cakebread

When Salesforce. com, the online customer-relations management company went shopping for a CFO last year, it was ramping up to take on the big boys. It found an experienced hand. Steve Cakebread spent 18 years at HP, running divisions around the world; moved to Silicon Graphics as VP for finance, worldwide sales and distribution; and then joined Autodesk as CFO. He says a long resume has real value: "It's all too easy for a new company not to bring in enough experience."

B Mark Angelino

Drawing on his 22 years of sales experience at IBM, Mark Angelino picked a few sectors he wanted to own -- transportation, financial services, manufacturing, and health care —and found sales managers with deep expertise in those industries. Angelino changed the compensation system to reward employees who developed longer-term and more profitable customer relationships. In less than two years, he added ＄1.1 billion in new revenues and almost 2 million new customers, and built Nextel's sales force into the most successful in the telecom industry.

C Adam Bosworth

Bosworth's wisdom accounted for his extraordinary success at Microsoft, where he helped lead the development of Internet Explorer and pioneered XML, the standard language at the heart of Web services and the potential universal translator of data between incompatible systems. "I would like to say that Web services was a great engineering achievement, but it was always about keeping it simple, stupid," he says. "The big challenge was getting people aligned with it." At BEA, he has stoutly defended the technological lead of the company's franchise product, the WebLogic application server, against a concerted assault by IBM's WebSpere.

D Jeff Kay

When he was only 34, Jeff Kay was tapped to run the National Institute of Standards and Technology, the government's biggest civilian R&D program. With an annual budget of nearly ＄1 billion, he bet on promising new technologies like digital video and advanced composites. Now deeply involved in a ＄1 billion venture capital fund, Kay skips from R&D conferences to university research labs to hot startups in pursuit of smart people and their best ideas. Jeff Kay believes that, for an R&D manager "it's critical to get outside your own four walls."

E Angel Mendez

When Mendez arrived at Palm, material costs were rising, margins were shrinking, and the company was smothered by pres of excess inventory. Though he wasn't the first in the tech field to do so, he consolidated nearly all fabrication in China. By tapping suppliers there, Palm was able to cut costs by almost 30 percent. "I have a job where I manage 75 percent of the company's costs," he says. "You literally live and die by your results" Mendez might just live: Palm's gross margins have risen to 31.3% from 29.2% last year.

He realizes the importance of outsourcing gifted people from outside.

A. The plan baselines are verified with the SQL profiles.

B. All fixed plan baselines are converted into nonfixed plan baselines.

C. All the nonaccepted SQL profiles are accepted into the plan baseline.

D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

ViewtheExhibitandexaminethestructureoftheORDERSandORDERJTEMStables.EvaluatethefollowingSQLstatement：SELECToi.order_id，product_jd，order_dateFROMorder_itemsoiJOINordersoUSING（order_id）；WhichstatementistrueregardingtheexecutionofthisSQLstatement？（）

A.ThestatementwouldnotexecutebecausetablealiasesarenotallowedintheJOINclause.

B.ThestatementwouldnotexecutebecausethetablealiasprefixisnotusedintheUSINGclause.

C.ThestatementwouldnotexecutebecauseallthecolumnsintheSELECTclausearenotprefixedwithtablealiases.

D.ThestatementwouldnotexecutebecausethecolumnpartoftheUSINGclausecannothaveaqualifierintheSELECTlist.

to fill an order/to execute an order/to attend to an order/to put an order through

听力原文： Washington

The United States has blocked a UN Security Council statement that was drafted by Arab nations and aimed at putting pressure on Israel to stop military strikes on Palestinian targets. Washington does not have formal veto power when it comes to council statements. But it is able to block the draft single-handedly because council rules require that statements be unanimous and supported by all 15 of its members. Violence and bloodshed in Palestine is getting more serious during the past several months, and the Israeli military is criticized for over-reacting to protests by Palestinian people, causing serious casualties of civilians.

London

Three of the main suspects in a failed attempt to bomb the London transit system made a court appearance in London Monday. Ibrahim, 27, and Mohammed, 23, were charged Sunday. Police suspect Ibrahim of trying to blow up a bus and accuse Mohammed of attempting to bomb a train in the Oval subway station on July 21-one of three trains that were targeted two weeks after similar bombings killed 56 people. They face a maximum sentence of life imprisonment on each charge, if convicted. Ibrahim and Mohammed were arrested in a police raid on a public housing estate in west London on July 29, eight days after knapsack bombs on three trains and the bus failed to detonate.

Beijing

An old tradition in China is changing. In some areas of China, some people often eat wild animals, and this tradition can be traced back a long time ago. However, such a tradition is changing today as most city dwellers interviewed by the latest survey on wild animal consumption said that they have gone off the creatures. Co-sponsored by the China Wildlife Conservation Association and its partner Wild Aid, a non-governmental organization from the United States, the survey found that 54 percent of urban interviewees chose "potential health risks" as the reason for giving up the wild dishes.

Washington

Global finance chiefs have wrapped up three days of talks in Washington DC, calling for action against runaway oil prices. They also urged the IMF to strengthen its monitoring of national currency policies. Finance ministers and central bank governors have backed plans to meet a long- standing demand by emerging market countries for a greater stake in decision-making at the International Monetary Fund. The IMF currently has 184 member countries. Each member country is assigned a quota, based broadly on its relative size in the world economy. A member's quota determines its maximum financial commitment to the IMF and its voting power. Recently, the Board of Governors of the IMF adopted a resolution on quota and voice reform. in the IMF.

Berlin

A German church association and a Chinese foundation have jointly launched a five-million-Yuan program to alleviate iodine deficiency disorders in northwest China. The program is expected to benefit 144,000 newborn babies and women of child-bearing age in eight counties and cities in the Ningxia Hui Autonomous Prefecture of Gansu Province. Lack of iodine stands out to be a serious endemic disease in those areas. It may cause breast and prostate cancer, as well as goiter, or enlargement of the thyroid gland. Scientists have identified iodine deficiency as the most common cause of preventable mental retardation and brain damage in the world.

Questions:

6. According to the news, what is the US response to the military strikes of Israel against Palestine?

7.On what account were Ibrahim and Mohammed charged in London?

8.What is the main finding of the latest survey on wild animal consumption in China?

9.According to the news, which of the following is NOT discussed by global finance chiefs in Washington DC?

10.According to the news,

A．It blocked a UN Security Council statement against Israel.

B．It criticized Israel for over-reacting to protests by Palestinian people.

C．It drafted a statement together with Arab nations.

D．It used its formal veto power to prevent possible condemnation against Israel.