Introduction to Database Management Systems

What is a database?

• A database is a structured collection of data.

• A database is a type of video game

• A database is a form of social media platform

• A database is a type of computer hardware

What is DBMS and its role in managing databases?

• DBMS is a software used to manage and organize databases.

• DBMS is a programming language

• DBMS is a type of computer monitor

• DBMS is a hardware component used in networking

List three advantages of using a DBMS.

• High cost, complex data management, and data inconsistency

• Data security, data integrity, and efficient data retrieval

• Data duplication, slow data retrieval, and data insecurity

• Limited storage capacity, data redundancy, and slow data processing

What is the full form of RDBMS?

• Relational Database Management System

• Remote Data Backup Management Service

• Random Data Backup Management System

• Real-time Database Management Software

Explain the concept of tables in RDBMS.

• Tables in RDBMS store data in an unstructured format with no specific organization.

• Tables in RDBMS store data in a structured format with rows and columns.

• Tables in RDBMS are used to store only text data and cannot handle other data types.

• Tables in RDBMS do not have rows and columns, but instead store data in a single continuous block.

What are rows and columns in the context of RDBMS?

• Rows are vertical records and columns are horizontal fields in a table.

• Rows are horizontal records and columns are vertical fields in a table.

• Rows are fields and columns are records in a table.

• Rows are vertical fields and columns are horizontal records in a table.

How does a DBMS ensure data integrity?

• By using constraints and rules to enforce data accuracy and consistency.

• By regularly deleting old data

• By randomly changing the data values

• By allowing unrestricted access to all users

What is the primary key in a database table?

• The average value of all the records in the table

• The first column in the table

• A unique identifier for each record in the table

• The most frequently occurring value in the table

Explain the concept of normalization in RDBMS.

• The process of increasing redundancy in a database

• The process of encrypting data in a database

• The process of organizing data in a database to reduce redundancy and dependency.

• The process of deleting data from a database