Database Management System
Questions 261 to 270
261.
|
Which
level of RAID refers to disk mirroring with block striping?
(a) RAID level 1 (b) RAID level 2 (c) RAID level 0
(d) RAID level 3 (e) RAID level 4.
|
262.
|
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) Sectors.
|
263.
|
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 file
organization
(e) Random file
organization.
|
264.
|
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)
two-phase lock
(d)
deadlock (e) Timestamp.
|
265.
|
The
following incomplete SQL statement, once completed, is expected to be used to
retrieve all employees who have not worked on at least one project?
SELECT EMP_ID FROM EMPLOYEE
WHERE ……………... (SELECT * FROM ALLOCATION
WHERE EMPLOYEE.EMP_ID=ALLOCATION.EMP_ID);
Fill in
the blank with the correct keyword.
(a) EXISTS (b) NOT EXISTS (c) ALL (d) EXIT (e) NOT IN.
|
266.
|
Which
property of transaction ensures that either all operations of the transaction
are reflected properly in the database or none are?
(a) Atomicity (b) Durability (c) Isolation
(d) Consistency (e) Consistency.
|
267.
|
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) column-level lock.
|
268.
|
The best
solution for a DBA to do in the case of a deadlock is
(a) re-boot the system
(b) backup the database, drop the indexes and
restore the database
(c) see
the sessions which are running and kill all the sessions involved in the
deadlock except for one
(d) de fragmenting the disk
(e) None of the above.
|
269.
|
Consider
the following five tasks.
(i) Changing data in one or more rows in a
table.
(ii) Defining a View
(iii) Removing a row from a table
(iv) Changing data in a particular column
(v) Removing a view
Which SQL
keywords have to be used to accomplish the above five tasks?
(a) (i) ALTER (ii) CREATE (iii) DELETE (iv)
UPDATE (v) DROP
(b) (i) ALTER (ii) CREATE (iii) INSERT (iv)
UPDATE (v) DELETE
(c) (i) UPDATE (ii) CREATE (iii)
DELETE (iv) UPDATE (v) DROP
(d) (i) UPDATE (ii) CREATE (iii) DROP (iv)
INSERT (v) UPDATE
(e) (i) UPDATE (ii) CREATE (iii) UPDATE (iv)
INSERT (v) DROP.
|
270.
|
What are
the correct features of a
distributed database?
(a) Is always connected to the internet
(b) Always requires more than three machines
(c) Users see the data in one
global schema.
(d) Have to specify the physical location of
the data when an update is done
(e) All DBMS have to be homogenous.
|
Answers
261.
|
Answer : (a)
Reason: RAID level 1.
|
262.
|
Answer : (a)
Reason: A unit of storage that can store one or more
records in a hash file organization is denoted as buckets.
|
263.
|
Answer : (c)
Reason: Clustering file organization.
|
264.
|
Answer : (d)
Reason: A condition that occurs when two
transactions wait for each other to unlock data I known as deadlock.
|
265.
|
Answer : (b)
Reason: NOT EXISTS.
|
266.
|
Answer : (a)
Reason: Atomicity.
|
267.
|
Answer : (a)
Reason: A lock that prevents the use of any tables
in the database from one transaction while another transaction is being
processed is called a database lock
|
268.
|
Answer : (c)
Reason: The best solution for a DBA to do in the
case of a deadlocks is to see the sessions which are running and kill all the
sessions involved in the deadlock except for one.
|
269.
|
Answer : (c)
Reason: UPDATE, CREATE, DELETE AND UPDATE AND DROP.
|
270.
|
Answer : (c)
Reason: Users see the data in one global schema.
|
<< Prev 1... 2... 3... 4... 5... 6... 7... 8... 9... 10... 11... 12... 13... 14... 15... 16... 17... 18... 19... 20... 21... 22... 23... 24... 25... 26... 27... 28... 29... 30... 31... 32... 33... 34... 35... 36... Next >>
Did you know that you can generate dollars by locking special sections of your blog / site?
ReplyDeleteTo begin just join AdWorkMedia and add their content locking widget.