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 and rs 625/semester only.
if urgent then call us on 08791490301, 08273413412
Fall 2015 ASSIGNMENT
PROGRAM MCA(REVISED FALL
2012)
SEMESTER THIRD
SUBJECT CODE & NAME
MCA3020- ADVANCED DATABASE MANAGEMENT SYSTEM
|
Question No 1. Describe the following:
a) Hierarchical Model
b) Network Model
|
Answer:
Hierarchical data model:- Here
we organize data into a structure which appears as a tree. In this stricter,
every node comprises one parent nod. Root node is an exception, that is, it
does not contain any
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. For
instance, we often need to "scan" a table. In other words, we need to bring into the main
Q.3
Differentiate 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
Q.4
What is Parallel query processing? Explain how parallel execution works?
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
Q.5
Differentiate 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
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
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 and rs 625/semester only.
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment