7.1.1 Database Basics

Question 1

What is a Database?

Answer 1

• A database is a collection of files that contain data organized using a given model.
• Medium for storing data
• Yung database koleksyon siya ng iba’t ibang mga files tapos inoorganize gamit ang isang given model. Dibale parang model mismo yung database.

Question 2

What is an Instance?

Answer 2

An instance contains a set of background processes and memory structures. It is the data management software that connects users and the operating system (OS)

• Dibale yung instance nilalaman niya yung mga set ng background processes at memory structures. Eto yung management software na pinag coconnect yung user at yung operating system.

Question 3

What are the two data types?

Answer 3

Relational database and Non-relational database.

Question 4

What is Relational Database?

Answer 4

• Data stored in rows and columns.
• A two dimensional table model.
• way of organizing data consisting of two dimensional table and their relationships.

Question 5

What is a Non-relational database?

Answer 5

• Data storage system that doesn’t comply with ACID properties.

Question 6

What is an ACID Properties and what does it stand for?

Answer 6

• ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.

Question 7

What is Atomicity in the ACID Properties?

Answer 7

Atomicity is the guarantee that series of database operations in an atomic transaction will either all occur or none will occur. If an error occurs during transaction execution, the transaction will be rolled back to the state from before it was committed.

Question 7

What is Atomicity in the ACID Properties?

Answer 7

Atomicity is the guarantee that series of database operations in an atomic transaction will either all occur or none will occur. If an error occurs during transaction execution, the transaction will be rolled back to the state from before it was committed.

Question 8

What is Consistency meaning in ACID Properties?

Answer 8

A consistent transaction will not violate integrity constraints placed on the data by the database rules. That is, executing a transaction cannot destroy the integrity or consistency of database data.

Question 9

What is Isolation in ACID Properties?

Answer 9

Isolation means that concurrent transactions are executed sequentially. It guarantees the individuality of each transaction and prevents them from being affected by other transactions.

Question 10

What is Durability in ACID Properties?

Answer 10

Once a transaction is committed, it will remain in the system even in the event of a system failure.