SQL Quiz

1. What is a flat file database?

• a database that stores records in a single file with no hierarchical structure

• a database that requires SQL to store, manipulate, and retrieve data

• a database that is used to store large amounts of complex data

• a database that stores data in a sheet using hierarchical tabular format of columns and rows

2. Which commonly used SQL statement is necessary to retrieve data from one or more tables in a database?

• TRUNCATE

• INSERT

• SELECT

• CREATE

3. Which SQL statement is used to filter data in a database?

• ORDER BY

• WHERE

• DISTINCT

• FROM

4. What is used to show how the tables in a database are related to one another?

• CSV

• ERD

• DML

• DDL

Which is the correct syntax in SQL to retrieve all the columns from a fellow table in a database?

• SELECT * FROM fellows

• SELECT all FROM fellows

• SELECT FROM all Fellows

• SELECT * FROM

Which SQL syntax is used with the aggregate function like SUM() to roll up columns?

• ORDER BY

• GROUP BY

• HAVING

• WHERE

The default sorting order in MYSQL is _________

Aliases are used in SQL to

• Temporarily rename rows

• Permanently rename columns

• Temporarily rename columns

• Permanently rename rows

9. In the SQL statement "SELECT genre FROM movies" what is specified by "genre"?

• the folder

• the table

• the database

• the column

6. Which structure in a table represents an individual record contained in the database?

• Row

• column

• foreign key

• relationship