Brainscape's Knowledge GenomeTM

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


See full index

2nd year, 2nd Sem > DCIT55 (LEC) | Midterms > Flashcards

DCIT55 (LEC) | Midterms Flashcards

1
Q

a high-level function that is responsible for the overall management of data resources in an organization, including maintaining corporate wide definitions and standards

A

data administration (DA)

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

they arethe rules for structuring information collected by the ID system which facilitate semantic interoperability

A

data standards

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

techniques and methods used to handle conflicts that arise when integrating data

A

data conflict resolution (DCR)

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

a collection of related information maintained over a network on various servers

A

information repository (IR)

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

the promotion of a company’s objectives, products, and services to employees within the organization

A

internal marketing (IM)

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

the purpose is to increase employee engagement with the company’s goals and foster brand advocacy

A

internal marketing (IM)

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

a technical function that is responsible for physical database design and for dealing with technical issues, such as security enforcement, database performance and back up and recovery

A

database administration (DBA)

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

it refers toa group of activities DBAs perform to ensure databases operate smoothly and efficiently- hardware & software

A

database performance tuning

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

it involves accelerating query response, improving indexing, deploying clusters, and reconfiguring OSes

A

database performance tuning

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

a process forconceptualizing the relationships between different types of information in an organization

A

enterprise data modeling

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

process of collecting, organizing, analyzing, and applying data to your business strategies

A

marketing data management

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

it establishes the process used to identify, prioritize, precisely formulate, and validate the data needed to achieve business objectives

A

data requirements

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

it describes a problem, system requirements describe the characteristics of system concepts which are potential solutions to the problem

A

operational requirement

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

a collection of metadata such as object name, data type, size, classification, andrelationships with other data assets

A

data dictionary

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

data library or data archive

A

data repository

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

it isthe process of deciding how to arrange the attributes of the entities in a given business environment into database structures

A

logical database design

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

it can have one or more attributes, which are properties or characteristics that describe the entity

A

entity

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

it isthe end user’s view of the data

A

external model

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

a representation of the database as seen by the DBMS

A

internal model

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

it isthe accuracy, completeness, and reliability of data

A

data integrity

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

it isa control that rejects invalid data inputs, prevents unauthorized data outputs, and protects data and programs against accidental or malicious tampering

A

integrity control

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

it isthe process of copying and loading data or data sets from a source file, folder or application to a database or similar application

A

database loading

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

a procedure that allows you to submit project change requests

A

change-control procedure

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

software with source code that anyone can inspect, modify, and enhance

A

open-source software

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

a document that states the rights of the developer and user of a piece ofsoftware (Maria DB, My SQL)

A

software license

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

it is based on the Open SourceChromiumweb browser project

A

google chrome browser

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

The Google Chrome browser is based on the

A

Open SourceChromiumweb browser project

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

it is a free and open-source internet browser that offers numerous plugins which can be accessed with a single mouse click

A

mozilla firefox

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

Data policies, procedures and standards

A

DA

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

Planning

A

DA

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

Data Conflict Resolution

A

DA

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

Managing the Information Repository

A

DA

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

Internal Marketing

A

DA

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

Selecting DBMS and related software tools

A

DBA

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

Installing and upgrading the DBMS

A

DBA

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

Tuning database performance

A

DBA

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

Improving database query processing performance

A

DBA

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

Managing data security, privacy, and integrity

A

DBA

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

Data backup and recovery

A

DBA

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

Develop corporate database strategy/policies

A

DA

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

Develop enterprise model (information architecture)

A

DA

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

Develop cost/benefit models

A

DA

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

Develop database environment/select technologies

A

DA

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

Develop a market data administration plan

A

DA

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

Define and model data requirements (conceptual)

A

DA

46
Q

Define and model business rules

A

DA

47
Q

Define operational requirements

A

DA

48
Q

Resolve requirements conflicts

A

DA

49
Q

Maintain corporate data dictionary/repository

A

DA

50
Q

Perform logical database design

A

DA/DBA

51
Q

Design external model (subschemas)

A

DBA

52
Q

Design internal (physical) models

A

DBA

53
Q

Design integrity controls

A

DBA

54
Q

Establish security controls

A

DBA

55
Q

Supervise database loading

A

DBA

56
Q

Specify test procedures

A

DBA

57
Q

Perform logical database design

A

DBA

58
Q

Develop application programming standards

A

DBA

59
Q

Establish procedures for backup and recovery

A

DBA

60
Q

Conduct user training

A

DBA

61
Q

Backup and Recover Database

A

DBA

62
Q

Upgrade DBMS

A

DBA

63
Q

Monitor database

A

DBA

64
Q

Tune and reorganize databases

A

DBA

65
Q

Resolve access conflict

A

DBA

66
Q

Tune and rewrite queries

A

DBA

67
Q

Enforce standards and procedures

A

DBA

68
Q

Support Users

A

DBA

69
Q

Implement change-control procedures

A

DBA/DA

70
Q

Plan growth and change

A

DBA/DA

71
Q

Evaluate new technology

A

DBA/DA

72
Q

a free DBMS source code software that provides the core functionality of a compliant DBMS

A

Open-source DBMS

73
Q

SQL Data Types

A

numeric
date/time
character/string
binary

74
Q

statements are used for managing data in database

A

data manipulation language (DML)

75
Q

sample of DML commands

A

SELECT, INSERT, UPDATE, and DELETE

76
Q

it retrieves data from database

A

SELECT statement (SELECT column/s FROM tablename;)

77
Q

it inserts data into a table

A

INSERT statement (INSERT INTO tablename (parameters) VALUES (parameters);)

78
Q

it updates existing data within a table

A

UPDATE statement

79
Q

it deletes all records from a database (use where clause to specify deletion)

A

DELETE statement

80
Q

how to display databases

A

show databases;

81
Q

it is the process of reorganizing data in a database so that it meets two basic requirements

A

normalization

82
Q

it happens when you apply for a job and you are tasked to design a database based on Excel files/documents containing data

A

normalization

83
Q

repetitive data and anomalies

A

unnormalized database

84
Q

these are mostly plagued with repetitive data and anomalies

A

normalization

85
Q

relationship between primary key and foreign key

A

ER diagram

86
Q

it is important for many reasons, but chiefly because it allows databases to take up as little disk space as possible, resulting in increased performance

A

normalization

87
Q

it is also known as data normalization

A

normalization

88
Q

data normalization is also known as

A

normalization

89
Q

it usually involves dividing large tables into smaller (less redundant) tables and defining relationships between them

A

data normalization

90
Q

who developed the data normalization

A

E.F. Codd, 1972
(Edgar F. Codd)

91
Q

deleting rows may cause a loss of data that would be needed for future rows

A

deletion anomaly

92
Q

it exists when certain attributes are lost because of the deletion of other attributes

A

delete anomaly

93
Q

adding new rows forces the user to create duplicate data

A

insertion anomaly

94
Q

it occurs when certain attributes cannot be inserted into the database without the presence of other attributes

A

insert anomaly

95
Q

changing data in a row forces changes to other rows because of duplication

A

modification anomaly

96
Q

it exists when one or more instances of duplicated data are updated, but not all

A

update anomaly

97
Q

unique identifier

A

primary key

98
Q

children of the primary key

A

non-key attributes (mga hindi pk)

99
Q

attribute to find out values assigned to other attributes in the same row

A

determinant (this is usually the PK; denoted as capital letters)

100
Q

look to the primary key for reference

A

dependent (other fields aside from PK; denoted as small letters)

101
Q

it is where the relationships between PK and FK is deemed important

A

first normal form (1NF)

102
Q
  • Identify a unique primary key
  • Have just one set of values per column
  • Have just one set of values per cell
  • Eliminate repeating data
A

first normal form (1NF)

103
Q

made of > 1 column

A

composite key

104
Q

non-key that depends on part of the composite key

A

partial dependency

105
Q

composite PK (2 or more PK)

A

composite key

106
Q
  • Is in 1NF
  • Eliminate Partial Dependency
  • Non-Key columns must depend on all keys of the composite key
A

second normal form (2NF)

107
Q

all non-key attributes must be dependent to

A

composite key

108
Q

dependent to only of the PKs

A

partial dependencies

109
Q

non-key attribute that is related or dependent to another non-key attribute

A

transitive relationship

110
Q

still consider the logic

A

logical reasoning

2nd year, 2nd Sem (11 decks)

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