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

印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?