Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

2nd Year > INFOMAN > Flashcards

INFOMAN Flashcards

1
Q

The following are components of a database except ________ .

meta data
reports
user data
indexes

A

reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

single-user database application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

e-commerce database application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

SQL stands for ______.

A

STRUCTURED QUERY LANGUAGE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The following are functions of a DBMS except ________ .

administrating databases
creating and processing forms
creating databases
processing data

A

creating and processing forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

multiuser database application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

COBOL programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Database application and the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

DATABASE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

DATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

INFORMATION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

METADATA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

FILE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

FIELD

20
Q

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

A

False

21
Q

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

A

False

22
Q

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

A

True

23
Q

In alphabetical order, the 5 components of a database are

A

Data
Hardware
People
Procedures
Software

24
Q

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

A

DEVELOPER
DESIGNER
ADMINISTRATOR
ANALYST
ARCHITECT
CONSULTANT
SECURITY OFFICER

25
Q

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

A

none of the above

26
Q

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

A

False

27
Q

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

A

True

28
Q

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

A

True

29
Q

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

A

All except Manual Files backup

30
Q

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

A

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

31
Q

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

A

False

32
Q

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

A

True

33
Q

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

A

True

34
Q

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

A

False

35
Q

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

A

False

36
Q

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

A

False

37
Q

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

A

Relational Model

38
Q

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

A

Database Designers

39
Q

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

A

2

40
Q

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

A

Object-Oriented Model

41
Q

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

A

Object/Relational and XML Model

42
Q

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

A

model

43
Q

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

A

entity

44
Q

It describes an association among entities.

A

relationship

45
Q

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

A

business rules

2nd Year (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions