IST 272 Test 1 Review

SQL statements that define the tables in a database are referred to as ________________ statements.

• ASCII

• SELECT

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

The three main hardware components of a client/server system are the clients, the server, and the

• data access API

• application

• hard drive

• network

Which of the following recommendations won’t improve the readability of your SQL statements?

• start each clause on a new line

• break long clauses into multiple lines

• use capital letters for all clauses except DDL statements

• indent continued lines

If you define a column with a default value, that value is used whenever a row ___________.

• is added to the table

• with a zero value for that column is added to the table

• that doesn’t include a value for that column is added to the table

• in the table is updated

What uniquely identifies each row in a table?

• cell

• field

• foreign key

• primary key

To retrieve or update the data in a database, the client sends a ________________ to the database.

• ping

• query

• handshake

• transaction request

When a column in a table is defined, what determines the kind of data it can store?

• an index

• a data type

• a relationship

• a primary key

What is the most common type of relationship between two tables?

• many-to-many

• one-to-many

• one-to-few

• one-to-one

The processing that’s done by the DBMS (Database Management System) is typically referred to as:

• back-end processing

• delayed processing

• anytime processing

• front-end processing

Which of the following is not a SQL DML (Data Manipulation Language) statement?

• SELECT

• INSERT

• UPDATE

• CREATE TABLE