Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
Fall 2014 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 between 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
some of them are configured for specific purposes.
2
Differentiate between 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 to a
3NF definition “The condition for a relational schema R to be in 3NF is if
whenever a nontrivial functional dependency (FD)X→A holds in
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
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
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
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
Get fully solved assignment, plz drop a mail with your sub code
computeroperator4@gmail.com
Charges for mba rs 125/subject and rs 700/semester only.
For other rs 125/subject only
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment