MySQL Chapter 1 & 2 Quiz
Each database includes tables, views, and routines. These are called database _______________
objects
The most common type of relationship between two tables is a ______________________ relationship
one-to-many
A __________ uniquely identifies each row in a table
primary key
To retrieve or update the data in a database, the client sends a ___________ to the database
query
A ____________ statement is used to retrieve selected columns and rows from a base table
select
The database server can also be referred to as the database ______________
service
To save your own code in MySQL Workbench so that you do not have to type it each time, you can create a new _______________
snippet
A relational database consists of one or more
tables
if you define a column with a default value, that value is used whenever a row
that doesn't include a value for that column is added to the table
What is not a common error when entering and executing SQL statements?
Forgetting to connect to a database
What is a command-line tool that you can use for running SQL statements?
MySQL Command Line Client
In MySQL Workbench, you can start or stop the MySQL database server by clicking the Start Server button in the _____________ window
Navigator
What will not improve the readability of your SQL statements
Using comments to describe what each statement does
What are the three main hardware components of a client/server system?
clients server network
The MySQL Reference Manual can be found at the _________ website
dev.mysql.com
A ___________ diagram can be used to show how the tables in a database are defined and related
entity relationship (ER) enhanced entity relationship (ERR) entity-relationship
You can use the SQL Editor tab to enter and _____________ one or more SQL statements
execute or run
To relate one table to another, a _____ in one table is used to point to the primary key in another table
foreign key
Surrogate key
generated by the database to create a unique primary key. (surrogate = substitute)
SQL statements that define the tables in a database are referred to as ________________ statements
DDL
What are somethings that could improve the readability or your SQL statements?
Breaking long clauses into multiple lines. Starting each clause on a new line Indenting continued lines
T/F you can create a database diagram in the editor tab of MySQL Workbench
False
A SQL script is a file that contains one or more ________________
SQL statements
The result of a SELECT statement is
a result set
The processing that's done by the DBMS is typically referred to as...
back-end processing
composite key
composed of multiple columns
Before you can use MySQL Workbench to work with a SQL database, you need to open a ____________to the database
connection
When you have access to a table through MySQL Workbench, you can view both the column definitions for the table and the _______ in the table
data
A database driver is software that lets the ___________________
data access model communicate with the database
The type of operation that retrieves data from two or more tables is called a ....
join
candidate key
key that you are considering for primary key
When a column in a table is defined, it is given a data ____________ that determines what kind of data it can store
type
Natural key
what people use to look things up. (like social, email, etc.) then we can find out the surrogate key.
