CPO Lesson 1.1

What level of abstraction was defined by this statement:

Data presented to the end user

(a)  

What level of abstraction was defined by this statement:

How data is stored on disk

(a)  

What level of abstraction was defined by this statement:

Data types, relations between data items and constraints on the data

(a)  

Check the DBMSes in the list

• MongoDB

• PostgreSQL

• Redis

• MySQL

• Microsoft Excel

File system storage is a good alternative to using a DBMS

• True

• False

For the acronym ACID, what does A stand for?

(a)  

For the acronym ACID, what does C stand for?

(a)  

For the acronym ACID, what does I stand for?

(a)  

For the acronym ACID, what does D stand for?

(a)  

Which of these problems does a DBMS help solve?

• Need for ad-hoc system to use the data

• Data duplication

• Resource locking (one user at a time only)

• Human error

• Bad quality data