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

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?