ThatQuiz Test Library Take this test now
Relational database - Exam
Contributed by: Bedford
  • 1. A relational database is a type of database that stores and provides access to data points that are related to one another. The data points are organized into tables, with each table consisting of rows and columns. One of the key features of a relational database is the ability to establish relationships between different tables based on common fields, allowing for efficient querying and retrieval of data. This structure helps ensure data integrity and consistency, as changes made to one table will automatically reflect in related tables. Relational databases use structured query language (SQL) to manage and manipulate data, making them a powerful tool for handling complex datasets in various applications, such as e-commerce, finance, and customer relationship management systems.

    What is a primary key in a relational database?
A) A key that allows access to all records in a table.
B) A key that is not indexed.
C) A unique identifier for each record in a table.
D) A key used for encryption of data.
  • 2. What is SQL?
A) Structured Query Language used to manage and query relational databases.
B) Structured Query Logic for manipulating files.
C) Syntax Query Language for text documents.
D) Simple Query Language for non-relational databases.
  • 3. What does ACID stand for in database transactions?
A) Access Control In Database.
B) Automated Computation and Integration Delivery.
C) All Columns Indexed Directly.
D) Atomicity, Consistency, Isolation, Durability.
  • 4. Which of the following is an example of a relational database management system (RDBMS)?
A) MongoDB
B) Elasticsearch
C) Redis
D) MySQL
  • 5. What is a view in a relational database?
A) A data type used for storing images.
B) A table with no records.
C) A virtual table that presents data from one or more tables based on a query.
D) An index created on a column for faster retrieval.
  • 6. Which SQL keyword is used to retrieve specific rows from a table?
A) FILTER
B) SELECT
C) SORT
D) GROUP
  • 7. What is a data dictionary in a relational database context?
A) A table containing data records.
B) A collection of metadata that describes the data and structure of the database.
C) A database index for quick data retrieval.
D) A set of rules for defining relationships.
  • 8. Which type of join in SQL returns only the rows where there is a match in both tables?
A) RIGHT JOIN
B) INNER JOIN
C) LEFT JOIN
D) OUTER JOIN
  • 9. What is a subquery in SQL?
A) A query that returns all records in a table.
B) A query that selects a random subset of data.
C) A query nested within another query.
D) A query that retrieves data from multiple tables.
  • 10. Which SQL function is used to find the highest value in a column?
A) MAXIMUM
B) FIRST
C) TOP
D) MAX
  • 11. Which SQL command is used to add new data to a table?
A) MERGE
B) UPDATE
C) ADD
D) INSERT
  • 12. What is a join in the context of relational databases?
A) A process of creating new records in a table.
B) A method to combine rows from two or more tables based on a related column.
C) A method for filtering data.
D) An operation to pivot table data.
  • 13. What is the purpose of an index in a relational database?
A) To improve the speed of data retrieval operations.
B) To combine multiple tables into one.
C) To encrypt sensitive data in the database.
D) To define relationships between tables.
  • 14. What is a composite key in a relational database?
A) A key that consists of multiple columns to uniquely identify a record.
B) A primary key for composite data types.
C) A key that is not indexed.
D) A key that is stored in multiple tables.
  • 15. What is a database schema in the context of relational databases?
A) The physical storage location of the database files.
B) A type of encryption algorithm.
C) A logical design that represents the structure of the database.
D) A software tool for database management.
  • 16. Which SQL statement is used to remove data from a table?
A) DELETE.
B) UPDATE.
C) INSERT INTO.
D) SELECT.
  • 17. Which SQL clause is used to filter rows that meet a specific condition?
A) WHERE
B) GROUP BY
C) SELECT
D) FILTER
  • 18. Which command is used to remove a table from a database?
A) INSERT
B) UPDATE
C) DROP
D) ALTER
  • 19. Which SQL statement is used to modify data in a table?
A) ALTER
B) MODIFY
C) UPDATE
D) CHANGE
Created with That Quiz — where a math practice test is always one click away.