SQL & MySQL REVIEW QUIZ

Which three elements of a relational database are defined in the schema? (Choose 3.)

• relationships

• attributes

• tables

• SQL keywords

• aliases

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

• the table

• the column

• the database

• the folder

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 a hierarchical tabular format of columns and rows

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

• ERD

• CSV

• DML

• DDL

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

• INSERT

• TRUNCATE

• CREATE

• SELECT

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

• relationship

• row

• column

• foreign key

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

• DISTINCT

• ORDER BY

• WHERE

• FROM

What is represented by the comma-separated list of items following the SELECT command in this example?

• records

• aliases

• columns (attributes)

• table names

Refer to the exhibit. The exhibit shows the structures of the Drivers and Orders data tables for a pizza delivery service. The same driver may deliver multiple orders on an average day. What type of relationship exists between the Drivers table and the Orders table?

• The two tables have a one-to-one relationship because both have DriverID as the primary key.

• There is a one-to-many relationship between the two tables because one driver may have many orders, but an order can have only one driver.

• There is a many-to-many relationship between the two tables because there are many drivers and many orders in the tables.

• There is a one-to-one relationship between the two tables because DriverID is a common identifier for the records in both tables.

Which two SQL statements are used to create and change a database schema? (Choose two.)

• ALTER

• CREATE

• DELETE

• INSERT

• SELECT