Brainscape's Knowledge GenomeTM

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


See full index

database > data base concepts > Flashcards

data base concepts Flashcards

1
Q

what is the database

A

the ability to store access and change data quickly and easily on low cost computers

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

what is data

A

is raw facts

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

what is the information

A

is the result of processing raw data to reveal its meaning

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

what is the data processing

A

can be as simple as organizing data to reveal patterns or as complex as making forecasts or drawing inferences

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

what is the meaning of timely information

A

distributing information sufficiently far in advance so the interested public has enough time to review relevant material

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

what timely and useful information requires

A

accurate date

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

what is the end user data

A

that is raw facts of interest to the end user

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

what is metadata or data about data

A

provide a description of the data characteristics and the set of relationships that links the data found within the database

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

what is the example of metadata

A

the name of each element and the type of the values (numeric,data ,text )

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

what is database management system

A

is a collection of programs that manages the database structure and controls access to the data stored in the database
it serves as the intermediary between the user and the database

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

what is query

A

is a specific request issued to the DBMS for data manipulation

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

what is query result set

A

the DBMS sends back an answer

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

what is the single user database

A

supports only one user at a time

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

what is desktop database

A

is asingle user that run on personal computer

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

what is the multiuser database

A

supports multiaple users at the same time

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

what is workgroup database

A

multi user supports small number less than 50 or a specific department in org

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

what is enterprise database

A

is used by the entire organization and supports many users

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

what is centralized database

A

database that supports data that located at a single site

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

what is the distributed database

A

that supports data disrbuted across several diffrent sites

20
Q

what is operational database

A

adatabase that is designed primirly to support a company day to day operations

21
Q

what is the other name of operational database

A

transactiona or production database

22
Q

what is the data warehouse

A

storing data used to generate information required to make tactical or strategic descions

23
Q

what is the unstructured data

A

are that exist to their original (raw) cost

24
Q

what is the structured data

A

are the result of taking unstructured data and formatting

25
Q

ممكن ال معلومه يتعملها processing من ناحيه ومن ناحيه تاني لا

A

مثال صفحه الفقره اللي في النص اخر اربع سطور17

26
Q

what is the semi structured data

A

the data are presented to you in prearranged format to convey some information

27
Q

what is extensible markup language (xml )

A

is a special language used to represent and manipulate data elements in a textual format supports the storge and management of semi structured xml data

28
Q

what is the database design

A

refers to the activities that focus on the design of database structure that will be used to store and manage end-user data

29
Q

what is the decomposition

A

designing appropriate data repositories of integrated information using the two-dimensional table structures found in most databases

30
Q

what is the data independence

A

exists when it is possible to make changes in the data storage characteristics without affecting the application program ability to access the data

31
Q

what is logical data format

A

how the human being views the data

32
Q

physical data format

A

how the computer must work with the data

33
Q

what is the data redundancy

A

exists when the same data are stored unnecessarily at different places

34
Q

what is data modeling

A

is the most common method of documenting database designs

35
Q

what is the “logical” label reflect

A

reflect the fact that although the data repository appear to be single unit to the end user its contents may actually be physically distributed among multiple data storge facilities

36
Q

what is the tool that refer to the heart of the database

A

the database management system

37
Q

what is the database system composed

A

hardware software people procedures data

38
Q

what is the software are needed

A

operating system

dbms and application and utilities

39
Q

what is application programs

A

are most commonly used to access data found within the database to generate reports tabulations and other information to facilitate decision making

40
Q

what is the utilities

A

are the software tools used to help manage the database system computer components

41
Q

what is the system administrators

A

oversee the database system general operations

42
Q

what is the database administrators

A

DBAs

manage the database management and ensure that the database is functioning properly

43
Q

what is the database designers

A

design the database structure

44
Q

what the system analyst and programmers design and implement the application programs

A

they design and create the data entry screens and reports and procedures through which end users access and manipulate the database data

45
Q

what is the procedures

A

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

46
Q

what is the data dictionary

A

the DBMS stores definitions of the data elements and their relationships (metadata ) in data dictionary

47
Q

what is the performance tuning

A

relates to the activities that make the database perform more efficiently in terms of storge and access speed

database (4 decks)

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