1) Queries are used to a) output data b) input data c) search data d) analyse data 2) SQL stands for a) structured query line b) system query language c) system query lesson d) structured query language 3) QBE stands for a) query by exercise b) query by exampe c) query base entity d) query by entity 4) QBE is used mainly by software developers a) true b) false 5) QBE is oriented towards the end user rather than developer a) true b) false 6) Who would be more likely to use SQL? a) end user b) developer c) target audience 7) What does the SELECT part of the SELECT statement do? a) selects the tables to use b) selects the fields to show c) selects what to search for 8) What does the WHERE part of the SELECT statement do? a) selects the fields to show b) selects the search criteria c) selects the tables to use 9) What doe the FROM part of the SELECT statement do? a) selects the tables to use b) selects the fields to show c) selects the search criteria 10) What is the clause that allows you to sort the results of a query called? a) FROM b) WHERE c) ORDER BY d) SORT e) SELECT 11) Which statement would return names of all those students who had grade B or higher? a) SELECT first name, surname FROM students WHERE grade >=B b) SELECT first name, surname FROM students WHERE grade <B c) SELECT student FROM students WHERE grade <=B d) SELECT student FROM students WHERE grade >=B

Starting Database Queries

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?