online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject
if urgent then call us on 08791490301, 08273413412
SPRING
2016 ASSIGNMENT
PROGRAM MCA(REVISED FALL
2012)
SEMESTER THIRD
SUBJECT CODE & NAME
MCA3020- ADVANCED DATABASE MANAGEMENT SYSTEM
Q.1
Differentiate between Two-Tier client/server databases and Multi-tier
client/server databases. 10
Answer: Two-Tier client/server databases: Personal database is restricted to a
single user only. However there are numerous circumstances when the
clients or workgroup want the data to be distributed or shared between
them. All the links in a workgroup are the computer workstations. These computers
are linked to each other through network which can be either wired
Q.2
Explain the physical query plan operators. What is the significance of
Iterators? 10
Answer: Physical-Query-Plan
Operators: Physical
query strategy is made from operators. Each of these operators implements one step of the plan. The
physical operators are often specific implementations
for one of the operators of the relational algebra, although we also require physical operators for
other tasks that do not involve an operator
of the relational algebra.
Q.3
Differentiate between Serialisability and Recoverability. 10
Answer: Serialisability and
Recoverability: In
transaction processing, serialisability is considered as the property of a serialisable schedule. A (possibly
concurrent) schedule S is serializable if it is equivalent to a serial schedule S'. That is, S has the
same result database
state as S'. Serial Schedule is a schedule where
transactions are done in order. Transactions
are
Q.4
Discuss about Parallel query processing. How parallel-execution works? 10
Answer: Parallel query processing: In parallel query processing, multiple
processes together at the same time to handle one individual SQL
statement. The Database server can handle the statement more swiftly in
comparison to a single server by segregating the work necessary to
process a statement among various multiple servers. The feature helps to
dramatically enhance functioning for data intensive operations related
with decision-support applications and even extremely big database
environments. Parallel query feature is most useful for SMP (Symmetric
multiprocessing), clustered or MPP (massively parallel systems) because
of the fact that in such types of
Q.5
Differentiate between homogeneous and heterogeneous Database. 5+5 10
Answer:
Differences
between Homogeneous and Heterogeneous Database:
When the
database technology is the same at each of the locations and the data at the
several locations are also compatible, that data is known as homogenous
database. The following
Q.6
Write short notes on ODMG standards. What are the various components of
ODMG-93? 5+5 10
Answer:
ODMG-93
standard. It provides an inclusive framework for designing an object database,
writing portable applications in C++ or Smalltalk, and querying the database
with a simple and very
Get fully
solved assignment. Buy online from website
online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment