SQL_TCL_and_Normalisation(PRACTICE)

A functional dependency is a relationship between _______.

Attributes

Modification anomalies are frequently severe enough that tables need to be normalised into:

BCNF

Larry and Weasley was assigned a project in SQL they both worked seperately hence they had some duplicate data , both are confused in finding a way to get rid of the duplicate data, Luckily Larry used a savepoint command during data insertion. Suggest them a solution.

By using just Rollback command.

Which of the following eliminates any modification anomalies?

Domain/Key Normal Form.

In the ___________ normal form, a composite attribute is converted to individual attributes.

First

The multivalued dependence constraint problem has a many solutions, including:

Spliting the relation into two relations, each with a single theme.

Each answer below shows example data from a table. Which answer is an example of the multi value, multicolumn problem?

Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

A dependency exists between two columns, When___

Together they constitute a composite key for the table.

Which of the following commands is executed automatically during a transaction before commit, in case of a shutdown?

Rollback Explanation : In case of a shutdown, before committing, rollback is done.

A function is in ______ form if it has no partial functional dependencies.

2NF

Which of the following conditions are true for a table in second normal form (2NF)?

All non key fields depend on the primary key.

Dependencies with several values should _______ be removed.

Always

5NF is designed in a way such that there are no :

Join dependency

Altering the data might have unfavourable effects on some relationships, these are called:

Modification anomalies.

Read-only databases are ________ updated.

Never

Each of the answers below includes an example table with data. Which of the following solutions is an example of a general-purpose notes column problem?

One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.