Topic 5

The ________ is the structure that contains descriptions of objects such as tables and views created by users.

• SQL

• schema

• catalog

• master view

________ is a set of commands used to control a database, including security.

• DML

• DDL

• DCL

• DPL

________ is a set of commands used to update and query a database.

• DML

• DDL

• DCL

• DPL

DDL is typically used during which phase of the development process?

• Implementation

• Physical design

• Analysis

• Evaluation

The main concept of relational databases was published in 1970 by:

• Itzak Ben-Gan.

• Hoffer.

• Mills.

• E.F.Codd.

Relational databases are heavily based on the mathematical concept of:

• set theory.

• bet theory.

• get theory.

• met theory.

The command for creating a database is:

• CREATE TABLE.

• CREATE VIEW.

• CREATE SCHEMA.

• CREATE AUTHORIZATION.

The command for removing a table is:

• CREATE TABLE.

• REMOVE TABLE.

• DROP TABLE.

• TRUNCATE TABLE.

Any create command may be reversed by using a(n) ________ command.

• undo

• drop

• delete

• unpack

The first in a series of steps to follow when creating a table is to:

• identify columns that must be unique.

• identify each attribute and its characteristics.

• create an index.

• identify columns that must be null.