Year 11 SQL (Tasting lesson)

Multiple Choice

Which of the following is the correct SQL to output name, year and house of students from the table "Students"

• Output name, year, house from table

• Output name, year, house from Students

• Select name, year, house from Students

• Select name, year, house from table

Multiple Choice

Which of the following is the correct SQL to output all fields from table Students?

• Select all from Students

• Select * from Students

• Select fields from Students

• Select * fields from Students

Multiple Choice

Which of the following is the correct SQL to output all fields of students from house 4?

• Select * from Students where house=4

• Select * from Students when house=4

• Select * from Students if house=4

• Select * from Students while house=4

Multiple Choice

Which of the following is the correct SQL to output the names of year 11 students from house 1

• Select name from Students where year=11

• Select name from Students where house=1

• Select name from Students where year=11 and house=1

• Select name from Students where year=11 or house=1

Multiple Choice

Which of the following is the correct SQL to output the names of students with name starting with "S"

• Select name from Students where name like 'S*'

• Select name from Students where name[0]='S'

• Select name from Students where name='S'

• Select name from Students where name='S*'

Multiple Choice

Which of the followings is the correct SQL to output the names of students and their computer marks?

Multiple Choice

Which of the following is the correct SQL to output the names of students and their computer marks in ascending order of computer marks?

Multiple Choice

What is the possible problem if the table is defined as in the figure?

• Marks without input will be zero

• Some storage spaces are wasted

• Students must study in all listed subjects

• Total mark for each student will be wrong

Multiple Choice

How many fields are there in the table "Marks"?

• 2

• 3

• 23

• 24

Multiple Choice

Which of the following should be filled in the SQL to output the students' names and their marks of Computer from the table "Students" and "Marks"?

SELECT Students.Name, Marks.Marks

FROM Students, Marks

WHERE _______________________________

Multiple Choice

Which of the following should be filled in the SQL to output the students’ names and their Media marks from the ‘Students’ and ‘Marks’ tables, in descending order of their names?

SELECT Students.Name, Marks.Marks

FROM Students, Marks

WHERE _______________________________