CIT111 ch 1/2 quiz
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
The interface between an application program and the dbms is usually provided by the
Data access api
To communicate between the client and the server you use a —— which is dependent on the pro he am language you are ysing
Data access api
What is not a common error when entering and executing sql statements?
Forgetting to connect to a database
The MySQL Reference Manual can be found at the _______________ web site.
MySQL
—— is a command-line tool that you can use for running sq statements
MySQL command line client
The three main hardware components of a client/server system are the clients, the server, and the __________________________________.
Network
Each database includes tables, views, and routines. These are called database ____________________.
Objects
Most common type of relationship between two tables is a —— relationship
One-to-many
A —— uniquely identifies each row in a table
Primary key
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
To retrieve or update the data in a database, the client sends a/an _____________________ to the database.
Query
To save you own code in MySQL workbench so that you do not have to type it each time, you can create a new ...
Snippet
A SQL script is a file that contains one or more ___________________.
Statements
A relational database consists of one or more —— that contain data that can be joined via a common key
Tables
You can use the SQL Editor tab to enter and ______________________ one or more SQL statements.
execute
Which statement does not modify the data in a table?
Select
Before you can use MySQL workbench to work with a sql database you need to open a —— to the database
Connection
In a sql editor tab of MySQL workbench you can do all but ehay
Create a database diagram
Which of the following statements is not a DML statement?
Create table
SQL statements that define the tables in a database are referred to as —— statements
DDL
Sql statements that define tables in a database are referred to as —— statements
DDL
When you have access to a table, you can view both the column definitions and the —— in the table
Data
The result of a select statement is
A result set
The processing that done by the dbms is typically referred to as
Back-end processing
Which will improve readability of sql statements?
Break long clauses, start each clause new line, indent continued lines
The database sever can also be referred to as the database ...
Engine
A —— diagram can be used to show how the tables in a database are defined and relayed
Enhanced entity relationship
To relate one table to another, a —— in one table is used to point to the primary key in anohher
Foreign key
When you run a SQL statement that contains a coding error, MySQL Workbench displays an error message that does not include
The likely cause of the error
Which of the following is not true when using MySQL workbench to test a script that contains more than one statement?
You cannot run all the statements at once
The intersection of a row and a column is called a _____.
cell
The type of operation that retrieves data from two or more tables is called a __________________.
join
In MySQL Workbench, you can start or stop the MySQL database server by clicking the Start Server button in the _______________________ window.
navigator
When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.
type
