* What does DBMS stand for?
a) Data Binary Management System
b) Database Management Software
c) Database Management System
d) Data Backup Management System
Answer: c) Database Management System
* Which of the following is NOT a type of DBMS?
a) Relational DBMS (RDBMS)
b) Hierarchical DBMS (HDBMS)
c) Object-Oriented DBMS (OODBMS)
d) Flat File DBMS (FDBMS)
Answer: d) Flat File DBMS
* What is a collection of related data entries called in a database?
a) Field
b) Record
c) Table
d) Schema
Answer: c) Table
* Which SQL command is used to retrieve data from a database?
a) INSERT
b) UPDATE
c) DELETE
d) SELECT
Answer: d) SELECT
* What is the primary key in a database table?
a) A foreign key
b) A key used for searching
c) A key that uniquely identifies each record
d) Any column in the table
Answer: c) A key that uniquely identifies each record
* What does SQL stand for?
a) Structured Query Logic
b) Sequential Query Language
c) Structured Query Language
d) Simple Query Logic
Answer: c) Structured Query Language
* Which of the following is a DDL (Data Definition Language) command?
a) SELECT
b) INSERT
c) UPDATE
d) CREATE TABLE
Answer: d) CREATE TABLE
* Which of the following is a DML (Data Manipulation Language) command?
a) CREATE DATABASE
b) ALTER TABLE
c) DROP TABLE
d) INSERT INTO
Answer: d) INSERT INTO
* What is normalization in DBMS?
a) Adding redundant data to improve performance
b) Organizing data to reduce redundancy and improve data integrity
c) Encrypting data for security
d) Backing up data regularly
Answer: b) Organizing data to reduce redundancy and improve data integrity
* What are the ACID properties of a transaction in DBMS?
a) Atomicity, Consistency, Isolation, Durability
b) Accuracy, Consistency, Isolation, Dependency
c) Atomicity, Completeness, Integrity, Durability
d) Accuracy, Completeness, Isolation, Dependency
Answer: a) Atomicity, Consistency, Isolation, Durability
* What is a foreign key?
a) The primary key of another table
b) A key used to sort data
c) A key that is not unique
d) An alternative key for a table
Answer: a) The primary key of another table
* What is a database schema?
a) A set of rules for data manipulation
b) A visual representation of the database
c) The logical structure of the database
d) The physical storage of the database
Answer: c) The logical structure of the database
* What is a view in SQL?
a) A physical table in the database
b) A virtual table based on the result of an SQL statement
c) A way to define constraints on data
d) A tool for database administration
Answer: b) A virtual table based on the result of an SQL statement
* Which join returns only the rows where there is a match in both tables?
a) LEFT JOIN
b) RIGHT JOIN
c) FULL JOIN
d) INNER JOIN
Answer: d) INNER JOIN
* Which join returns all rows from the left table and the matching rows from the right
table?
a) LEFT JOIN
b) RIGHT JOIN
c) FULL JOIN
d) INNER JOIN
Answer: a) LEFT JOIN
* What is an index in a database?
a) A way to compress data
b) A structure that improves the speed of data retrieval
c) A tool for enforcing data integrity
d) A method for backing up the database
Answer: b) A structure that improves the speed of data retrieval
* What is a stored procedure?
a) A function written in SQL that can be executed
b) A trigger that automatically runs in response to database events
c) A backup of the database schema
d) A method for connecting to a database
Answer: a) A function written in SQL that can be executed
* What is a trigger in DBMS?
a) A constraint on a table
b) A stored program that automatically executes in response to certain events
c) A type of database user
d) A tool for performance monitoring
Answer: b) A stored program that automatically executes in response to certain events
* What is data integrity?
a) The security of the data from unauthorized access
b) The accuracy and consistency of data
c) The speed at which data can be accessed
d) The amount of storage space used by the data
Answer: b) The accuracy and consistency of data
* Which normal form deals with the elimination of transitive dependencies?
a) 1NF (First Normal Form)
b) 2NF (Second Normal Form)
c) 3NF (Third Normal Form)
d) BCNF (Boyce-Codd Normal Form)
Answer: c) 3NF (Third Normal Form)
