DBMS

1. 1.DBMS stands for

• Database Management System

• Distributed Management Systems

• Dynamic Base Main Server

• Data Basic Main System

2.What does the relational model primarily use to represent data?

• Trees

• Graphs

• Tables

• Files

3.What is the purpose of normalization?

• To remove redundant data

• To increase redundancy

• To back up data

• To encrypt data

4.Which of the following is a type of relational database constraint?

• JSON

• DEFAULT

• Object

• Variable

5.Functional dependencies are used in which context?

• File Systems

• Data Encryption

• Normalization

• Indexing

6.Which SQL command is used to retrieve data?

• DELETE

• UPDATE

• SELECT

• INSERT

7.Which clause is used to filter rows in SQL?

• WHERE

• SELECT

• ORDER BY

• GROUP BY

8.What does the FOREIGN KEY reference?

• Itself

• A primary key in another table

• a null column

• a Trigger

9.What does the GROUP BY clause do?

• Groups rows sharing a property

• Merges tables

• Repeats rows

• None of these

10.A composite primary key:

• Has one column

• Is always a foreign key

• Is a key on multiple columns

• Allow Nulls