INFOMAN

Question 1

The following are components of a database except ________ .

meta data
reports
user data
indexes

Answer 1

reports

Question 2

An application where only one user accesses the database at a given time is an example of a(n) ________.

Answer 2

single-user database application

Question 3

An on-line commercial site such as Amazon.com is an example of a(n) ________

Answer 3

e-commerce database application

Question 4

SQL stands for ______.

Answer 4

STRUCTURED QUERY LANGUAGE

Question 5

The following are functions of a DBMS except ________ .

administrating databases
creating and processing forms
creating databases
processing data

Answer 5

creating and processing forms

Question 6

Helping people keep track of things is the purpose of a(n) ________ .

Answer 6

database

Question 7

An Enterprise Resource Planning application is an example of a(n) ________ .

Answer 7

multiuser database application

Question 8

Which of the following is not considered to be a basic element of an enterprise-class database system?
COBOL programs
Database Applications
Users
DBMS

Answer 8

COBOL programs

Question 9

The DBMS acts as an interface between what two components of an enterprise-class database system?

Answer 9

Database application and the database

Question 10

An organized collection of logically related data is called a _____.

Answer 10

DATABASE

Question 11

What do you call the facts that could be recorded and stored on a database.

Answer 11

DATA

Question 12

Data processed in such a way that it can increase the knowledge of the person who uses it is called what?

Answer 12

INFORMATION

Question 13

Data that describe the properties or characteristics of other data is what?

Answer 13

METADATA

Question 14

A personal PC is an example of multiuser database. [T/F]

Answer 14

False

Question 15

Structured data are data that exist in their original state that is in the format of which they were collected. [T/F]

Answer 15

False

Question 16

Single-user database may support more than one user at a time. [T/F]

Answer 16

False

Question 17

Data warehouse is a specialized database that stores data in a format optimized for decision support. [T/F]

Answer 17

True

Question 18

What do you call a/an collection of related record?

Answer 18

FILE

Question 19

It is a character or group of characters that are alphabetic or numeric that has a specific meaning.

Answer 19

FIELD

Question 20

Data dependence means that access to a file is non-dependent to its structure. [T/F]

Answer 20

False

Question 21

“Islands of information” are organized data collections. [T/F]

Answer 21

False

Question 22

Data redundancy exists when the same data are stored unnecessarily at different places. [T/F]

Answer 22

True

Question 23

In alphabetical order, the 5 components of a database are

Answer 23

Data
Hardware
People
Procedures
Software

Question 24

What are the database career opportunities by level? (singulars only)

Answer 24

DEVELOPER
DESIGNER
ADMINISTRATOR
ANALYST
ARCHITECT
CONSULTANT
SECURITY OFFICER

Question 25

Databases can be classified according to the following except one. the type of data stored where the data are located where data is redundant the degree to which the data are structured the number of users supported the intended data usage none of the above

Answer 25

none of the above

Question 26

Databases evolved from computerized file systems to manual file systems. [T/F]

Answer 26

False

Question 27

Independent files contain redundant data, leading to problems of structural and data dependence. [T/F]

Answer 27

True

Question 28

The DBMS serves as the intermediary between the users and the database. [T/F]

Answer 28

True

Question 29

The DBMS Functions: Check all that are applied. Data Transformation and Presentation Data Dictionary Management Backup and recovery management Data Storage Management Manual files backup Security Management Database communication interfaces Data integrity management Multiuser access control Database access and application programming interfaces

Answer 29

All except Manual Files backup

Question 30

Disadvantages of Database System. Check all that are applied. many career positions needed management complexity & maintaining currency Increased cost & vendor dependence frequent upgrade/replacement cycles

Answer 30

management complexity & maintaining currency Increased cost & vendor dependence frequent upgrade/replacement cycles

Question 31

End users and database designers have the same views and needs for data. [T/F]

Answer 31

False

Question 32

Data modeling is iterative and progressive. [T/F]

Answer 32

True

Question 33

Various degrees of data abstraction help reconcile varying views of same data. [T/F]

Answer 33

True

Question 34

In Chen's notation, relationships are written on top of the line of connectivity. [T/F]

Answer 34

False

Question 35

If the same data is stored unnecessarily in different places, then data redundancy is not present. [T/F]

Answer 35

False

Question 36

Data modeling increases the complexities of database design. [T/F]

Answer 36

False

Question 37

Which model was developed by E.F Codd in the 70s?

Answer 37

Relational Model

Question 38

The following are sources of business rules except: Company managers Policy makers Department Managers Database Designers

Answer 38

Database Designers

Question 39

An invoice contains one or more invoice lines. how many entities should be created?

Answer 39

2

Question 40

In this data model, data and relationships are contained in a single structure known as an object.

Answer 40

Object-Oriented Model

Question 41

´Semantic data model developed in response to increasing complexity of applications

Answer 41

Object/Relational and XML Model

Question 42

It is an abstraction of a real-world object or event and is useful in understanding complexities of the real-world environment.

Answer 42

model

Question 43

_ is anything about which data are to be collected and stored

Answer 43

entity

Question 44

It describes an association among entities.

Answer 44

relationship

Question 45

Descriptions of policies, procedures, or principles within a specific organization.

Answer 45

business rules