Assessment: SQL/Selecting Data

Sep 30, 2014 • James Hiebert

1) Choose the best SQL query to list all of the survey readings in the Survey table from this lesson:

a) SELECT readings FROM Survey;
b) select * from survey;
c) SeLeCt ReAdInG FrOm SuRvEy;
d) SELECT reading FROM survey;
e) SELECT reading, reading, reading FROM Survey;

2) Match each instance in the left hand column with its associated concept in the right hand column. Blank is an instance of a(n) blank.

Survey                                SQL query
lake Anderson Lake                    database row
reading                               database manager (DBMS)
PostgreSQL                            record
619 dyer rad 9.82                     column
ident                                 field
select personal, family from Person;  table