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