Final Exam Review: Information Management

It is a major component of SQL that enables you to create and modify the database itself.

• Data Control Language

• Data Manipulation Language

• Data Definition Language

• Transaction Control Language

It is the process of organizing data to minimize redundancy in the design of a relational database management system.

• Normalization

• Functional Dependency

• Transitive Dependency

• Full Functional Dependency

A process of minimizing the differences between entities by identifying their common features.

• Superclass

• Generalization

• Subtype

• Specialization

A normal form wherein the partial dependency is being eliminated.

• 1NF

• 2NF

• 3NF

• BCNF

This statement is used to edit data in a table.

• CHANGE

• EDIT

• UPDATE

• ALTER

Which of the following SQL commands is not an example of Data Manipulation Language?

• SELECT

• COUNT

• FROM

• RENAME

A normal form where all underlying simple domains contain atomic values only.

• 1NF

• 2NF

• 3NF

• BCNF

It is a graphical user interface that allows you to issue SQL commands to interact with the server and any databases you create.

• MySQL Community Server

• MySQL Workbench

• Oracle Database Express Edition

• SQL Server Management Studio

It is used to connect to any of the SQL Server components.

• Solutions Explorer Window

• Object Explorer Window

• Query Editor Window

• Properties Window

It is the key field that serves as the unique identifier of a specific tuple in a relation.

• Foreign Key

• Primary Key

• Candidate Key

• Unique attribute