在SQL Server 2000中,设有课程表(课程号,课程名,学分,开课学期),现

题型:单项选择题

问题:

在SQL Server 2000中,设有课程表(课程号,课程名,学分,开课学期),现要在此关系表上建立一个查询指定学期开设的课程总门数和总学分数的内嵌表值函数,函数名为f _FindTotal。实现这个函数的正确代码是()

A.CREATE  FUNCTION  f_FindTotal(@semester int) RETURNS table  AS  RETURN( SELECT COUNT(课程号)as课程门数, SUM(学分)as总学分FROM课程表 WHERE开课学期 = @ semester)

B.CREATE  FUNCTION  f_FindTotal(@semester int) RETURNS table  AS  RETURN( SELECT COUNT(课程号)as课程门数, COUNT(学分)as总学分FROM课程表 WHERE开课学期 = @semester)

C.CREATE  FUNCTION  f_FindTotal(@semester int) RETURNS table  AS  RETURN( SELECT SUM(课程号)as课程门数, SUM(学分)as总学分FROM课程表 WHERE开课学期= @semester)

D.CREATE  FUNCTION  f_FindTotal(@semester int) RETURNS table  AS  RETURN(SELECT SUM(课程号)as课程门数, COUNT(学分)as 总学分FROM课程表 WHERE开课学期 = @semester)

考点:计算机等级考试数据库工程师数据库工程师真题2010年3月
题型:单项选择题
There was a time when I thought my dad didn’t know how to be a good father. I couldn’t  16  him ever saying the words “I love you.” It seems to me his only purpose in life was to say “  17 ” to anywhere I wanted to go and anything I wanted to do, including getting a  18 . Some parents bought their kids cars when they got their driver’s licenses. Not my dad — he said that I’d have to get a job and buy my own.
So that is what I did. I got a job at a very nice restaurant and  19  every penny I could and when I had enough to buy my car, I did! The day I brought that car home, my dad was the first one I wanted to  20  it off to. “Look, dad, a car of my own. If you ever want a ride, you only need to pay me five dollars.” I offered with a smile.
“I see,” was all he said.
One day, there was something wrong with my father’s truck. So he needed a  21  to work. The sun wasn’t even up when we left the house,   22  it was already getting warm out. It was going to be a hot day. As my dad got out of my car, I   23  him, dressed in his work clothes, getting his  24  from the truck (车尾箱) of my car. Watching his sun-weathered face, and even from a distance I could tell there were 25  lines than I ever remembered being there before. I realized how hard my dad works for the family. My father is a cement finisher(水泥修整工).
Suddenly, it came up with me that he actually got down on his hands and knees to sweat over hot concrete(混凝土) to make a living for his family. And he did this day in and day out,  26 hot it got. Never, not once, had I heard him   27  about it. To him we were “worth” it. And never once did he ask us to pay for it.
When he closed the trunk, his tools set off to the side, he walked over to my window to   28  me five dollars. I rolled down the window and said “Good-bye, dad. Keep your five dollars. It’s my __29__. Don’t work too hard. I love you.”
His eyes met mine, then glanced away in the direction of his waiting tools, he   30  his throat(喉咙) and said, “Oh, and… me, too.”
小题1:
A.likeB.rememberC.forgetD.care
小题2:
A.SorryB.YesC.NoD.Well
小题3:
A.carB.friendC.jobD.present
小题4:
A.spentB.earnedC.keptD.saved
小题5:
A.takeB.put C.turnD.show
小题6:
A.rideB.leaveC.tripD.hurry
小题7:
A.asB.althoughC.butD.since
小题8:
A.helpedB.followedC.leftD.watched
小题9:
A.toolsB.clothesC.luggage D.bag
小题10:
A.fewerB.moreC.longerD.less
小题11:
A.whateverB.wheneverC.whereverD.however
小题12:
A.talkB.complainC.askD.speak
小题13:
A.handB.borrowC.lendD.take
小题14:
A.helpB.adviceC.treat D.idea
小题15:
A.cleanedB.wipedC.clearedD.felt
题型:单项选择题

关于抗体,正确的是

A.都是免疫球蛋白

B.由T细胞产生

C.免疫球蛋白都是抗体

D.由吞噬细胞产生

E.能与多种抗原结合

题型:单项选择题

王某,50岁。刺激性咳嗽2个月,伴痰中带血,X线胸片示右上肺叶部分不张,纤维支气管镜检查见右肺上叶支气管开口处有菜花样肿物,质脆,易出血。病理尚未回报。现症见:咳嗽,痰中带血,心烦少寐,手足心热,盗汗,口渴,大便秘结,舌质红,苔薄黄,脉细数。

其治疗首选方剂是()

A.血府逐瘀汤

B.增液承气汤

C.沙参麦冬汤

D.益气聪明汤

E.半夏茯苓汤

题型:单项选择题

罗马帝国后期,屡次骚扰西哥特人的民族是()。

A、突厥

B、匈奴

C、波斯人

D、俄罗斯人

题型:单项选择题

热原的除去方法不包括()

A.高温法

B.酸碱法

C.吸附法

D.微孔滤膜过滤法

E.离子交换法

更多题库