Database Management System
Questions 281 to 290
281.
|
Which of the following
is a component of the relational data model included to specify business
rules to maintain the integrity of data when they are manipulated?
|
||||||||||
A null value is created or
represented by
|
|||||||||||
A functional dependency
between two or more non-key attributes is called
|
|||||||||||
Which of the following is a
classical approach to database design?
|
|||||||||||
In the context
of a database table, the statement "A determines B" indicates that
|
|||||||||||
Which of the following Relational Algebra
operations require that both tables (or virtual tables) involved have the
exact same attributes/data types?
|
|||||||||||
Which type of file is
easiest to update?
|
|||||||||||
A method that speeds
query processing by running a query at the same time against several
partitions of a table using multi processors is called
|
|||||||||||
The protocol that ensures conflict
serializability is
|
|||||||||||
Indexes are created in
most RDBMS’s to
|
Answers
281.
|
Answer : (b)
Reason: Data
integrity is a component of the relational data model included to specify business
rules to maintain the integrity of data when they are manipulated
|
Answer : (e)
Reason: A
null value is created or represented by Pressing the Enter key without making
a prior entry of any kind
|
|
Answer : (c)
Reason: A functional dependency
between two or more non-key attributes is called transitive dependency
|
|
Answer : (a)
Reason: top-down approach is a classical approach to database design
|
|
Answer : (d)
Reason: Knowing the value of attribute A you can look up the value of
attribute B.
|
|
Answer : (c)
Reason: n
relational algebra Union, Intersection, Minus operations require that both
tables (or virtual tables) involved have the exact same attributes/data types.
|
|
Answer : (b)
Reason: Hash file is easiest to update
|
|
Answer : (c)
Reason: A method that speeds
query processing by running a query at the same time against several
partitions of a table using multi processors is called parallel query processing.
|
|
Answer : (a)
Reason: The
protocol that ensures conflict serializability is time stamp ordering
protocol.
|
|
Answer : (c)
Reason: Indexes are created in
most RDBMS’s to Provide rapid, random and sequential access to base-table
data
|
No comments :
Post a Comment