Assessment: Using Databases & SQL --- Selecting Data

Oct 1, 2014 • Eric Youngson
  1. Given the database on this page, select a command from the list below that will select only the readings from the survey table in the most readable form.

a) SELECT * FROM survey;

b) SELECT reading FROM survey

c) SELECT reading FROM survey;

d) SELECT READING FROM SURVEY;

 

  1. Given the following fragments, put together a SQL statement that will select the identifier and location from the database. (More than one correct answer may be possible)

SELECT ident, ident, ident,

FROM site;

ident, site

SELECT name, lat, long

FROM visited;