单选题Mark was a student at this university from 1999 to 2003, _____ he studied very hard and was made chairman of the Students’ Union.Aduring which timeBfor which timeCduring whose timeDby that time
单选题
Mark was a student at this university from 1999 to 2003, _____ he studied very hard and was made chairman of the Students’ Union.
A
during which time
B
for which time
C
during whose time
D
by that time
参考解析
解析：
1999到2003为一阶段时间，故应提前介词during，which time代替这一阶段。
1999到2003为一阶段时间，故应提前介词during，which time代替这一阶段。
相关考题：
（40）查找学生姓名及其所选修课程号和成绩，正确的 SQL 语句是A）SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.snoB） FROM sname,cno,grade FROM student,course WHERE student.sno =course.cnoC） SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.cno=course.cnoD） SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
使用SQL语句从表STUDENT中查询所有姓王的同学的信息，正确的命令是：A）SELECT*FROM STUDENT WHERE LEFT（姓名，2）＝“王”B）SELECT*FROM STUDENT WHERE RIGHT（姓名，2）＝“王”C）SELECT*FROM STUDENT WHERE TRIM（姓名，2）＝“王”D）SELECT*FROM STUDENT WHERE STR(姓名，2)=“王”
Edward, ()university student from Europe, teaches us()art in his spare time.A、an, /B、an, anC、a, /D、an , the
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
根据SQL标准，下面哪条语句与select min(age) from student等效?()A select age from student where age >= min(age)B select distinct age from student where age >= all min(age)C select distinct a.age from student a where a.ageD select distinct a.age from student a where a.age
根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用?()A select * from student where ageB select * from student having ageC select * from student a where a.ageD select * from student a where (select avg(b.age) from student b ) >= a.age
查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是A．SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.snoB．SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cnoC．SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cnoD．SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno
对于数据表：student(sno,sname,sex,age,grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是______。A．SELECT sno,sname FROM student WHERE gade=NULLB．SELECT sno,sname FROM student WHERE grade IS NULLC．SELECT sno,age FROM student WHERE grade IS NULLD．SELECT mo,age FROM student WHERE grade=NULL
使用SQL语句从表STUDENT中查询所有姓王的同学的信息，正确的命令是：______。A．SELECT*FROM STUDENT WHERE LEFT(姓名，2)=“王”B．SELECT*FROM STUDENT WHERE RIGHT(姓名，2)=“王”C．SELECT*FROM STUDENT WHERE TRIM(姓名，2)=“王”D．SELECT*FROM STUDENT WHERE STR(姓名，2)=“王”
已知有关系“STUDENT”，则关系运算σANE＜80(STUDENT)用SQL语句表示为(52)。A．SELECT( * )FROM STUDENT WHERE AVE ＜ 80B．SELECT( * )FROM STUDENT HAVING AVE ＜ 80C．SELECT(AVE)FROM STUDENT WHERE AVE ＜ 80D．SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80
Academic records from other institutions often become part of a university's official file and can neither be returned to a student nor duplicated.A:borrowedB:purchasedC:copiedD:rewritten
Hello, Peter. What do you do?（）AI am fine.BI am not sick.CI am a student from Bonn University.DI came from Bonn University.
查询student表中的所有非空email信息，以下语句正确的是（）。A、Select email from student where email !=nullB、Select email from student where email not is nullC、Select email from student where email nullD、Select email from student where email is not null
数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键为Number。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）A、Select* From Student Where Sex=’男’B、Select* From Student Where Number NotIn（Select Number From Student Where Sex=’男’）C、Select* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）D、Select* From Student Where Sex’男’
查询student表中的所有非空email信息，以下语句正确的是（）A、Select email from student where email!=nullB、Select email from student where emailnotisnullC、Select email from student where emailnullD、Select email from student where emailisnotnull
在Transact-SQL语法中，以下SELECT语句正确的是（）。A、SELECT * FROM studentB、SELECT * FROM student WHERE GETDATE（）C、SELECT * FROM student ORDER st_idD、SELECT * FROM student BY St_name
类 Student 中字段mark的缺省值是哪项？（） Class Student｛ String name； int age； float market； ········· ｝ A、0.0fB、numllC、falseD、0E、0.0
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）A、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;B、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;C、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;D、SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;E、SELECT student_id, semester_end, gpa FROM student_grades
单选题Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?（）ASELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;BSELECT student_id, marks, ROWID Rank FROM students WHERE ROWID = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;CSELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;DSELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM = 10;ESELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM = 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
单选题Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? （）ASELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;BSELECT student_id, marks, ROWID Rank FROM students WHERE ROWID = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;CSELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM = 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;DSELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM = 10;ESELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM = 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
单选题Hello, Peter. What do you do?（）AI am fine.BI am not sick.CI am a student from Bonn University.DI came from Bonn University.
单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）ASELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;BSELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;CSELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;DSELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;ESELECT student_id, semester_end, gpa FROM student_grades
单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）ASELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;BSELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;CSELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;DSELECT student_id, gpa FROM student_grades ORDER BY gpa;ESELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;FSELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
单选题以下（）语句从表student中提取前5条记录。Aselect * from student where rowcount=5Bselect TOP of 5*from studentCselect TOP5 * from studentDselect * from student where rowcount=5
单选题All of Mark's former students go to college. If the statement above is true, which of the following must also be true?AIf Ethan was not Mark's student, then he is not going to college.BIf Joyelle goes to college, then she was not Mark's student.CIf Ginger goes to college, then she was Mark's student.DIf Stephanie was Mark's student, then she is not going to college.EIf Steve does not go to college, then he was not Mark's student.