INF503 Week 5 New Quizess Lessons 14,16,17

                                                                        Lesson 14 Quiz 

Which normal form is based on the concepts of multivalued dependencies?

A)4NF

 

.BCNF boyce-codd normal form was proposed as a simpler form of ______

A)3NF

Which of the following normal forms is violated when a relation has undesirable multivalued dependencies and hence can be used to identify and decomposition such relations?

A)4NF

LESSON-16-QUIZ

Which of the following files keeps the records ordered by value of a particular field?

A)Sorted

Which of the following buffer replacement strategies works best for certain type of database, such as when a block that is used most recently is not neded until all the remaining blocks in the are processed? 

A)MRU

Which of the following file allocation techniques allocates file blocks to consecutive disk blocks?

A)Contiguous

What occurs when the hash field value of a record that is being inserted hashes to an address that already contains a different record?

A)Collision

Which RAIC level uses a single parity disk relying on the disk controller to figure out which disk has falied?

A)3

LESSON-17 QUIZ

Which type of ordered single-level index is specified on nonordering fields as additional access structures to improve performance of queries and fransactios?

A)Secondary

Each node in a tree, except for a special node called a ---------has one perent node and zero or more child nodes 

A)root

Which type of index facilitates querying on multiple keys and is used for relations that contain a large number of rows?

A)Bitmap

 14. LAB

1. 

2. 

3.

4. 

5.

6.

16. LAB

1. 

2. 

3.

4. 

5.

17. LAB

1.

CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname));

2. 

SELECT Fname, Lname
FROM EMPLOYEE_REC
WHERE UPPER(Lname)= "SMITH";