Lesson 14 Quiz
1.Which normal form is based on the concepts of multivalued dependencies?
4NF
2..BCNF boyce-codd normal form was proposed as a simpler form of ______
3NF
3.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?
4NF
LESSON-16-QUIZ
1.Which of the following files keeps the records ordered by value of a particular field?
Sorted
2.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?
MRU
3.Which of the following file allocation techniques allocates file blocks to consecutive disk blocks?
Contiguous
4.What occurs when the hash field value of a record that is being inserted hashes to an address that already contains a different record?
Collision
5.Which RAIC level uses a single parity disk relying on the disk controller to figure out which disk has falied?
3
LESSON-17 QUIZ
1.Which type of ordered single-level index is specified on nonordering fields as additional access structures to improve performance of queries and fransactios?
Secondary
2.Each node in a tree, except for a special node called a ———has one perent node and zero or more child nodes
root
3.Which type of index facilitates querying on multiple keys and is used for relations that contain a large number of rows?
Bitmap
14. LAB
16. LAB
17. LAB
1.
CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname));
2.
SELECT Fname, Lname
FROM EMPLOYEE_REC
WHERE UPPER(Lname)= “SMITH”;
Other Links:
Statistics Quiz
Networking Quiz
See other websites for quiz:
Check on QUIZLET
Check on CHEGG