Database Management System
Questions 271 to 280
271.
|
When converting one (1) to many (N)
binary relationship into tables, the recommended solution is usually
|
||||||||||
Which of the following
is not correct?
|
|||||||||||
The property of transaction which ensures
that either all operations of the transaction are reflected properly in the
database or none, is called
|
|||||||||||
Which of the following
is correct?
|
|||||||||||
An entity type whose
existence depends on another entity type is called a _____ entity.
|
|||||||||||
A property or
characteristic of an entity type that is of interest to the organization is
called an
|
|||||||||||
A relationship between
the instances of a single entity type is called a _____ relationship.
|
|||||||||||
A ________ attribute is an
attribute that can be further subdivided to yield additional attributes.
|
|||||||||||
In a super type/subtype
hierarchy, each subtype has
|
|||||||||||
The hierarchical database
model uses the hierarchic sequence that always starts at
|
Answers
271.
|
Answer : (b)
Reason: When
converting one (1) to many (N) binary relationship into tables, the
recommended solution is Foreign key added on the Child (many side) referencing
the parent
|
Answer : (d)
Reason: The procedure of identifying entities and attaching attributes always
leads to a unique solution
|
|
Answer : (a)
Reason: Atomicity
is the property of transaction which ensures that either all operations of
the transaction are reflected properly in the database or none
|
|
Answer : (a)
Reason: Function dependencies are not associated with relations; they are based
on the semantics of information that we are dealing with.
|
|
Answer : (b)
Reason: Entity type whose
existence depends on another entity type is called a weak entity
|
|
Answer : (a)
Reason: A property or
characteristic of an entity type that is of interest to the organization is
called attribute
|
|
Answer : (e)
Reason: A relationship between
the instances of a single entity type is called a Unary relationship.
|
|
Answer : (a)
Reason: Composite
attribute is an attribute that can be further subdivided to yield additional
attributes.
|
|
Answer : (a)
Reason: In a super type/subtype
hierarchy, each subtype has only one super type
|
|
Answer : (b)
Reason: The
hierarchical database model uses the hierarchic sequence that always starts
at the left side of the tree
|
Did you know that you can generate dollars by locking special pages of your blog or site?
ReplyDeleteSimply open an account on AdscendMedia and add their Content Locking plug-in.
The questions and answers you give are very useful. Very helpful for my exam preparation.
ReplyDeleteduck life