What is a Database?

Question 1

What is a database?

Answer 1

Central Repository for storing information.

Question 2

What are the 4 advantages of having a databases?

Answer 2

1. Allows for multiple concurrent users to use it.
2. Scalability (Grows with more data).
3. Provides fast data retrieval.
4. Able to store a variety of data elements and types.

Question 3

What is a record and field within a database?

Answer 3

• A row within a database table.
• A column within a database table.

Question 4

What is creation? What is Import? What is Storage? When it comes to database usage.

Answer 4

• Creation is the step that involves defining what information the database will store, where it will be hosted and how it will be addressed by clients; in other words engineering a database.
• Import is the input or updating the database manually from another source or entering data directly.
• Storage is a way for an application to store data persistently and securely.

Question 4

What is data persistence?

Answer 4

Storage of data permanently on a storage device such as HDD.

Question 5

What is Queries and Reports?

Answer 5

• Query is a request for data or information within a database to retrieve or modify data stored.
• Rerports are pre-defined queries