vu cs403 Final Term - Quiz No.4
vu cs403 Database Management Systems Quiz
This quiz belongs to book/course code vu cs403 Database Management Systems of vu organization. We have 18 quizzes available related to the book/course Database Management Systems. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Final Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: __________ is a control that users click to perform an action, set or toggle a state, or set an option.
Button
Text box
Input form
Report
Question 2: If W, X, Y and Z are attributes of a relation, which of the following inference rules for functionaldependencies is correct?
If (X, Z) -> Y then X -> Y and Z -> Y.
If X -> Y and X -> Z then X -> (Y, Z)
If XY then Y -> X
If X -> Y then (X, Z) -> (Y,W).
Question 3: Laser records data by burning microscopic holes in the surface of the disk with a
Hard disk
RAM
Optical disk
Floppy disk
Question 4: A __________ is used to maintain a connection between the users of the database system.
Mail server
File Server
Client-serve
None of the given.
Question 5: Which key word is available in SQL to enforce referential integrity?
Check
Primary Key
Set Default
Unique
Question 6: Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?
Join
Union
Cartesian Product
Set Difference
Question 7: Materialized views and Indexes are NOT similar by the following way(s).
hey consume storage space
They must be refreshed when the data in their master tables changes
They can be accessed directly using a SELECT statement
All of the Given
Question 8: Which of the following concepts is applicable with respect to 3NF?
Full functional dependency
Any kind of dependency
Transitive dependency
Partial functional dependency
Question 9: Which of the following is not one of the properties of Transaction?
atomicity
consistency
redundancy
durability
Question 10: Which of the following concepts is applicable with respect to 2NF?
Full functional dependency
Any kind of dependency
Transitive dependency
Non-transitive dependency
