1) SQL is used to find.............. data in a database. a) specific b) general c) every 2) The three main concepts of SQL are....... a) FROM, SELECTION, WHERE b) SELECT, FROM, WHERE c) SELECT, IN, WHERE 3) Using SELECT returns the........ a) Fields b) Table c) Criteria 4) Using FROM returns the........ a) Fields b) Table c) Criteria 5) Using WHERE returns the...... a) Fields b) Table c) Criteria 6) Using FROM returns the........ a) Fields b) Table c) Criteria 7) Searching the first name and surname of students in the table Students. a) SELECT: Surname, Forename b) FROM: Students c) FROM: Surname d) SELECT: Forename e) FROM: Student 8) The three main concepts of SQL are....... a) FROM, SELECTION, WHERE b) SELECT, FROM, WHERE c) SELECT, IN, WHERE 9) Searching the first name and surname of year 10 students in the table Students. a) SELECT: Surname, Forename b) FROM: Students c) WHERE: Year = 10 d) SELECT: Forename e) FROM: Student f) WHERE: 10 10) What does the * mean in SQL? a) Not all data b) All data 11) Using WHERE returns the...... a) Fields b) Table c) Criteria 12) Using SELECT returns the........ a) Fields b) Table c) Criteria

SQL STATEMENTS

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？