问题 填空题

使用下列INSERT-SQL语句格式向表中插入数据,如果没有指定列名,则新插入的记录要求在每个属性列上 【10】 。 INSERT INTO<表名>[(列名…)]VALUSE(<值>)

答案

参考答案:均有值

解析: 在使用“INSERT INTO<表名>[(列名…)]VALUSE(<值>)”命令向数据表插入记录时,要求“值”和“列名”排列顺序要一致,个数相等,数据类型一一对应,各值之间用逗号隔开。如果INTO子句中没有指定列名,则新插入的记录要求在每个属性列上均有值,且值的排列顺序要和表中各属性列的排列顺序一致。

单项选择题

People can get emotional about immigration. Bill O’Reilly, a talk-show host, devoted a recent segment to the story of an illegal alien who got drunk and accidentally killed two attractive white girls with his car. If only he had been deported for previous misdemeanours, Mr. O’Reilly raged, those girls would still be alive. Another talk-show host, Geraldo Rivera, during an on-air shout-joust(争吵) with Mr. O’ Reilly, denounced his demagogic choice of story-angle as" a sin".

President George Bush tried again this week to bring a more rational tone to the debate. He urged the new Democratic Congress to revive the immigration reforms that the old Republican Congress killed last year. His proposal was broadly the same as before. He said he wanted to make it harder to enter America illegally, but easier to do so legally, and to offer a path to citizenship for the estimated 12m illegals who have already snuck in.

The first part faces few political hurdles and is already well under way. Mr. Bush expects to have doubled the number of Border Patrol agents by the end of next year. The new recruits are being trained. And to defend against the invading legions of would-be gardeners and hotel cleaners, the frontier is also equipped with high-tech military gizmos(小发明), such as unmanned spy planes with infra-red(红外) cameras. This may be having some effect. Mr. Bush boasted that the number of people caught sneaking over the border had fallen by nearly 30% this year.

And the controversial part of Mr. Bush’s immigration package--allowing more immigrants in and offering those already in America a chance to become legal -- is still just a plan. House Republicans squashed it last year. Mr. Bush senses a second chance with the new Democratic Congress, but Democrats, like Republicans, are split on the issue. Some, notably Ted Kennedy, think America should embrace hard- working migrants. Others fret that hard-working migrants will undercut the wages of the native-born.

Mr. Bush would like to see the pro-immigrant wings of both parties work together to give him a bill he can sign. The Senate is expected to squeeze in a debate next month. The administration is trying to entice law-and-order Republicans on board; a recent leaked memo talked of substantial fines for illegals before they can become legal and" much bigger" fines for employers who hire them before they do.

The biggest hurdle, however, may be the Democrats’ reluctance to co-operate with Mr. Bush. Some figure that, rather than letting their hated adversary share the credit for fixing the immigration system, they should stall until a Democrat is in the White House and then take it all. So there is a selfish as well as a moral argument for making a deal.

Which of the following is proposed by Mr. Bush()

A. Making it harder for immigrants to enter America both legally and illegally

B. Carrying out substantial fine for illegals before they can become legal

C. Setting up more Border Patrol agents by the end of this year

D. Allowing more immigrants in and offering them a chance to become legal

选择题