IM 101 Flashcards

1
Q

evolved from computer file systems. Understanding file
system characteristics is important.

A

Databases

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

Used in almost all modern settings involving data management:

A
  • Business
  • Research
  • Administration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The difference between data and information.

A

Data are raw facts. Information is processed data to reveal the meaning behind the facts.

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

a discipline that focuses on the proper generation, storage, and retrieval
of data.

A

Data Management

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

Data Hierarchy

A

Bit>Byte>Field>Record>File>Database

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

shared, integrated computer structure that stores a collection of end-user data and Metadata.

A

Database

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

raw facts of interest to end user

A

End-user data

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

data about data
* Provides description of data characteristics and relationships in data
* Complements and expands value of data

A

Metadata

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

Number of users

A

Single-user:
Desktop
Multi-user
Workgroup
Enterprise

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

Supports only one user at a time.

A

Single User

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

Single-user database running on a personal computer.

A

Desktop

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

Supports multiple users at the same time.

A

Multi-user

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

Multi-user database that supports a small group of users or a single
department.

A

Workgroup

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

Multi-user database that supports a large group of users or an entire
organization.

A

Enterprise

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

Database site location

A

Centralized
Distributed

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

Supports data located at a single site.

A

Centralized

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

Supports data distributed across several sites.

A

Distributed

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

Type of data

A

General Purpose
Discipline-Specific

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

Supports a company’s day-to-day
operations.

A

Transactional (production) database (OLTP)

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

Stores data used to generate information required
to make tactical or strategic decisions. Often used to store historical data structure is quite
different.

A

Data warehouse database (OLAP)

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

Each data item in a tree is called a node. Degree of a Node:
The degree of a node of a tree is the number of subtrees having this node as a root. In
other words, the degree is the number of descendants of a node. If the degree is zero, it
is called a terminal or leaf node of a tree.

A

Degree of data structure

22
Q

Data whose elements are addressable for
effective analysis. It has been organized into a formatted repository that is typically a
database. It concerns all data which can be stored in database SQL in a table with rows
and columns.

A

Structured data

23
Q

data is information that does not reside in a
relational database but that has some organizational properties that make it easier to
analyze.

A

Semi-structured data

24
Q

data which is not organized in a
predefined manner or does not have a predefined data model, thus it is not a good fit
for a mainstream relational database.

A

Unstructured data

25
Q

stores and organizes data and can be thought of as a type of index for all the data
contained in a storage device. These devices can include hard drives, optical drives and flash
drives.

A

File System

26
Q

stored separately from the contents of the file, with many file systems storing the file
names in separate directory entries.

A

Metadata

27
Q

supported by the Microsoft Windows OS. FAT is considered simple
and reliable, and it is modeled after legacy file systems. FAT was designed in 1977 for floppy
disks, but was later adapted for hard disks. While efficient and compatible with most current
OSes, FAT cannot match the performance and scalability of more modern file systems.

A

File Allocation Table(FAT)

28
Q

a file system for the Linux OS, and it is a shared disk file system.
GFS offers direct access to shared block storage and can be used as a local file system.

A

Global file system (GFS)

29
Q

developed for use with Mac operating systems. HFS can
also be referred to as Mac OS Standard, and it was succeeded by Mac OS Extended. Originally
introduced in 1985 for floppy and hard disks, HFS replaced the original Macintosh file system. It
can also be used on CD-ROMs.

A

Hierarchical file system (HFS)

30
Q

the default
file system for Windows products from Windows NT 3.1 OS onward.

A

NT file system / New Technology File System (NTFS)

31
Q

a vendor-neutral file system used on optical media and DVDs.
UDF replaces the ISO 9660 file system and is the official file system for DVD video and audio as
chosen by the DVD Forum.

A

Universal Disk Format (UDF)

32
Q

creates and defines the restraints for a database.

A

Database management system (DBMS)

33
Q

It requires that each transaction be “all or nothing“. If one part of the
transaction fails, the entire transaction fails, and the database state is left unchanged. On
the other hand, if one part of the transaction is successful, then it should be reflected in
the database.

A

Atomicity.

34
Q

The consistency property ensures that any transaction will bring the
database from one valid state to another.

A

Consistency

35
Q

It ensures that the concurrent execution of transactions result in a system state
that would be obtained if transactions were executed serially, one after the other.

A

Isolation

36
Q

This means that once a transaction has been committed, it will remain so, even
in the event of power loss, crashes, or errors.

A

Durability

37
Q

defines and regulates the collection, storage, management, and use of data.

A

Database System

38
Q

It is refers to all the database system’s physical devices.

A

Hardware

39
Q

It refers to the components that are needed to make the database function
fully.

A

Software

40
Q

It manages all hardware components and makes it
possible for all other software to run on the computers. (e.g. Microsoft
Windows, Linux, Mac OS)

A

Operating System

41
Q

It manages the database within the database system. (e.g.
Microsoft SQL Server, Oracle, MySQL)

A

DBMS Software

42
Q

They are used to access and
manipulate data in the DBMS and to manage the computer environment in
which data access and manipulation take place. (e.g. Adobe Dreamweaver,
Microsoft Visual Studio, WAMPServer, XAMPP and Laragon)

A

Application Programs and Utility Software

43
Q

This component includes all users of the database system. On the basis of job
functions

A

Users

44
Q

They oversee the database system’s general
operations.

A

System Administrators

45
Q

Also known as DBAs, they manage the DBMS and
ensure that the database is functioning properly to avoid system glitches in the
future.

A

Database Administrators

46
Q

They simply design the database structure that will
dictate the usefulness and effectiveness of the database environment that these
people will develop

A

Database Designers

47
Q

They design and implement the
application programs. They also design and create the data – entry screens,
reports, and procedures through which end – users access and manipulate the
database’s data.

A

Systems Analysts and Programmers

48
Q

These are the people who use the application programs to run
the organization’s daily operations.

A

End – users

49
Q

These are the instructions and rules that govern the design and use of
the database system.

A

Producers

50
Q

This refers to the collection of facts stored in the database. Because data are
the raw material from which information is gathered, determining what data to enter
into the database and how to organize those data is a vital part of the database
designer’s job.

A

Data

51
Q
A