Database - Quiz

1. A database is an organized collection of data, typically stored and accessed electronically from a computer system. It is designed to allow for efficient data retrieval, storage, and manipulation. Databases are commonly used in applications such as websites, mobile apps, and enterprise systems to store and manage structured information. They provide a structured way to store, organize, update, and retrieve data, allowing users to perform complex queries and analysis. Different types of databases exist, including relational databases, NoSQL databases, and cloud databases, each with their unique features and use cases. Overall, databases play a crucial role in modern computing by enabling the efficient and secure management of data.

What is normalization in databases?

A) Deleting old data.
B) Organizing data in a database to reduce redundancy.
C) Creating duplicate records.
D) Adding extra data to improve accuracy.

2. What is ACID in database transactions?

A) Aggregate, Consistency, Isolation, Duration.
B) Atomicity, Consistency, Isolation, Durability.
C) Asset, Consistency, Independence, Durability.
D) Atomicity, Convergent, Isolation, Dispersion.

3. What is a database index used for?

A) Deleting records.
B) Encrypting data.
C) Improving the speed of data retrieval operations.
D) Adding security to the database.

4. What does CRUD stand for in database operations?

A) Calculate, Rank, Update, Delete.
B) Copy, Remove, Use, Delete.
C) Create, Read, Update, Delete.
D) Create, Refresh, Undo, Dump.

5. What is a database trigger?

A) An error message.
B) A security warning.
C) Automated response to a specific event in a database.
D) A type of encryption.

6. In a relational database, what is a join?

A) Deleting duplicate records.
B) Changing the primary key.
C) Separating data into different tables.
D) Combining rows from two or more tables based on a related column.

7. What does DBMS stand for?

A) Digital Banking Management System.
B) Data Backup and Migration Service.
C) Database Management System.
D) Dynamic Business Model Software.

8. What is the purpose of an ETL process in databases?

A) Establish Table Licensing.
B) Extract, Transform, Load data from various sources into a data warehouse.
C) Encrypt, Transmit, Log data.
D) Enable Table Linking.

9. Which of the following is a NoSQL database system?

A) SQLite
B) MySQL
C) MongoDB
D) Oracle Database

10. What is a database constraint?

A) Rules that define acceptable values or conditions for data in the database.
B) A report produced by the database.
C) A physical database backup.
D) A database user's access level.

11. In a relational database, what is a foreign key constraint?

A) An extra security measure.
B) A key that allows duplicate values.
C) A rule that ensures the referential integrity of the data.
D) A key that cannot be changed.

12. Which database management system is known for being open-source and developed by Oracle?

A) SQL Server
B) PostgreSQL
C) DB2
D) MySQL

13. What is a query in a database?

A) A database error.
B) A type of database model.
C) A request for data or information from a database table.
D) A database replication process.

14. What is the process of organizing data into a series of tables related by common fields known as?

A) Normalization
B) Indexing
C) Denormalization
D) Optimization

15. Which SQL keyword is used to filter records based on a condition?

A) ORDER BY
B) WHERE
C) SELECT
D) FROM

16. What is a database index?

A) A data structure that improves the speed of data retrieval operations on a database table.
B) A report generation tool.
C) A file containing all database records.
D) A type of database model.

17. What is the purpose of a database administrator (DBA)?

A) To delete data from the database.
B) To manage and maintain the database system.
C) To design the physical database schema.
D) To develop database applications.

18. What does SQL stand for?

A) Sequential Query Language
B) Series Query Language
C) Structured Query Language
D) Structured Query Logic

19. Which type of join in SQL returns all rows from both tables, joining records where available?

A) Inner Join
B) Left Join
C) Full Outer Join
D) Cross Join

20. What is the purpose of data modeling in databases?

A) To slow down data retrieval.
B) To encrypt all data.
C) To create a visual representation of the database structure.
D) To make data unavailable for querying.

Created with That Quiz — where test making and test taking are made easy for math and other subject areas.