vu cs403 Final Term - Quiz No.5
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: The two basic types of record access methods are __________.
sequential and random
sequential and indexed
Direct and immediate
sequential and immediate
Question 2: __________ is a control that enables users to select one option from an associated list; users can also type an option
Combo box
Button
Text box
Static area
Question 3: Which of the following statements is correct with respect to the two relations given above?
The two relations are not union-compatible since their attribute names differ.
The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these tworelations.
To find out those students who work as instructors, it is necessary to perform the operationStudent ∩ Instructor.
CS403-MIDTERM SOLVED MCQS with references by MOAAZ(2).pdf
Question 5: Identify the correct statement.
Referential integrity constraints check whether the primary key values are unique
Referential integrity constraints check whether an attribute value lies in the given range
Referential integrity constraints are specified between entities having recursive relationships
When Referential integrity rules are enforced, a tuple in one relation that refers to another relationmust refer to an existing tuple.
Question 6: Which of the following is INCORRECT about VIEWS?
It is not possible to left out the data which is not required for a specific view.
A database view displays one or more database records on the same page.
Views can be used as security mechanisms
Views are generally used to focus the perception each user has of the database.
Question 7: Which of the following is not true about input forms?
Provide an easy, effective, efficient way to enter data into a table
Especially useful when the person entering the data is not familiar with the inner workings
Provide different controls to add data into the tables
One input forms can populate one table at a time
Question 8: Which of the following is INCORRECT statement concerning the database design process?
During requirements collection and analysis phase, one can gather the data requirements of databaseusers.
By referring to a high level data model, it is possible to understand the data requirements of the users,entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical designor data model mapping
During the logical design phase of internal storage structures, access paths and file organization forthe database files are specified.
Question 9: What is the impact of setting multiple indexes for the same key, in index sequential file
Multiple indexes for the same key can not be set
It increases efficiency
It decreases efficiency
It will increase complexity as the access time will be increased
Question 10: Which file organization is allowed by a direct access storage device?
sequential only
Direct only
indexed and direct only
sequential, indexed and direct
