Database Management System Quiz

Primary key can be NULL

• Primary key can be NULL

• Foreign key must be unique

• Primary key must be unique

• Foreign key must be NULL

DBMS stands for Data Based Management System

• DBMS stands for Data Based Management System

• DBMS is used for hardware management

• DBMS is a programming language

• DBMS stands for Database Management System

SQL is a type of operating system

• SQL is a type of operating system

• SQL stands for Structured Query Language

• SQL is used to compile programs

• SQL is used for image processing

A relation is a collection of attributes

• A relation is a collection of attributes

• A tuple is a column in a table

• A table is also known as a relation

• A field is a row in a table

DDL is used to manipulate data

• DDL is used to manipulate data

• DML is used to define the structure of a database

• DDL stands for Data Definition Language

• DML stands for Data Deletion Language

INSERT is a DDL command

• INSERT is a DDL command

• DELETE is a DCL command

• SELECT is used to remove records

• UPDATE is a DML command

1NF allows multi-valued attributes

• 1NF allows multi-valued attributes

• 2NF removes transitive dependency

• 3NF removes partial dependency

• 1NF eliminates repeating groups

In a weak entity, there is always a primary key

• In a weak entity, there is always a primary key

• A weak entity does not have a primary key of its own

• A weak entity can exist without a strong entity

• Weak entities are not supported in ER models

A trigger is a type of stored procedure

• A trigger is a type of stored procedure

• A trigger is executed manually

• A trigger is activated by events

• Triggers are used for authentication

Redundancy means optimal data storage

• Redundancy means optimal data storage

• Redundancy is a form of normalization

• Redundancy leads to data inconsistency

• Redundancy improves performance always