Database Management Systems
Questions 11 to 20
11.
|
A
transaction completes its execution is said to be
|
||||||||||
12.
|
The
process of managing simultaneous operations on the database without having
them interfere with one another is
|
||||||||||
13.
|
A
schedule where the operations of each transaction are executed consecutively
without any other interference from other transactions is called
|
||||||||||
14.
|
Which of
the following is not a deadlock handling strategy?
|
||||||||||
15.
|
Which of
the following does refer to the size of the data item chosen as the unit of
protection by a concurrency control program?
|
||||||||||
16.
|
Which of
the following hashing techniques does allow a hash file to expand and shrink
its number of buckets dynamically without needing a directory?
|
||||||||||
17.
|
Which of
the following indexes is based on the values being uniformly distributed
using a mathematical function?
|
||||||||||
18.
|
A join in
which the joining condition is based on equality between values in the common
columns is called
|
||||||||||
19.
|
A type of
query that is placed within a WHERE or HAVING clause of another query is
called
|
||||||||||
20.
|
The
entity integrity rule states that
|
Answers
11.
|
Answer : (a)
Reason: A transaction the completes its execution is
said to be Committed.
|
12.
|
Answer : (c)
Reason: The process of managing simultaneous
operations on the database without having them interfere with one another is
Concurrency control.
|
13.
|
Answer : (b)
Reason: A schedule where the operations of each
transaction are executed consecutively without any other interference from
other transactions is called Serial schedule.
|
14.
|
Answer : (d)
Reason: Deadlock
annihilation is NOT a deadlock
handling strategy.
|
15.
|
Answer : (a)
Reason: Granularity refer to the size of the data
item chosen as the unit of protection by a concurrency control program.
|
16.
|
Answer : (b)
Reason: Extensible hashing techniques does allow a
hash file to expand and shrink its number of buckets dynamically without
needing a directory.
|
17.
|
Answer : (b)
Reason: Extensible hashing techniques does allow a
hash file to expand and shrink its number of buckets dynamically without
needing a directory.
|
18.
|
Answer : (d)
Reason: The equi-join is a join in which records are
retrieved based on whether the join fields have matching values in both
tables. That may seem like just a definition of a join, but it isn't. An
example of a non-equal join is a join where records in the first table are joined
to those records in the second table where the joined field in the first
table is greater than (instead of equal to) the joined field in the second
table (or less than, or anything besides equal to). Naturally, this returns
more records than an equi-join.
A natural join is one in which
only one of the two tables’ joined fields is returned. Since these two fields
are by definition identical in an equi-join, it is redundant to include both.
For a non-equal join, it is important to include both of those fields. So,
equi-joins and natural joins go together.
|
19.
|
Answer : (e)
Reason: A type of query that is placed within a
WHERE or HAVING clause of another query is called Sub query
|
20.
|
Answer : (a)
Reason: The entity integrity rule states that no primary key attribute can be null
|
Questions are really helpful...
ReplyDeleteDid you know that that you can generate cash by locking special areas of your blog or website?
ReplyDeleteSimply join AdWorkMedia and embed their Content Locking tool.
Please check it out that ans 16,17 both are same how it's possible sir.
ReplyDeletethird page is not open plz check it sir
ReplyDeleteThese MCQ questions set with actual categorization is really amazing and each question has its own explanation with regards to the topic of choice and the details given are marvelous, if you want to further you career in data science check out skillslash they have the best data science course in bangalore they have a lot to offer with regards to data science in terms of training and live projects and will also help people who want to shift their field of practise
ReplyDeleteThis article is a valuable resource for anyone looking to enhance their knowledge in this field. Thank you for sharing this informative content MCQ's post.
ReplyDeleteRead my blog: AI in Software Testing: Revolutionizing Quality Assurance Practices
Fantastic exploration of Database Management Systems, Questions are really helpful! It's crucial for developers and businesses alike. Just as the atmosphere switch can change the mood in gaming, mastering these systems can transform how we manage data effectively.
ReplyDelete