有SQL语句： UPDATE examiner SET ersalary=ersalary*1.05 WHERE erdepa='信息学院'AND ersalary＜（select avg（ersalary） from examiner）； 其执行结果是为工资低于信息学院平均工资的所有考官加薪5%。＞

YouareworkingasaDBAatNetFxCorporation.Auser，Scott，ismaintainingtherecordsofalltheemployeesintheEMPLOYEEtable.Initially，thesalaryoftheemployee，’E0025’，was$1800.On1May2004，thesalaryoftheemployee，’E0025’，wasincreasedby$200.

Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’：

SQL>UPDATEEMPLOYEESETSALARY=2000

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnDecember1，2004，thesalaryoftheemployee，’E0025’，wasincreasedby$400.Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’：

SQL>UPDATEEMPLOYEESETSALARY=2400

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnJuly1，2005，thesalaryoftheemployee，’E0025’，wasincreasedby$500.Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’

SQL>UPDATEEMPLOYEESETSALARY=2900

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnJuly5，2005，theHRmanageraskedyoutogeneratetheincrementreportoftheemployee，’E0025’，fortheperiodbetween1May2004and1July2005.Whichflashbackfeaturewillyouusetogeneratetheincrementreport？（）

SQL语句的WHERE子句可以限制表中的记录，完成同样功能的宏命令是

A.Requery

B.FindRecord

C.ApplyFilter

D.FindNextRecord

Exhibit:

UPDATE EzonexamConsolidated

SET District = ‘Mexico’

WHERE RtvID = 45

You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.

When users run the query in the exhibit above the receive the following error message:

Server: Mrh3612, Level 16, Stats 1, Line 1

View or function ‘EzonexamConsolidated’ is not updateable because it

contains aggregates:

How should you enable the query to run?

A．Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.

B．The appropriate users should be granted UPDATE permissions on each base table.

C．To enable updates on the composite tables create an INSTEAD OF trigger on the view.

D．On each base table add a cascading update trigger.

Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

Misers everywhere: that Mediterranean cruise could be within reach at last. There'll be no free ride to the port, and no free food or entertainment on board. The cabin will measure 30 meters square and housekeeping will be extra. But the fiberglass suite is easy to clean, and costs as little as ￡29 a night.

Earlier this year, serial entrepreneur Stelios Haji-Ioannou, the man who gave Europe its first budget airline, cashed in ￡14 million of his easyJet shares to fund what he calls a "little shopping spree." Boldly expanding his no-frills model into new markets, Stelios (he insists on first-name in formality) plans to open the first easyHotel in London this year with prices from ￡ 5 a night, an easy Bus fleet and easy Cruise, ready to sail next summer. Also on the list: easy Pizzas and easy Tele com, a mobile-phone service.

Can he make it work? The soaring success of easyJet and its rivals was Europe's great business story of the late 1990s, and yet more carriers are emerging to serve the 10 nations that joined the European Union last week. While copycatting the idea may look like a no-brainer, though, some experts doubt Stelios's expansion plans have much of a future. "The no-frills model is very fragile." says Chris Voss of London Business School. "Stelios is applying it rather indiscriminately."

The entrepreneur's record is mixed. He launched easyJet in 1995, when he was 28, and it now has 70 planes and revenues of ￡932 million last year, up nearly 70 percent from 2002. But his first attempt to clone the no-frills model, a Europe-wide chain of Internet cafes launched at the height of the bubble, has since struggled to make money. His first easy Cinema-tickets for just 50 pence is suffering because big distributors, fearful of undercutting their other business, refuse to allow cheap screenings of new blockbusters.

The larger problem: reducing prices is not enough to make no-frills work. Stelios, for example, likes to sell direct to the customer, preferably online, and avoids corporate accounts on the theory that only individuals care enough about price to be loyal no-kills customers. He chooses only sectors in which the volume of business will clearly rise as prices fall. There's no point, say, in offering a cut-rate burial service. Says Stelios: "The demand for funerals isn't going to go up—regardless of the price."

If one travels on the Mediterranean cruise in the future,

A．he/she will become a cheapskate.

B．it will cost him/her more money.

C．it will become more economical.

D．there will be no free services.

Would-be language teachers everywhere have one thing in common: they all want some recognition of their professional status and skills, and a job. The former requirement is obviously important on a personal level, but it is vital if you are to have any chance of finding work.

Ten years ago, the situation was very different. In virtually, every developing country, and in many developed countries as well, being a native English speaker was enough to get you employed as an English teacher.

Now employers will only look at teachers who have the knowledge, the skills and attitudes to teach English effectively. The result of this has been to raise non-native English teachers to the same status as their native counterparts--something they have always deserved but seldom enjoyed. Non- natives are now happy-linguistic discrimination is a thing of the past.

An ongoing research project, funded by the University of Cambridge, asked a sample of teachers, teacher educators and employers in more than 40 countries whether they regard the native/non- native speakers distinction as being at all important. "NO" was the answer. As long as candidates could teach and had the required level of English, it didn't matter who they were and where they came from. Thus a new form. of discrimination this time justified because it singled out the unqualified-liberated the linguistically oppressed. But the Cambridge project did more than just that, it con- firmed that the needs of native and non-native teachers are extremely similar.

The selection of English teachers used to be mainly based on ______.

听录音，回答以下问题： Would-be language teachers everywhere have one thing in common: they all want some recognition of their professional status and skills, and a job. The former 26 is obviously important on a personal level, but it is 27 if you are to have any chance of finding work. Ten years ago, the 28 was very different. In virtually every developing country, and in many developed countries as well, being a native English speaker was enough to 29 as an English teacher. Now employers will only look at teachers who have the knowledge, the skills and attitudes to teach English 30 The result of this has been to raise non-native English teachers to the same status as their 31 --something they have always deserved but seldom enjoyed. Non-natives are now happy—linguistic discrimination is a thing of the past. An ongoing research project, funded by the University of Cambridge, asked a sample of teachers, teacher educators and employers in more than 40 countries a question: whether they regard the native andnon-native speakers distinction as being at all important. "No" was the answer. They would 32 who the teachers were and where they came from. As long as 33 could teach and had the required level of English, it didnt matter. Thus, a new form. of discrimination--this time justified because it 34 the unqualified--liberated the linguistically oppressed. But the Cambridge project did more than just that: it 35 that the needs of native and non-native teachers are extremely similar. 26._________

Where are the photos much cheaper?

A．In a photographer's studio.

B．In the library.

C．In the post office.

D．Not mentioned.

Mobile phones help us communicate everywhere, which is very important. They are good at emergencies, when you've【21】a car accident, for instance. A mobile phone【22】save your life! Mobile phones are also【23】because they have many good features—we can take photos and send them all over the world. But every coin has two sides. The【24】thing about mobile phones is that you have no privacy. My boss and friends find me whenever they want! I haven't enjoyed a whole quiet day since the day I【25】my mobile phone.【26】disadvantage is that mobile phones make us lose good habits, such as punctuality. Before, when we【27】keep in touch so easily, if we had a date with someone, we tried our best to arrive【28】time. But now, because of the mobile phone, we are not afraid of【29】late any more, so, surprisingly enough, we make people wait! The third【30】I see is that I change my mobile phone once a year, and this means I'm spending【31】too much money on it. I think it is important to think【32】we use mobile phones. We should use things such as mobile phones, laptops, cameras, the Internet, and so on,【33】our needs. We can【34】our mobile phone when we don't want to be disturbed by【35】. If we know how to use it, we can eliminate its disadvantages.

(41)

A．have

B．made

C．had

D．crashed