SDF Q2 U5

______________________ is a concept where data is organized to prevent repeated data entry.

• Keys

• XML

• Normalization

• Client side

What are the two forms for normalization?

• 1NF, 3NF

• 1NF, 2NF

• 2NF, NF

• 1NF, 0NF

This form ensures that every record is unique and that fields are independent of each other.

• Third normal form

• First normal form

• Fifth normal form

• Normal form

In this form, each field needs to have a single value so that data can be sorted in any way possible.

• Third normal form

• First normal form

• Fifth normal form

• Normal form

In this form, a value change in a non-key column in one table should not necessitate a change in another non-key column elsewhere.

• Third normal form

• First normal form

• Fifth normal form

• Normal form

What is the goal of an index in relational databases?

• to allow sorting

• to improve server/client interaction

• to find data

• to speed up searching for data within a database

In a _________________ index, data is sorted on primary key field.

• clustered

• non-clustered

In a _________________ index, data is sorted on a field that is usually one used in filtering.

• clustered

• non-clustered

One way to ensure the correct data is entered into a given field is to add a ________________.

• constraint

• index

• normalization

• key

The ______________________ ensures that every record in a table is unique.

• ERD

• primary key

• normal key

• filtered key