当用户对表中的数据进行下面哪种操作时不可使触发器自动触发执行______。
A. UPDATE
B. INSERT
C. SELECT
DELETE
查看答案
设在某SQL Server 2000数据库中有选课表(学号,课程号,成绩),该表有如下数据: 学号课程号成绩S01C0170S01C0255S02C0170 设在成绩列上定义了一个由UPDATE操作触发的触发器,该触发器用于禁止将不及格成绩(小于60)改为及格(大于60)。若执行语句: ·UPDATE选课表SET 成绩=成绩+10 WHERE 学号=’S01’ 则系统为该触发器生成的临时工作表及内容是______。
A. INSERTED表,数据为: 学号课程号成绩S01C0180S01C0265 和DELETED表,数据为: 学号课程号成绩S01C0170S01C0255
B. INSERTED表,数据为: 学号课程号成绩S01C0170S01C0255 和DELETED表,数据为: 学号课程号成绩S01C0180S01C0265
C. INSERTED表,数据为: 学号课程号成绩S01C0265 和DELETED表,数据为: 学号课程号成绩S01C0255
D. INSERTED表,数据为: 学号课程号成绩S01C0180 和DELETED表,数据为: 学号课程号成绩S01C0170
创建触发器时,以下说法错误的是______。
A. 在一个表上可以建立多个名称不同、类型各异的触发器
B. 增、删、改记录都可以使用触发器
C. 修改数据库以及数据库对象的语句可以在触发器中使用
D. 通常不要在触发器中返回任何结果
以下关于内嵌表值函数说法错误的是______。
A. 内嵌表值函数的返回值是一个表
B. 返回的表的内容是一个查询语句的结果
C. 内嵌表值函数的使用与视图完全相同
D. 内嵌表值函数的使用需要放在查询语句的FROM子句中
I won"t be modest. I am gratified to discover that a paper I penned on inequality made its way into Matt Miller"s Washington Post column last week. Mr Miller asks why rising inequality has not【C1】______America"s least-favored classes to agitate for a【C2】______He agrees with my verdict: that access to【C3】______goods among the least well-off has ensured that material inequality is not as【C4】______as income inequality. 【C5】______modem conveniences have taken some of the【C6】______out of a relatively small income. This in turn has【C7】______the drive to seek causes of and cures for【C8】______"s discomfort. So the gap between rich and poor is sometimes less【C9】______, even if it is great and growing. Day-to-day experience is mostly a matter of our【C10】______circumstances, and if those are【C11】______enough, a widening gap in income, consumption or wealth is【C12】______to come often to our attention. Even if the abstract fact of rising inequality does come across our radar, it may【C13】______our sense of justice only if we"ve become convinced that inequality itself is【C14】______, or if we face related catastrophes. When I wrote the paper, official measures of income inequality had increased a good deal over the past few decades【C15】______consumption inequality seemed to have remained【C16】______New research suggests that consumption inequality has been increasing with income inequality【C17】______This may be true, but it seems【C18】______to the question of why America"s poor aren"t storming the barriers. The consumption data concerns how much we【C19】______, not how we experience what we buy, and that"s the real issue. Even if we could agree that inequality in real standards of living is rising, this is not something we actually experience unless we are hungry, or【C20】______with the entertainments of our leisure. 【C9】
A. invisible
B. conspicuous
C. wide
D. acceptable