【单选题】
关系代数中的连接运算是由___操作导出的。
A. 选择和投影
B. 选择和笛卡儿积
C. 投影、选择、笛卡儿积
D. 投影和笛卡儿积
查看试卷,进入试卷练习
微信扫一扫,开始刷题

答案
B
解析
暂无解析
相关试题
【单选题】
如果表S(A,B,C)中,设置A为主键,当向S表插入一行新数据时,该行___。
A. A,B,C属性的值都可以与已有的行相同
B. A,B,C属性的值都不能与已有的行相同
C. A属性的值不能与已有的行相同,但允许为空
D. A属性的值不能与已有的行相同,也不能为空
【单选题】
在SQL Server的以下数据类型中,最适合表示一个人的体重(公斤,保留一位小数)的是___。
A. char
B. float
C. tinyint
D. numeric
【单选题】
对于数据库中的表A,如果想要清空A中的数据且不留下事务日志,应使用___。
A. DELETE TABLE A
B. DROP TABLE A
C. ALTER TABLE A
D. TRUNCATE TABLE A
【单选题】
对工资表(员工号,姓名,部门号,月薪)进行查询,分部门统计人数和平均工资,查询语句应使用___。
A. SELECT 部门号,Count(*),AVG(月薪) FROM 工资表 GROUP BY 月薪
B. SELECT 姓名,Count(*),AVG(月薪) FROM 工资表 GROUP BY 部门号
C. SELECT 部门号,Count(月薪),AVG(*) FROM 工资表 GROUP BY 部门号
D. SELECT 部门号,Count(月薪),AVG(月薪) FROM 工资表 GROUP BY 部门号
【单选题】
学生成绩表grade中有字段score(float),现要把所有在55-60之间的分数提高5分,以下语句正确的是___
A. update grade set score=score+5 where score in 55…60
B. update grade set score=score+5 where score>=55 and score<=60
C. update grade set score=score+5 where score between 55 or 60
D. update grade set score=score+5 where score<=55 and score>=60
【单选题】
对于索引,以下说法正确的是___。
A. 一个数据表只能有一个索引
B. 一个数据表只能有一个唯一索引
C. 一个数据表只能有一个聚集索引
D. 一个数据标只能有一个非聚集索引
【单选题】
下列关于索引的描述不正确的是___
A. 索引是一个指向表中数据的指针
B. 索引是在元组上建立的一种数据库对象
C. 索引的建立和删除对数据毫无影响
D. 表被删除时将同时删除表上建立的索引
【单选题】
在创建表的同时,可以用___ 来创建唯一性索引
A. 设置主键约束或唯一约束
B. create table ,create index
C. create index
D. 都可以
【单选题】
如果有两个事务同时对数据库中同一数据进行操作,不会引起冲突的是___。
A. 一个DELETE和一个SELECT
B. 一个SELECT和一个DELETE
C. 两个UPDATE
D. 两个SELECT
【单选题】
当触发器执行时,系统会创建临时表保存用户操作更改的行的新值和旧值, UPDATE操作所涉及的值会被临时保存在___。
A. updated表
B. inserted 表
C. deleted表
D. inserted表和deleted表
【单选题】
以下哪个选项正确___
A. 简单恢复模型不允许高性能大容量复制操作
B. 完全恢复模型可以恢复到任意即时点
C. 大容量日志记录恢复可以允许数据库恢复到任意即时点
D. 完全恢复模型在大容量复制时会造成严重数据丢失
【单选题】
中国封建社会政治的基本特征是 ___
A. 高度中央集权的封建君主专制制度
B. 族权和政权相结合的封建宗法等级制度
C. 国家统一和各民族经济文化紧密联系
D. 结构稳定、延续,发展缓慢、迟滞
推荐试题
【单选题】
The road now ___two kilometers beyond the river.
A. develops
B. extends
C. expands
D. widens
【单选题】
It was claimed that the level of alcohol in the man’s blood was ___ to cause an accident.
A. sufficient
B. adequate
C. enough
D. accurate
【单选题】
Medical care reform has become this country’s most important public health ___.
A. question
B. stuff
C. matter
D. problem
【单选题】
His retail business in the city___ rapidly between the wars.
A. enlarged
B. extended
C. widened
D. expanded
【单选题】
Many frogs ___ the sound of their voice using special sacs(囊) in their throat.
A. amplify
B. widen
C. expand
D. enlarge
【单选题】
Some old people don’t like pop songs because they cannot ___ so much noise.
A. resist
B. sustain
C. tolerate
D. undergo
【单选题】
I have kept that portrait where I can see it every day, as it always ___ me of my university days in London.
A. recollects
B. reminds
C. recalls
D. invokes
【单选题】
The article suggests that when a person is under unusual ___ he should be especially careful to have a well-balanced diet.
A. weight
B. stress
C. press
D. nerve
【单选题】
You should hire a more ___ manager than the one you currently have.
A. sufficient
B. effective
C. respective
D. efficient
【单选题】
Surgeons began to ___ their hands and arms with soap and water before operating.
A. scrub
B. enhance
C. rub
D. exhibit
【单选题】
He might let something ___ in a moment of weakness.
A. slip
B. leak
C. to slip
D. to leak
【单选题】
The ___ for which he had fought all his life no longer seemed important to him.
A. aims
B. objectives
C. subjects
D. goals
【单选题】
Eating too much fat can ____heart disease and cause high blood pressure.
A. contribute to
B. attribute to
C. attest to
D. devote to
【单选题】
It soon ___ that what she loved was not my person but my wealth.
A. widened
B. expanded
C. extended
D. developed
【单选题】
I want to buy a new tie to ___ this brown suit.
A. go into
B. go after
C. go with
D. go through
【单选题】
Our company decided to ___ the contract because a number of the conditions in it had not been met.
A. destroy
B. resist
C. assume
D. cancel
【单选题】
I think it’s time I ___ in a new computer.
A. invested
B. insulted
C. interacted
D. impacted
【单选题】
The jeweler will ____ the inside of the ring with her name.
A. carve
B. engrave
C. cut
D. engross
【单选题】
They are _____ moving their office outside London.
A. considered
B. discussing
C. pondering
D. negotiating
【单选题】
Although she _____ the old pot thoroughly, she could not make it look completely clean.
A. scrubbed
B. washed
C. made
D. screwed
【单选题】
The mistake will remain an indelible ____ on his memory.
A. stain
B. thing
C. issue
D. accident
【单选题】
The wheel ____ through my frozen hand, and the car went right across the road.
A. slipped
B. sipped
C. dashed
D. disappeared
【单选题】
The cupboard was ____ with old fishing tackle.
A. stuffed
B. stocked
C. stored
D. filled
【单选题】
Teaching can be a tiring and ____ job.
A. meaningless
B. stressed
C. rewarded
D. stressful
【单选题】
The building is partly a museum and partly a private ____.
A. place
B. area
C. community
D. residence
【单选题】
They conferred on the best way to ______ business.
A. extend
B. adjust
C. expand
D. adopt
【单选题】
We had a party last month, and it was a lot of fun, so let’s have ____ one this month.
A. another
B. the other B. more D. other
【单选题】
I decided to go to the library as soon as I ____.
A. finish what I did
B. finished what I did
C. would finish what I was doing
D. finished what I was doing
【单选题】
The speaker, ______ for her splendid speeches, was warmly received by the audience.
A. having known
B. being known
C. knowing
D. known
【单选题】
No sooner had we reached the top of the hill ______ we all sat down to rest.
A. when
B. then
C. than
D. until
【单选题】
___ energy under the earth must be released in one form or another, for example, an earthquake.
A. Accumulated
B. Gathered
C. Assembled
D. Collected
【单选题】
Please ___ me for my rudeness. I really do not know the custom here.
A. engaged
B. comfort
C. execute
D. forgive