Database Systems Quiz

What is the primary purpose of a database system?

• To perform complex calculations

• To create graphical user interfaces

• To manage and organize data efficiently

• To store data in a flat file

Which of the following is a type of database model?

• Graphical Model

• Hierarchical Model

• Object-Oriented Model

• Text-Based Model

What does the term 'relational database' refer to?

• A database that uses tables to store data

• A database that stores data in XML format

• A database that is only accessible via the internet

• A database that does not support transactions

Which of the following is NOT a key concept in relational databases?

• Database Design

• Data Mining

• Relational Algebra

• Keys

What is the purpose of a primary key in a relational database?

• To uniquely identify each record

• To allow duplicate entries

• To store large amounts of data

• To create relationships between tables

Which SQL command is used to retrieve data from a database?

• INSERT

• UPDATE

• DELETE

• SELECT

What does the term 'aggregate function' refer to in SQL?

• A function that creates new tables

• A function that modifies data

• A function that combines multiple rows of data

• A function that retrieves data from multiple tables

What is a nested query in SQL?

• A query that is executed within another query

• A query that retrieves data from multiple databases

• A query that updates multiple records at once

• A query that creates a new database

Which SQL operation is used to combine rows from two or more tables?

• SUBTRACT

• INTERSECT

• UNION

• JOIN

What is the purpose of integrity constraints in a database?

• To create user interfaces

• To speed up data retrieval

• To ensure data accuracy and consistency

• To allow for data redundancy