data base concepts

Question 1

what is the database

Answer 1

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

Question 2

what is data

Answer 2

is raw facts

Question 3

what is the information

Answer 3

is the result of processing raw data to reveal its meaning

Question 4

what is the data processing

Answer 4

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

Question 5

what is the meaning of timely information

Answer 5

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

Question 6

what timely and useful information requires

Answer 6

accurate date

Question 7

what is the end user data

Answer 7

that is raw facts of interest to the end user

Question 8

what is metadata or data about data

Answer 8

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

Question 9

what is the example of metadata

Answer 9

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

Question 10

what is database management system

Answer 10

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

Question 11

what is query

Answer 11

is a specific request issued to the DBMS for data manipulation

Question 12

what is query result set

Answer 12

the DBMS sends back an answer

Question 13

what is the single user database

Answer 13

supports only one user at a time

Question 14

what is desktop database

Answer 14

is asingle user that run on personal computer

Question 15

what is the multiuser database

Answer 15

supports multiaple users at the same time

Question 16

what is workgroup database

Answer 16

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

Question 17

what is enterprise database

Answer 17

is used by the entire organization and supports many users

Question 18

what is centralized database

Answer 18

database that supports data that located at a single site

Question 19

what is the distributed database

Answer 19

that supports data disrbuted across several diffrent sites

Question 20

what is operational database

Answer 20

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

Question 21

what is the other name of operational database

Answer 21

transactiona or production database

Question 22

what is the data warehouse

Answer 22

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

Question 23

what is the unstructured data

Answer 23

are that exist to their original (raw) cost

Question 24

what is the structured data

Answer 24

are the result of taking unstructured data and formatting

Question 25

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

Answer 25

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

Question 26

what is the semi structured data

Answer 26

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

Question 27

what is extensible markup language (xml )

Answer 27

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

Question 28

what is the database design

Answer 28

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

Question 29

what is the decomposition

Answer 29

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

Question 30

what is the data independence

Answer 30

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

Question 31

what is logical data format

Answer 31

how the human being views the data

Question 32

physical data format

Answer 32

how the computer must work with the data

Question 33

what is the data redundancy

Answer 33

exists when the same data are stored unnecessarily at different places

Question 34

what is data modeling

Answer 34

is the most common method of documenting database designs

Question 35

what is the "logical" label reflect

Answer 35

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

Question 36

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

Answer 36

the database management system

Question 37

what is the database system composed

Answer 37

hardware software people procedures data

Question 38

what is the software are needed

Answer 38

operating system | dbms and application and utilities

Question 39

what is application programs

Answer 39

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

Question 40

what is the utilities

Answer 40

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

Question 41

what is the system administrators

Answer 41

oversee the database system general operations

Question 42

what is the database administrators

Answer 42

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

Question 43

what is the database designers

Answer 43

design the database structure

Question 44

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

Answer 44

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

Question 45

what is the procedures

Answer 45

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

Question 46

what is the data dictionary

Answer 46

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

Question 47

what is the performance tuning

Answer 47

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