vu cs403 Final Term - Quiz No.12
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: What is the impact of setting multiple indexes for the same key, in index sequential files?
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 2: A candidate key that does not have a null value and is selected to uniquely identify all other attributevalues in any given row is called a
superkey
candidate key
primary key
secondary key
Question 3: Identify the correct statement about ANSI/SPARC architecture.
The external level is not concerned with individual user perceptions
The internal level, in a database system, will always be relational
Any given database has exactly one conceptual schema and one physical schema, but it may have severalexternal schemas.
A data definition language is used to define the internal schema
Question 7: Which of the following most certainly implies the need for an entire table to implement?
A binary relationship
A ternary relationship
A recursive relationship
An identifying relationship
Question 8: Select the correct statement among the following on proper naming of schema constructs:
Entity type name applies to all the entities belonging to that entity type and therefore a plural name isselected for entity type.
In the narrative description of the database requirements, verbs tend to indicate the names ofrelationship types.
The nouns arising from a database requirement description can be considered as names of attributes
Additional nouns which are appearing in the narrative description of the database requirements represent theweak entity type names.
Question 9: Which of the following is NOT a feature of HASH ACCESS?
indexes to search or maintain
Very fast direct access
Inefficient sequential access
Use when direct access is needed, but sequential access is not.
