CPOD-Q2W1

What level of abstraction is manifested below?

"Data presented to the end user"

• View level

• Physical level

• Logical level

What level of abstraction is manifested below?

"How data is stored on disk"

• View level

• Physical level

• Logical level

What level of abstraction is manifested below?

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

• View level

• Physical level

• Logical level

Check the DBMSes in the list.

• MongoDB

• PostgreSQL

• Redis

• MySQL

• Microsoft Excel

True or False: File system storage is a good alternative to using a DBMS

• True

• False

List the four DBMS properties that make up the acronym ACID.

• Atomicity

• Consistency

• Isolation

• Durability

• Constrained

Which ACID property is being described below?

"transaction should becompletely executed or not be executed at all."

• Atomicity

• Consistency

• Isolation

• Durability

Which ACID property is being described below?

"transactions are executed concurrently on the DB"

• Atomicity

• Consistency

• Isolation

• Durability

Which ACID property is being described below?

"it will stay committed, even if after a system failure."

• Atomicity

• Consistency

• Isolation

• Durability

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