Understanding Database Concepts

What is meant by a database?

• A database is an organized collection of data stored electronically.

• A database is a physical storage device for computers.

• A database is a collection of random files stored on a server.

• A database is a type of software used for web development.

Which of the following is not a function of a database system?

• Storing data securely

• Retrieving data efficiently

• Managing user permissions

• Providing user interface design

Which of the following is an advantage of using a database, except...

• Cost of setup and maintenance

• Increased data redundancy

• Improved data accessibility

• Enhanced data security

What is the software used to manage databases called?

• Information Retrieval System

• Database Management System (DBMS)

• Data Storage System

• File Management System

An example of DBMS software is...

• MySQL

• Oracle

• MongoDB

• PostgreSQL

What does DBMS stand for?

• Database Management System

• Digital Business Management Software

• Data Backup Management System

• Document Base Management System

Which of the following is a type of database model?

• Relational model

• Hierarchical model

• Network model

• Object-oriented model

What is the primary purpose of a database?

• The primary purpose of a database is to store and manage data.

• To create visual designs for websites.

• To process transactions in real-time.

• To generate random numbers for applications.

Which of the following is a common database management system?

• MySQL

• MongoDB

• SQLite

• PostgreSQL

What is data integrity in the context of databases?

• Data integrity refers to the speed of data retrieval.

• Data integrity is the amount of data stored in a database.

• Data integrity is the accuracy and consistency of data in a database.

• Data integrity is the process of backing up data regularly.