Midterm Quiz (Information Management)

Collection of letters, numbers, or facts

• Data

• Information

• Database

• SQL

A standard language for accessing and manipulating databases.

• Access

• DBMS

• SQL

• Database

A repository of data

• Access

• DBMS

• SQL

• Database

Software system that manages databases

• Access

• DBMS

• SQL

• Database

Which statement is not true: DBMS provides users with several facilities to perform a variety

• Add new information

• Delete existing information

• Update existing information

• Update non existing information

Provides interface between data stored in database and application programs and queries

• DDL COMPILER

• DATABASE MANAGER

• QUERY PROCESSOR

• DML PRECOMPILER

Converts DDL statement to a set of tables metadata or data about data.

• DDL COMPILER

• DATABASE MANAGER

• QUERY PROCESSOR

• DML PRECOMPILER

Translate statements in query language

• DDL COMPILER

• DATABASE MANAGER

• QUERY PROCESSOR

• DML PRECOMPILER

Network database can handle __________ relationships. Means that owners can have multiple members and members can have multiple owners.

• One-to-one

• One-to-many

• Many-to-many

• Zero-to-many

The hierarchical model makes use of the one-to-one or one-to-many entity relationships. In this type of database, data is grouped into segments resembling a tree structure.

• one-to-one

• one-to-many

• many-to-many

• zero-to-many