Database Quiz

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 can be used to speed up maintenance tasks.

• Normalization simplifies select statements.

• Most databases are in fifth normal form.

A keyword used for procedure modification:

• ALTER

• CHANGE

• DROP

• CREATE

The opposite method for specification in ER is:

• identification

• normalization

• denormalization

• generalization

• simplification

What does the following procedure do:

• Procedure deletes the row for the given id

• Procedure returns all rows from the customer table

• Procedure inserts a new customer

• Procedure returns the entire row for the given id

What is the scientific method of splitting of the complex table structures on the simple table structures by definite rules?

• Concretization

• Normalization

• Generalization

• Denormalization

• Functional dependence

Which of the followingis the resultof combining two ormore low-levelentity setsto create higher levelentity set?

• relation

• specification

• supertype

• generalization

• normalization

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

• Redundancy

• Concretization

• Relations between entities

• Functional dependency

• Normalization

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

• 1NF

• 2NF, 3NF

• BCNF,4NF

• 5NF, DKNF

• All NF

Result of samplinga subsetfromthe high-level entityset to forma lower level entity setis:

• specification

• normalization

• generalization

• denormalization

• functional dependence

Following code is an example of:

• Stored procedure with parameters

• Stored procedure without parameters

• Executing the procedure

• Checking the procedure