What is a DBMS?
a) Data Backup and Management System
b) Database Management System
c) Digital Business Model Software
d) Data Buffering and Memory System
Answer: b) Database Management System
Which SQL statement is used to retrieve data from a database?
a) SELECT
b) UPDATE
c) DELETE
d) INSERT
Answer: a) SELECT
What is the primary key in a relational database used for?
a) Storing large data files
b) Establishing relationships between tables
c) Uniquely identifying each record in a table
d) Sorting data in ascending order
Answer: c) Uniquely identifying each record in a table
Which database model is based on a tree-like structure with parent-child relationships?
a) Relational
b) Hierarchical
c) Network
d) NoSQL
Answer: b) Hierarchical
In a relational database, what is an attribute?
a) A unique identifier for each record
b) A column representing a property of an entity
c) A table containing related data
d) A key used for encryption
Answer: b) A column representing a property of an entity
Which SQL command is used to add new rows to a database table?
a) INSERT
b) CREATE
c) ALTER
d) DELETE
Answer: a) INSERT
Which of the following is NOT a valid data type in SQL?
a) INTEGER
b) BOOLEAN
c) VARCHAR
d) DATE
Answer: b) BOOLEAN
What is ACID in the context of database transactions?
a) A standard for measuring database performance
b) A type of database index
c) A set of properties that ensure reliable transaction processing
d) A database query language
Answer: c) A set of properties that ensure reliable transaction processing
Which SQL clause is used to filter data in a SELECT statement based on a specified condition?
a) WHERE
b) FROM
c) GROUP BY
d) ORDER BY
Answer: a) WHERE
Which type of database is designed to handle large volumes of unstructured data like text, images, and videos?
a) Relational Database
b) NoSQL Database
c) Hierarchical Database
d) Network Database
Answer: b) NoSQL Database