Examine the structure of the STUDENTS table: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?()
A.
B.
C.
D.
第1题:
第2题:
第3题:
Students: Professor Lance, your lecture on cloning is very interesting!
Professor: .Are you a student of biology?
Students: No, I major in chemistry.
A. I think so
B. I'm glad to hear that
C. It must be
D. It's not so interesting
第4题:
【单选题】按照年龄的升序显示学生信息,正确的命令是?
A.db.students.find().sort({"age":1})
B.db.students.find().sort({"age":-1})
C.db.students.find().sort("age")
D.db.students.find().sort({"age":"asc"})
第5题:
创建students对象,_______语句可以选出第二个同学的身高。 students数据如下: age height weight 1 19 170 68 2 20 165 65 3 18 175 65
A.students[1,'height']
B.students.loc[2,'height']
C.students.iloc[1, 1]
D.students['height'][3]
第6题:
第7题:
声明并创建一个学生类Student的对象s,下列语法格式正确的是()。
A.Student s = Student();
B.Student s;
C.Student s = new Student();
D.Student s = new ();
第8题:
A.CREATEVIEWview_students_computerASSELECT*FROMstudentsWHEREdept='计算机技术';
B.CREATEORREPLACEVIEWview_students_computerASSELECT*FROMstudentsWHEREdept='计算机技术';
C.UPDATEVIEWview_students_computerASSELECT*FROMstudentsWHEREdept='计算机技术';
D.ALTERVIEWview_students_computerASSELECT*FROMstudentsWHEREdept='计算机技术';
第9题:
【单选题】查询成绩在60-80之间的学生信息,正确的语句是?
A.db.students.find({"score":{$gte:60,$lte:80}})
B.db.students.find({"score":{$gte:80},{"score":{$lte:60}}})
C.db.students.find({"score":{$gte:60},{"score":{$te:80}}})
D.db.students.find({"score":{$gt:80},{"score":{$lt:60}}})
第10题:
创建students对象,_______语句可以选出第二个同学的身高。 students数据如下: age height weight 1 19 170 68 2 20 165 65 3 18 175 65
A.students.loc[2,'height']
B.students.iloc[1, 1]
C.students[1,'height']
D.students['height'][3]