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

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?