chp1

Question 1

A collection of related data.

Answer 1

Database

Question 2

Known facts that can be recorded and have an implicit meaning.

Answer 2

Data

Question 3

Traditional databases?

Answer 3

Numeric and Textual databases

Question 4

Some part of the real world about which data is stored in a database

Answer 4

Mini world

Question 5

T/F (Database System) is a software package to facilitate the creation and maintenance of a computerized database

Answer 5

False. Database management system DBMS

Question 6

The DBMS software together with the data itself

Answer 6

Database system

Question 7

Applications interact with a DB by generating ……. and ……..

Answer 7

Queries and transactions

Question 8

used to hide storage details and present the users with conceptual view of the DB

Answer 8

Data abstraction ( data model )

Question 8

T/F
the self describing nature of a database system allows the DBMS software to work with different DB applications

Answer 8

TRUE

Question 8

T/F
DBMS may provide security to prevent unauthorized access

Answer 8

TRUE

Question 9

T/F
program-data independence does NOT allow changing data structure without having to change the DBMS access programs

Answer 9

FALSE, it allows it

Question 10

T/F
the Database approach supports multiple views of the data?

Answer 10

TRUE, each user may see a different view of the DB

Question 11

Guarantees that each transaction is correctly executed or aborted?

Answer 11

Concurrency control

Question 12

T/F
Online Transaction Processing OLTP is a major part of the DB applications

Answer 12

TRUE

Question 13

Allows hundreds of concurrent transactions to execute per second

Answer 13

OLTP

Question 14

T/F
Those who develop the DBMS software are called Actors on the Scene

Answer 14

FALSE, “Workers behind the Scene”

Question 15

Those who design, develop, and maintain DB applications

Answer 15

Actors on the Scene

Question 16

Database designers are example of

Answer 16

Actors on the scene

Question 17

responsible for authorizing access to the DB, monitoring it, acquiring hardware and software

Answer 17

Database Administrators

Question 18

responsible to define the content, structure, constraints, and functions against the DB. must communicate with end user

Answer 18

Database Designers

Question 19

Uses the data for queries, reports, and may update the database content

Answer 19

END USER

Question 20

(casual, parametric) users make up a large section of the end user population

Answer 20

parametric (naive)

Question 21

………. uses previously well defined functions in the form of canned transactions

Answer 21

parametric or naive users

Question 22

includes business analysts, scientists, engineers

Answer 22

sophisticated users

Question 23

mostly maintain personal DB using ready to use apps

Answer 23

Stand alone users

Question 24

T/F no DBMS may suffice if the database system is not able to handle the complexity of data because of modeling limitations

Answer 24

TRUE

Question 24

T/F a DBMS may be unnecessary if the access to data by multiple users is required

Answer 24

FALSE, when the access by multiple users is NOT required.

Question 25

T/F A DBMS may be unnecessary if the database and applications are well defined and simple

Answer 25

TRUE

Question 25

T/F (Insulation between programs and data) in Database approach allows the DBMS software to work with different database applications

Answer 25

FALSE, the self-describing nature of a database system allows that.

Question 26

T/F Traditional DBMS are suitable for real-time databases

Answer 26

FALSE. Only numeric and textual databases.

Question 27

T/F DB administrators are responsible for security breaches and poor response time

Answer 27

TRUE

Question 28

T/F A transaction is a logical unit of a database that needs to be aborted or committed

Answer 28

TRUE

Question 29

What is the impact of program-data independence?

Answer 29

it eliminates the need to change the DBMS access programs when altering data structures or storage organization

Question 30

T/F Embedding the structure of data files in the application programs is an advantage of using database approach

Answer 30

FALSE. it is NOT an advantage.