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
PROGRAM
BCA
(REVISED 2012)
SEMESTER
- 3
SUBJECT
CODE & NAME
BCA3020
- Database Management System
BK
ID - B1479
CREDIT
- 4
MAXIMUM
MARKS – 60
Q1.
What is Database? Explain its properties. 10
Answer: Database:
The
database is a collection of related data. The basic component of a file
in a file system is a data item, which is the smallest named unit of
data that has mSeaning in the real world – for example, last name, first
name, street address, ID number, or political party. A group of related
data items
Q2 Write the functions of the
following (a) Storage Manager (b) Buffer Manager 3+2
Answer –
Storage
manager
|
The Storage Manager: The Storage Manager interfaces with the
operating system (OS) to write
Q3 List and explain the important
responsibilities of database manager.
Answer - Databases
typically require a large amount of storage space. Corporate databases are
usually measured in terms of gigabytes of data. Since the main memory of
computers cannot store this
Q4.
What is Relational Database Management System? Explain three aspects of RDBMS.
10
Answer: Relational
Database Management System: A Relational Database Management System
(RDBMS) provides a comprehensive and integrated approach to information
management. A relational model provides the basis for a relational
database. A relational model has three aspects:
1. Structures
2. Operations
3.
Q5.
What do you mean by Embedded SQL? How do you declare variables and exceptions?
10
Answer: Embedded
SQL: We
have looked at a wide range of SQL query constructs, treating SQL as an
independent language in its own right. A relational DBMS supports an interactive
SQL interface, and users can directly enter SQL commands. This simple
approach is fine as long as the task at hand can be accomplished entirely
with SQL commands. In practice we often encounter
Q6 What are the disadvantages of
Data Distribution
Answer - Disadvantages
of Data Distribution The primary disadvantage of distributed database systems
is the add
Answer - As a result, VBSF
supports two types of class-to-table mappings that help overcome the
differences between relational and object models: SUBSET and SUPERSET.
SUBSET Mapping
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