Brainscape's Knowledge GenomeTM

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


See full index

Prelims > ITEC36 (Sir Noel) > Flashcards

ITEC36 (Sir Noel) Flashcards

1
Q

known facts that can be recorded and have an implicit meaning

A

Data

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

it is a processed data by a computer to become more useful

A

Information

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

it is a collection of related data

A

Database

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

it is a collection of programs which enables its users to access database, manipulate data, reporting and representaion of data

A

Database Management System

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

it is an organized collection of structured infromation, or data, typically stored electronically in a computer system

A

Database

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

it access different parts of data and formulate the result of a request presentation and visualization of data

A

Queries

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

that may read some data and “update” certain values or generate new data and store that in the database

A

Transactions

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

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

A

Data Model

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

refer to the data model constructs rather than data storage details

A

program

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 Database

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

supports multiple users at the same time

A

MultiUser Database

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

Database can be classified according to:

A

Number of Users
Database Location
Expected Type and Extent of Use

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

Data distributed across several different site

A

Distributed Database

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

database is located at a single site

A

Centralized Database

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

database is located within more than one site

A

Decentralized Database

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

stores data used for tactical or strategic decision

A

Data Warehouse

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

supports a companies day to day operations

A

Operational Database

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

are the ones who really use and take the benefits of the database

A

Database User

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

Users may be divided into:

A

Actors on the scene
Workers behind the scene

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

Responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software and hardware resources, controlling its use and monitoring effieciency of operations

A

Database Administrators

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

Responsible to define the content, the structure, the constraints, and functions
ot transactions against the database. They must communicate with the end users and understand their needs.

A

Database Designers

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

access database occasionally when needed

A

Casual

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

they use the data for queries, reports and some of them update the database content.

A

End Users

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

they make up a large section of the end user population

A

Naive

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

These include business analysts, scientists, engineers, others thoroughly familiar with the system capabilities.

A

Sophisticated

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

Mostly maintain personal databases using ready-to-use packaged applications

A

Stand Alone

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

They understand the user requirements of naïve and sophisticated users and design applications including canned transactions to meet those requirements.

A

System Analysts

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

Implement the specifications developed by analysts and test and debug them before deployment.

A

Application Programmers

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

There is an increasing need for such people who can analyze vast amounts of business data and real-time data (“Big Data”) for better decision making related to planning, advertising, marketing etc.

A

Business Analysts

30
Q

Design and implement DBMS packages in the form of modules and interfaces and test and debug them.

A

System Designers and Implementors

31
Q

Design and implement software systems called tools for modeling and designing databases, performance monitoring, prototyping, test data generation, user interface creation, simulation etc. that facilitate building of applications and allow using database effectively.

A

Tool Developers

32
Q

They manage the actual running and maintenance of the database system hardware and software environment.

A

Operators and Maintenance Personnel

33
Q

5 Advantage of database

A

Data Independence
Data Consistency
Controlled Redundancy
Data Integrity
Data Security

34
Q

Database structure may evolve as new
requirements are defined.

A

Flexibility to change data structures

35
Q

Extremely important for on-line
transaction systems such as shopping,
airline, hotel, car reservations

A

Availability of current information

36
Q

Wasteful overlap of resources
and personnel can be avoided
by consolidating data and
applications across departments.

A

Economies of scale

37
Q

were introduced in
late 1980s and early 1990s to
cater to the need of complex
data processing in CAD and
other applications.

A

Object-Oriented Database Management Systems
(OODBMSs)

38
Q

was originally
introduced in 1970, was heavily
researched and experimented
within IBM Research and several
universities.

A

Relational model

39
Q

contains data in HTML
(Hypertext markup language)
with links among pages

A

Web

40
Q

A single unit of logic or
work, sometimes made up of multiple operations.

A

Transaction

41
Q

is a major
part of database applications; allows hundreds of
concurrent transactions to execute per second.

A

OLTP (Online Transaction Processing)

42
Q

Those who actually use
and control the database content, and those who
design, develop and maintain database applications

A

“Actors on the Scene”

43
Q

Those who
design and develop the DBMS software and related
tools, and the computer systems operators

A

“Workers Behind the Scene”

44
Q

is a vital concept in
a database. Only users authorized must be
allowed to access the database and their
identity must be authenticated using
username and password. Unauthorized users
shouldn’t be allowed to access the database
under any circumstances as its violets the
integrity constraints

A

Data Security

45
Q

is defined as the storing of the
same data in multiple locations.

A

Data redundancy

46
Q

is the process of organizing data
in a database. This includes creating tables and
establishing relationships between those tables
according to rules designed both to protect the
data and to make the database more flexible by
eliminating redundancy and inconsistent
dependency.

A

Normalization

47
Q

Providing storage structures for
efficient query processing

A

indexes

48
Q

is the module responsible for
executing database queries.

A

query processor

49
Q

is the process of selecting an
efficient execution plan for evaluating the query.

A

Query optimization

50
Q

describe the process of
creating and storing copies of data that can be
used to protect organizations against data loss.

A

Backup and recovery

51
Q

refers to an interactive
system that provides access to information and
services using different computing platforms.

A

Multiple-User Interface (MUI)

52
Q

refers to the correctness and
completeness of data within a database.

A

Data integrity

53
Q

is defined as a property of DBMS that helps
you to change the Database schema at one
level of a database system without requiring
to change the schema at the next higher level.

A

Data Independence

54
Q

in database
systems refers to the requirement that any
given database transaction must change
affected data only in allowed ways.

A

Data Consistency

55
Q

occurs in database systems which have a field
that is repeated in two or more tables. …
Database normalization prevents redundancy
and makes the best possible usage of
storage.)

A

Controlled Redundancy

56
Q

is the
oldest type of the data model. It
was developed by IBM in 1968. It organizes data in the tree-like
structure

A

Hierarchical data model

57
Q

It is the
advance version of the hierarchical
data model. To organize data it uses
directed graphs instead of the treestructure.

A

Network Data Model

58
Q

is
a database management system that
supports the creation and modeling of
data as objects.

A

object-oriented database
management system

59
Q

it is referred to as parent table.

A

Table

60
Q

it is referred to as child table.

A

Related Table

61
Q

indicates that there can be only one
matching record in that table

A

Number 1

62
Q

indicates that many records can
include the same ID; may appear more than
once

A

The ∞ symbol

63
Q

When each item in each table only appears
at once.

A

One-To-One (1-1)

64
Q

When one item in one table can have a
relationship to multiple items in another
table.

A

One-To-Many (1-∞)

65
Q

When one or more items in one table can
have a relationship to one or more items in
another table.

A

Many-To-Many (∞-∞)

66
Q

To prevent invalid data and to keep
references in sync across table relationship

A

Enforce Referential Integrity

67
Q

To make sure that data in related Fields is
updated in all related Tables.

A

Cascade Update Related Fields

68
Q

The decision to select this depends on
whether you need to retain records in some
tables even though they right be deleted
from other tables.
It is optionally checked in MS Access

A

Cascade Delete Related Records

69
Q

supports a small
number / a small group of users

A

Workgroup Database

70
Q

supports a large
number / large number of users (more
than one building, multiple buildings,
wide area network) 2 or more system

A

Enterprise Database

Prelims (4 decks)

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