Q. What is a Database Management System (DBMS)?
Ans. A DBMS is software used to create, store, organize, retrieve, update, and manage data in a database.
Q. What is a database?
Ans. A database is an organized collection of related data that can be stored, accessed, and managed efficiently.
Q. What are the main advantages of a DBMS?
Ans. A DBMS helps reduce unnecessary data duplication, improve data consistency, control access, and support efficient data retrieval.
Q. What is a table in a relational database?
Ans. A table stores related data in rows and columns.
Q. What is a record in a database?
Ans. A record is a row in a table containing related information about one item or entity.
Q. What is a field in a database?
Ans. A field is a column in a table that stores a particular type of information.
Q. What is a primary key?
Ans. A primary key uniquely identifies each record in a table and cannot contain duplicate or NULL values.
Q. What is a foreign key?
Ans. A foreign key is a column or group of columns that refers to a key in another or the same table to establish a relationship.
Q. What is a relational database?
Ans. A relational database organizes data into tables that can be connected through relationships between keys.
Q. What is SQL?
Ans. SQL stands for Structured Query Language. It is used to define, retrieve, insert, update, and delete data in relational databases.
Q. What is a query?
Ans. A query is a request to retrieve or manipulate data stored in a database.
Q. What is the purpose of the SELECT statement?
Ans. The SELECT statement retrieves data from one or more database tables.
Q. What is the purpose of the INSERT statement?
Ans. The INSERT statement adds new records to a database table.
Q. What is the purpose of the UPDATE statement?
Ans. The UPDATE statement modifies existing records in a database table.
Q. What is the purpose of the DELETE statement?
Ans. The DELETE statement removes selected records from a database table.
Q. What is data redundancy?
Ans. Data redundancy means storing the same data unnecessarily in multiple places, which can increase storage use and cause inconsistencies.
Q. What is data integrity?
Ans. Data integrity means maintaining the accuracy, consistency, and reliability of data throughout its lifecycle.
Q. What is a database relationship?
Ans. A database relationship connects records in tables using related fields or keys.
Q. What is a database backup?
Ans. A database backup is a separate copy of database information that can be used to restore data after loss or damage.
Q. Why is database security important?
Ans. Database security helps prevent unauthorized access, alteration, disclosure, and destruction of data.