PRELIM

Question 1

Allows user to design a report on screen, retrieve data into report design, then display or print reports.

Answer 1

report generator

Question 2

Contains data about each file in database and each field within those files.

Answer 2

data dictionary

Question 3

DBMS uses log to undo any changes made to database during a certain period of time.

Answer 3

rollback

Question 4

A listing of activities that change database contents.

Answer 4

log

Question 5

A copy of the entire database.

Answer 5

backup

Question 6

It determines whether number is within specified range.

Answer 6

range check

Question 7

Acronym: SQL

Answer 7

structured query language

Question 7

Acronym: DBA

Answer 7

database administrator

Question 8

Procedures that keep data current.

Answer 8

file maintenance

Question 8

Collection of data organized so you can access, retrieve, and use it.

Answer 8

database

Question 9

Huge database system that stores and manages data required to analyze historical and current transactions.

Answer 9

data warehouse

Question 10

Combination of one or more characters and the smallest unit of data user accesses.

Answer 10

field

Question 10

Degree to which data is correct.

Answer 10

data integrity

Question 11

Window on screen that provides areas for entering or changing data in database.

Answer 11

form

Question 11

Acronym: GIGO

Answer 11

garbage in garbage out

Question 11

Collection of related records stored on disk.

Answer 11

data file

Question 12

Acronym: DBMS

Answer 12

database management system

Question 13

Acronym: DA

Answer 13

database analyst

Question 14

Process of comparing data with a set of rules to find out if data is correct.

Answer 14

validation

Question 15

Data that is organized and meaningful.

Answer 15

information

Question 16

Software system to define, construct, and manipulate databases.

Answer 16

DBMS (Database Management System)

Question 17

Simple text files.
Stores data in a single table.

Answer 17

Flat File Databases

Question 17

Complex databases.
Stores information across multiple tables.

Answer 17

Relational Databases

Question 18

Optimizing storage and data retrieval.

Answer 18

Efficiency:

Question 19

DBMS Key Features

Answer 19

Structured Data: Well-organized data storage. Query Language: Retrieve specific data using queries. Multi-User Access: Allows multiple users to access data simultaneously. Data Dictionary: Describes database structure, fields, etc Data Abstraction: Levels include: External: User’s view. Conceptual: Organization-wide view. Internal: Physical storage detailsDBMS Key Features

Question 19

Objectives of Database

Answer 19

Efficiency: Optimizing storage and data retrieval. Integrity: Ensuring accuracy and consistency of data. Privacy: Controlling access to sensitive information. Security: Protecting data from unauthorized users. Flexibility: Ability to handle various data structures and changes.

Question 20

Types of Data Structures

Answer 20

Hierarchical Model Network Model Relational Model

Question 20

Organizes data in a tree-like structure. Parent-child relationships (1).

Answer 20

Hierarchical Model

Question 21

Records can have multiple parent and child records.

Answer 21

Network Model

Question 22

Data stored in tables. Tables contain rows (tuples) and columns (attributes).

Answer 22

Relational Mode

Question 23

Relational Terminologies

Answer 23

Domain Attribute Tuple

Question 24

Name of a role played by a domain in a relation.

Answer 24

Attribute

Question 25

Set of atomic values for an attribute

Answer 25

Domain

Question 26

A set of related data values (row).

Answer 26

Tuple

Question 27

Raw facts.

Answer 27

Data

Question 28

The Hierarchy of Data

Answer 28

Characters Fields Records Files

Question 29

Smallest unit of data.

Answer 29

Characters

Question 30

A combination of characters (e.g., name, ID).

Answer 30

Fields

Question 31

Group of related fields.

Answer 31

Records

Question 32

Collection of related records.

Answer 32

Files

Question 33

Common Data Types

Answer 33

Text Numeric Currency Date Boolean BLOB

Question 34

Letters, numbers, special characters.

Answer 34

Text

Question 35

Numbers only.

Answer 35

Numeric

Question 36

Dollar/cent amounts.

Answer 36

Currency

Question 37

Date and time.

Answer 37

Date

Question 38

Yes/No or True/False.

Answer 38

Boolean

Question 39

Binary Large Object (e.g., images, videos).

Answer 39

BLOB

Question 40

Data stored in isolated files. Leads to data redundancy.

Answer 40

File Processing System

Question 41

Data is shared across users and applications.

Answer 41

Database Approach

Question 42

Input new data.

Answer 42

Adding Records

Question 42

Maintaining Data

Answer 42

Adding Records Changing Records Deleting Records Validation

Question 43

Remove unnecessary data.

Answer 43

Deleting Records

Question 44

Modify existing data.

Answer 44

Changing Records

Question 45

Focuses on the meaning and usage of data.

Answer 45

Database Analyst (DA)

Question 45

Disadvantages of DBMS

Answer 45

Complexity and Cost Size and Resource Requirements Risk of System Failure Security Concerns

Question 45

Advantages of DBMS

Answer 45

Data Integrity Data Security Data Independence Concurrent Access and Transactions Data Redundancy Reduction Data Query and Retrieval

Question 46

Manages security, performance, and backup/recovery procedures.

Answer 46

Database Administrator (DBA)