Online Quiz

Which of the following is a DBMS software?

• • Microsoft Word

• • Oracle

• • Windows OS

• • Notepad

Which of the following is used to ensure data integrity in DBMS?

• • Indexes

• • Views

• • Constraints

• • Joins

Which of the following is a type of normalization that avoid partial dependency?

• • First Normal Form (1NF)

• • Second Normal Form (2NF)

• • Third Normal Form (3NF)

• • All of the above

Which of the following is not a type of join in SQL?

• • Inner Join

• • Left Join

• • Right Join

• • Down Join

What is the purpose of the primary key in a relational database?

• • To link tables together

• • To uniquely identify a record

• • To store large data

• • To store foreign keys

What is the function of a foreign key?

• • To uniquely identify records within a table

• • To link a record in one table to a record in another table

• • To ensure data integrity

• • To define a relationship between two primary keys

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

• • SELECT

• • INSERT

• • UPDATE

• • DELETE

Which type of DBMS model uses a tree-like structure?

• • Relational Model

• • Hierarchical Model

• • Network Model

• • Object-Oriented Model

Which of the following is used to improve the performance of queries in DBMS?

• • Views

• • Triggers

• • Indexes

• • Stored Procedures

Which of the following SQL commands is used to modify the structure of an existing table?

• • SELECT

• • ALTER

• • UPDATE

• • INSERT