Dbms quiz

                    DBMS QUIZ

Certainly! Here's a quiz on Database Management Systems (DBMS) with examples:

1. What does DBMS stand for?

   a) Database Management System

   b) Data Backup and Management System

   c) Digital Business Management Software

   d) Data Buffer Management System

2. Which of the following is not a type of DBMS model?

   a) Relational DBMS (RDBMS)

   b) NoSQL DBMS

   c) Object-Oriented DBMS (OODBMS)

   d) Graphical User Interface (GUI)

3. What is a primary key in a relational database?

   a) A key used for opening the database

   b) An index that speeds up database queries

   c) A unique identifier for each row in a table

   d) A foreign key linking two tables

4. Which SQL command is used to retrieve data from a database?

   a) DELETE

   b) UPDATE

   c) SELECT

   d) INSERT

5. In a relational database, what is an example of a one-to-many relationship?

   a) Each student can have multiple phone numbers.

   b) Each product can have multiple suppliers.

   c) Each employee can have only one department.

   d) Each customer can have one billing address.

6. Which SQL clause is used to filter rows based on a specified condition?

   a) GROUP BY

   b) HAVING

   c) WHERE

   d) ORDER BY

7. What is the purpose of the JOIN operation in SQL?

   a) To create a new table in the database

   b) To combine rows from two or more tables based on a related column

   c) To delete rows from a table

   d) To insert rows into a table

8. Which type of NoSQL database is best suited for handling large amounts of unstructured data, such as social media posts?

   a) Document-oriented

   b) Key-Value

   c) Column-family

   d) Graph

9. In a relational database, what is a foreign key?

   a) A key that unlocks a database

   b) A key used to encrypt sensitive data

   c) A field that links to the primary key in another table

   d) A key that is automatically generated by the DBMS

10. What is an example of a DBMS software?

    a) Microsoft Word

    b) Photoshop

    c) Oracle Database

    d) Google Chrome

Answers:

1. a) Database Management System

2. d) Graphical User Interface (GUI)

3. c) A unique identifier for each row in a table

4. c) SELECT

5. b) Each product can have multiple suppliers.

6. c) WHERE

7. b) To combine rows from two or more tables based on a related column

8. a) Document-oriented

9. c) A field that links to the primary key in another table

10. c) Oracle Database