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
Winter 2015 ASSIGNMENT
PROGRAM MCA(REVISED FALL
2012)
SEMESTER THIRD
SUBJECT CODE & NAME
MCA3020- ADVANCED DATABASE MANAGEMENT SYSTEM
CREDIT 4 BK ID B1649 MAX.
MARKS 60
Q.
No. 1 Differentiate DBMS and RDBMS 5+5
10
Answer:
DBMS
DBMS is defined as the software program
that is used to manage all the databases that are stored on the network or
system hard disk. There are different types of database management systems and
2
Differentiate 3NF and BCNF 5+5 10
Answer:
For
understanding the differences between BCNF and 3NF, we must again carefully
look back to the definition of 3NF and BNF.
According
3.
Explain Buffer Management in detail. What are the roles of a buffer manager 5+5
10
Answer:
Buffer
Management
We have
assumed that operators on relations have some number of main-memory buffers
that they can utilize to store required data. Actually, these buffers are not
often allocated in advance to the
4
Describe five different lock modes. 5*2 10
Answer:
The lock modes
are as bellow:
1. Shared Locks: In case of
Row-level shared locks, various users are permitted by shared locks to read
data, but no user is permitted to change that data. In case of Table-level,
various users are permitted by shared locks to carry out read and write
operations on the table, but any user is
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
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
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