CHAPTER 1 (Long Exam)

Question 1

A function of DBMS that involves specifying the data types, structures, and constraints for the data to be stored in the database.

Answer 1

Define

Question 2

The characteristic that allows program-data independence.

Answer 2

Database Abstraction

Question 3

The primary source in a database environment.

Answer 3

database

Question 4

Responsible for acquiring software and hardware resources as needed?

Answer 4

Database Administrators

Question 5

It is a collection of programs that enables users to create an maintain a database.

Answer 5

Database Management System

Question 6

Responsible for choosing appropriate structures to represent and store this data.

Answer 6

Database Designer

Question 7

These are standard types pf queries and updates.

Answer 7

Canned Transactions

Question 8

They determine the requirements of end users, especially naive and parametric end users, and develop specifications for canned transactions that meet these requirements.

Answer 8

System Analysts

Question 9

Persons who design and implement the DBMS modules and interfaces as a software package.

Answer 9

System Designers and Implementer

Question 10

The process of storing the data itself on some storage medium that is controlled by the DBMS.

Answer 10

Construct

Question 11

Responsible for administering the primary and secondary resources in a database environment.

Answer 11

Database Administrators

Question 12

The interface for casual users.

Answer 12

Query Language

Question 13

The system administration personnel who are responsible for the actual running and maintenance of the hardware and software environment for the database system.

Answer 13

Operators and Maintenance Personnel

Question 14

It is a collection of related data.

Answer 14

Database

Question 15

Include engineers, scientists, business analysts, and others who thoroughly familiarize themselves with the facilities of the DBMS so as to implement their applications to meet their complex requirements.

Answer 15

Sophisticated

Question 16

Those who work to maintain the database system environment, but who are not actively interested in the database itself.

Answer 16

Workers behind the Scene

Question 17

The interface for application programmers.

Answer 17

Programming Language

Question 18

Any known facts that can be recorded and which have implicit meaning

Answer 18

Data

Question 19

They maintain personal databases by using ready-made program packages that provide easy to use menu or graphics-based interfaces.

Answer 19

Stand Alone End Users

Question 20

The secondary resource in a database environment.

Answer 20

DBMS and Related Softwares

Question 21

Includes such functions as querying the database to retrieve specific data, updating the database to reflect changes in the mini world, and generating reports from the data.

Answer 21

Manipulate

Question 22

Those people whose jobs involve the day to day use of a large database.

Answer 22

Actors on the Scene

Question 23

This refers to the property wherein the structure of data files is stored in the DBMS catalog separately from the access programs.

Answer 23

Isolation (*)

Question 24

The interface for parametric users.

Answer 24

Forms

Question 25

This will ensure that several users trying to update the same data do so in a controlled manner so that the result of the updates is correct.

Answer 25

Concurrency control

Question 26

The people whose jobs requires access to the database for querying, updating, and generating reports.

Answer 26

End-Users

Question 27

Their main job function revolves around constantly querying and updating the database using canned transactions.

Answer 27

Naive/Parametric

Question 28

Include persons who design and implement tools

Answer 28

Tool Designers

Question 29

The interface for stand-alone users.

Answer 29

Menu Driven Interface

Question 30

Accountable for the problem such as breach of security, or poor system response time.

Answer 30

Database Administrators

Question 31

The software packages that facilitate database system design and use and help improve performance.

Answer 31

Tools

Question 32

They implement the specifications as programs; then they test, debug, document, and maintain these canned transactions

Answer 32

Application Programmers

Question 33

They occasionally access the database, but they may need different information each time.

Answer 33

Casual End-Users

Question 34

Responsible for Identifying the data to be stored in the database.

Answer 34

Database Designer

Question 35

A feature of databases systems dictating that it must happen in its entirety or not at all.

Answer 35

Atomicity

Question 36

A DBMS should provide a security and authorization subsystem, which the DBA uses to create accounts and specify account restrictions.

Answer 36

TRUE

Question 37

Databases cannot be used to provide persistent storage for program objects and data structures.

Answer 37

FALSE Databases can*

Question 38

A database represents some aspect of the real world, sometimes called mini world.

Answer 38

TRUE

Question 39

A fundamental characteristic of the database approach is that the database system contains not only the database itself but also a complete definition or description of the database structure and constraints.

Answer 39

TRUE

Question 40

The backup and recovery subsystem of the DBMS is responsible for recovery.

Answer 40

TRUE

Question 41

A query is a question represented in a way that the DBMS can recognize and process.

Answer 41

TRUE

Question 42

The simplest type of integrity constraint involves specifying a data type for each data item.

Answer 42

TRUE

Question 43

A random assortment of data can be referred to as a database.

Answer 43

FALSE

Question 44

A database typically has many users, each of whom may require only one perspective or view of the database.

Answer 44

FALSE

Question 45

It is the responsibility of database administrators to communicate with all prospective database users, in order to understand their requirements, and to come up with a design that meets these requirements.

Answer 45

FALSE

Question 46

A database is designed, built, and populated with data for a specific purpose.

Answer 46

TRUE

Question 47

A DBMS must have the capability to represent a variety of complex relationships among the data as well as to retrieve and update related data easily and efficiently.

Answer 47

TRUE

Question 48

A database cannot be of any size and of varying complexity.

Answer 48

FALSE

Question 49

A database is a random collection of data with some inherent meaning.

Answer 49

FALSE