Платонус УПР 61-85

Result of sampling a subset from the high-level entity set to form a lower level entity set is:

• specification

• normalization

• generalization

• denormalization

• functional dependence

What is the relation type of functional dependencies?

• М : 1

• 1 : 1

• М : М

• There is no any relation

What is used for normalization reducing?

• E/R scheme

• Primary and foreign keys

• Decomposition without redundancy

• Bottom-up method

• Generalization

In which type of below normal forms each determinant in relation is possible key?

• 1NF.

• 2NF.

• 3NF.

• BCNF.

• 4NF.

Which of the following is the result of combining two or more low-level entity sets to create higher level entity set?

• relation

• specification

• supertype

• generalization

• normalization

What is the type of NF, if the table is in previous NF and doesn’t have multi-value dependencies?

• DKNF

• BCNF

• 4NF

• 5NF

• There is no such NF

What is the reason of the anomalies insertion in the database?

• Redundancy

• Concretization

• Relations between entities

• Functional dependency

• Normalization

Which of the following statements are true about normalization?

• Normalization is used to reduce the number of tables in a database.

• Normalization can remove redundant data from the database.

• Normalization simplifies select statements.

• Most databases are in fifth normal form.

The opposite method for specification in ER is:

• identification

• normalization

• denormalization

• generalization

• simplification

What type of NF aren’t based on functional dependency?

• 1NF

• 2NF, 3NF

• BCNF, 4NF

• 5NF, DKNF

• All NF