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
summer
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 LAN
or wireless LAN. Mostly, all computers uses a particular application
(client) providing the user an interface and business logic by which
manipulation of data is performed. The database in addition to DBMS is
stored on the workgroup’s central device and workgroup have permission to
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
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 scheduled one by one. Upon completion of one transaction another transaction is scheduled
whereas schedules in
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),
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 conditions should exist for homogeneous database:
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 powerful query language. The ability to store, retrieve
and modify persistent objects in Smalltalk is provided by
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