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

طباعة
تضمين

لوحة الصدارة

النمط البصري

الخيارات

تبديل القالب

استعادة الحفظ التلقائي: ؟