Database Management Quiz

What is data redundancy in a database system?

Which of the statement is NOT TRUE about procedural Data Manipulation Language (DML)?

• low-level language

• define what data is needed and how to obtain that data

• high-level language

• called one-at-a-time DMLs

What is data normalization in the context of databases?

Data Manipulation Language (DML) is used to ______.

• define the physical schema

• construct a database

• access a database

• drop database object

You can join output of multiple tables with __________ statement.

• ALTER

• GROUP

• JOIN

• SELECT

__________ is a process for evaluating and correcting table structures to minimize data redundancies.

• Minimization

• Dependency

• Normalization

• Denormalization

What does MVC stand for in software architecture?

• Most-Valuable-Code

• Multiple-View-Controller

• Modular-Visual-Components

• Model-View-Controller

Which of the following commands ensures that a column will not have duplicate values?

• PRIMARY KEY

• UNIQUE

• DEFAULT

• NOT NULL

What is the purpose of metadata?

• To store primary data.

• To provide context and structure to data.

• To perform complex calculation.

• To generate reports.

______ validates data when attribute value is entered.

• CHECK constraint

• DEFAULT constraint

• DROP constraint

• ADD constraint