Database Administration and Management System

What is a relational database management system (RDBMS)?

• A software system that manages relational databases.

• A file system used to store relational databases.

• A programming language used to create relational databases.

• A hardware system that manages relational databases.

Name one popular RDBMS.

• Oracle

• MySQL

• MongoDB

• SQLite

What are the main components of an RDBMS?

• tables, relationships, constraints, and indexes

• tables, relationships, constraints, and views

• tables, relationships, constraints, and triggers

• tables, relationships, constraints, and queries

What is a table in an RDBMS?

• A table is a collection of data organized in rows only.

• A table is a collection of related data organized in columns and rows.

• A table is a collection of related data organized in rows and columns.

• A table is a collection of unrelated data organized in rows and columns.

What is a primary key in a table?

• A primary key in a table is a column that contains only unique values.

• A primary key in a table is a column that is used for sorting the data.

• A primary key in a table is a column that is optional and can be left empty.

• A primary key in a table is a column or a set of columns that uniquely identifies each row in the table.

What is a foreign key in a table?

• A foreign key in a table is a column that stores the primary key of another table.

• A foreign key in a table is a column that is used to sort the data in the table.

• A foreign key in a table is a column or a set of columns that refers to the primary key of another table.

• A foreign key in a table is a column that is used to calculate the average value of the data in the table.

What is normalization in database management?

• The process of deleting data in a database to improve data integrity.

• The process of organizing data in a database to increase redundancy.

• The process of duplicating data in a database to improve data integrity.

• The process of organizing data in a database to eliminate redundancy and improve data integrity.

What is denormalization in database management?

• The process of encrypting data in a database to improve performance by reducing the storage space needed.

• The process of adding redundant data to a database to improve performance by reducing the number of joins needed for queries.

• The process of removing redundant data from a database to improve performance by reducing the number of joins needed for queries.

• The process of normalizing data in a database to improve performance by reducing the number of tables.

What is the purpose of indexing in an RDBMS?

• The purpose of indexing in an RDBMS is to save disk space.

• The purpose of indexing in an RDBMS is to enforce data integrity.

• The purpose of indexing in an RDBMS is to facilitate data backup and recovery.

• The purpose of indexing in an RDBMS is to improve query performance.

What is a query language in an RDBMS?

• A query language in an RDBMS is a language used to communicate with a non-relational database management system.

• A query language in an RDBMS is a language used to communicate with a relational database management system.

• A query language in an RDBMS is a language used to communicate with a file system.

• A query language in an RDBMS is a language used to communicate with a programming language.