单选

●已知基本表：学生(学号，姓名，性别，年龄，系名)
选课(学号，课程号，成绩)
要检索所有比"王华"年龄大的学生姓名、年龄和性别，正确的语句是 (25) ，要检索学生姓名及其所选修课程的课程号和成绩，正确的语句是 (26) 。
(25)

A．SELECT姓名，年龄，性别
FROM学生 WHERE AGE>(SELECT 年龄
FROM 学生 WHERE 姓名 ="王华") &n
bsp; B．SELE
CT姓名，年龄，性别
FROM学生 WHERE姓名="王华"
C．SELECT姓名，年龄，性别
FROM学生 WHERE AGE>(SELECT年龄 WHERE姓名="王华")
D．SELECT姓名，年龄，性别
FROM学生 WHERE AGE>"王华" (26) A．SELECT 学生．姓名，选课．课程号，选课．成绩
FROM学生 WHERE学生学号=课程．学号
B．SELECT学生．姓名，选课．课程号，选课．成绩
FROM选课 WHERE学生．学号=课程．学号
C．SELECT学生．姓名，选课．课程号，选课．成绩
FROM学生，选课 WHERE学生．学号=课程．学号
D．SELECT学生．姓名，选课．课程号，选课．成绩
FROM学生．学号

试题出自试卷《2011年程序员考试考前密卷（四）-上午试题》

参考答案

查看试卷详情

相关试题

●
- ASCII is a 7-
- bit
- co
- de used to represent numeric，alphabetic，and special printable characters．It also includes codes for control characters，which are (75) . (75) A．printable or displayable
- B．not printable or displayable
- C．not printable but displayable
- D．printable but not displayable
点击查看答案
●The error mess
- ages given
- by a
- C compiler show the message text,the most common cause of the error,an
- d a suggestion for (73) the error. (73) A．upfsying
- B．fixing
- C．changing
- D．Editing
点击查看答案
●How m
- any key comparisons are needed in searching for key value 38?&n
- bsp;(74) . (74) A．1
- B．4
- C．3
- D．2
点击查看答案
●By me
- ans of multiple pipeline to carry out multiple processing，this technology is called&n
- bsp;(71) ． (71) A．Multiple pipeling
- B．Superpipeline
- C．Superscalar
- D．Very long instruction word
点击查看答案
●Tr
- ansport gateways connect
- byte streams in the transport layer．Appli
- cation gateways allow interworking above (72) ． (72) A．network layer
- B．
- data link layer
- C．transport layer
- D．appfication layer
点击查看答案
●
- An instruction that uses indrect addressing mustt contain an address of memory where&n
- bsp;(69) ． (69) A．data is stored
- B．a pipeline stall will be exe
- cute
- d
- C．a page fault is addressed
- D．another address is stored
点击查看答案
●Wh
- at is the decimal value of the
- binary value 10010？ (70) . (70) A．18
- B．20
- C．14
- D．15
点击查看答案
●In which ph
- ase of the software engineering process is the Software Requirements Specification developed?&n
- bsp; (68) ． (68) A．development phase
- B．engineering phase
- C．maintenance phase
- D．Definition phase
点击查看答案
In a computer，if a logical left shift of the operand occurs，its lowest bit is () .
- A.unchanged
- B.1
- C.0
- D.random
点击查看答案
● The sorting method described by the code is c
- alled&n
- bsp;(67) ． (67) A．Insertion sort
- B．Sele
- ction sort
- C．Ra
- dix sort
- D．Merge sort
点击查看答案