Database Management Systems
Questions 321 to 330
The most recent version of standard SQL prescribed by the
American National Standards Institute is
(a) SQL-99 (b)
SQL 2002 (c) SQL – 4 (d) SQL2 (e) SQL PLUS.
|
|
ANSI-standard SQL allows the use of special operators in
conjunction with the WHERE clause. A special operator used to check whether
an attribute value is null is
(a) BETWEEN (b)
IS NULL (c) LIKE (d) IN (e) Exists.
|
|
A lock that prevents the use of any tables in the database
from one transaction while another transaction is being processed is called a
(a) Database-level lock (b) Table-level lock (c) Page-level lock
(d) Row-level lock (e) Field-level lock.
|
|
A condition that occurs when two transactions wait for
each other to unlock data is known as a(n)
(a) Shared lock (b)
Exclusive lock (c) Binary lock
(d) Two-phase lock (e) Deadlock.
|
|
_______ means that data used during the execution of a
transaction cannot be used by a second transaction until the first one is
completed.
(a) Serializability (b) Atomicity (c) Isolation
(d)
Time stamping (e)
Durability.
|
|
A unit of storage that can store one or more records in a
hash file organization is denoted as
(a) Buckets (b)
Disk pages (c) Blocks (d) Nodes (e) Baskets.
|
|
The file organization which allows us to read records that
would satisfy the join condition by using one block read is
(a) Heap file organization (b) Sequential file
organization
(c) Clustering file organization (d) Hash files organization (e) Index File.
|
|
Which of the following is not true about B+ trees?
(a) B+ tree index takes the form of balanced
tree
(b) Performance of B+ tree degrades as the file
grows
(c) Look-up in B+ tree is straightforward and
efficient
(d) Insertion and deletion in B+ tree is
complicated but efficient
(e) None of the above.
|
|
The extent of the database resource that
is included with each lock is called the level of
(a) Impact (b) Granularity (c)
Management
(d)
DBMS control (e) Recovery.
|
|
DBMS periodically suspends all
processing and synchronizes its files and journals through the use of
(a) Checkpoint facility (b) Backup facility (c) Recovery manager
(d) Database change log (e) Shadow Paging.
|
Answers
Answer : (a)
Reason : SQL-99 is
the most recent version of standard SQL prescribed by the ANSI
|
|
Answer : (e)
Reason: Exists is
used to check whether an attribute value is null or not in conjunction with
the where clause.
|
|
Answer : (a)
Reason: Data
base-level lock prevents the use of any tables in the data base from one
transaction while other transaction is being processed.
|
|
Answer : (e)
Reason : Deadlock
occurs when two transactions wait for each other to unlock data
|
|
Answer : (c)
Reason: isolation
means that data used during the execution of a transaction can’t be used by a
second transaction until the first one is completed.
|
|
Answer : (a)
Reason: Buckets are
used to store one or more records in a hash file organization.
|
|
Answer : (c)
Reason: Clustering
file organization allows us to read records that would satisfy the join condition
by using one block read.
|
|
Answer : (b)
Reason : The
answer is evident
|
|
Answer : (b)
Reason: The extent
of the data base resource that is included with each lock is called the level
of Granularity.
|
|
Answer : (a)
Reason: DBMS
periodically suspends all processing and synchronizes its files and journals
though the use of Check point facility.
|
Did you know that that you can make cash by locking premium sections of your blog / website?
ReplyDeleteSimply open an account on AdWorkMedia and add their Content Locking tool.