CSC351-Midterm Questions and Answers
1. Databases make data: persistent and shareable in a secure way
2. What is a database?: A share, integrated compuer structure that stores data
3. Databases are specialized structures that allow computer-based systems to: store, manage,
and retreive data quickly
4. Data constist of: raw facts
5. Informtion results from: processing raw facts to reveal meaning
6. Raw facts are the: building blocks of info
7. DBMS stands for: Database Managment system
8. DBMS is a: collection of programs
manages the database structure
Controsl access to data stored in database
9. DBMS allows intermediary between user and database: enables data to be shared
Improves sharing and security
10.Examples of DBMS: MySQL, Oracle, MS Access, Mongo DB
11.Databases can be classifed by number of users: single, multiple
12.:
13.Databases can be classifed by location: centralized-data located at single site,
distrubuted-data distubuted acorss diff sties
, cloud- database maintain and created using cloud data services
14.databses can be classifed by data type: general purpose-contains a wide variety of data
used in multiple displines
displine specific- contains data focused on spefic subhect area
15.databases can be classified by how muhc they are used: operational data- base- support co.
day to day operaitons (online transcation processing OLTP)
Anayltical database- stores histroical data
(OLAP- online anayltical processing)
16.if databases are poorly design: causes diffcult to trace errors
17.Data redundancy: Unnecessary storing the same data at different places
18.Results from data redundancy: poor data security, data
inconsensity
data entry errors
data intergrity problems
19.Componetns of DBMS enviormetnt: Hardware Software
Data Procedures
People
1/
3
1. Databases make data: persistent and shareable in a secure way
2. What is a database?: A share, integrated compuer structure that stores data
3. Databases are specialized structures that allow computer-based systems to: store, manage,
and retreive data quickly
4. Data constist of: raw facts
5. Informtion results from: processing raw facts to reveal meaning
6. Raw facts are the: building blocks of info
7. DBMS stands for: Database Managment system
8. DBMS is a: collection of programs
manages the database structure
Controsl access to data stored in database
9. DBMS allows intermediary between user and database: enables data to be shared
Improves sharing and security
10.Examples of DBMS: MySQL, Oracle, MS Access, Mongo DB
11.Databases can be classifed by number of users: single, multiple
12.:
13.Databases can be classifed by location: centralized-data located at single site,
distrubuted-data distubuted acorss diff sties
, cloud- database maintain and created using cloud data services
14.databses can be classifed by data type: general purpose-contains a wide variety of data
used in multiple displines
displine specific- contains data focused on spefic subhect area
15.databases can be classified by how muhc they are used: operational data- base- support co.
day to day operaitons (online transcation processing OLTP)
Anayltical database- stores histroical data
(OLAP- online anayltical processing)
16.if databases are poorly design: causes diffcult to trace errors
17.Data redundancy: Unnecessary storing the same data at different places
18.Results from data redundancy: poor data security, data
inconsensity
data entry errors
data intergrity problems
19.Componetns of DBMS enviormetnt: Hardware Software
Data Procedures
People
1/
3
