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
PROGRAM-
BSc IT
SEMESTER-
FIRST
SUBJECT
CODE & NAME- BT0066, Database Management Systems
CREDIT-3
BK
ID- B0950
MAX.
MARKS- 60
Q1.
Explain the differences between DBMS and RDBMS.Answer.
DBMS : Data Base
Management System ..... for storage of data and efficient retrieval of data.
Eg: Foxpro
1)A DBMS has to be persistent (it should be accessible when the
program created the data donot exist or even the application that
Q2. Why relational data model is important? Explain the terms
relation and tuple. 10
Answer: Relational
Model: The
relational model is today the primary data model for commercial dataprocessing
applications. It has attained its primary position because of its simplicity,
which eases the job of the programmer, as compared to earlier data
models
Q3.
Explain the architecture of Oracle database in brief.
Answer: The
Oracle server consists of physical files and memory components. The Oracle 9i
Database product is made up of three main components namely:
The Oracle Server – This is the Oracle database
management system that is able to store, manage and manipulate data. It
consists of all the files, structures, processes that form Oracle Database 9i.
The Oracle server is made up of an Oracle instance and an Oracle database.
The Oracle
Q4.
Explain different techniques that equipment designers have focused on to
improve the speed of access of blocks on disk.
Answer:
The main
measures of the qualities of a disk are capacity, access time, data-transfer
rate, and reliability.
Access time is the time from when a read
or write request is issued to when data transfer begins. To access (that is, to
read or write) data on a given sector of a disk, the arm first must move so that
it is positioned over the correct track
Q5.
Explain data fragmentation with an example. 10
Answer:
Data Fragmentation: If the relation r if fragmented,
r is divided into a number of fragments r1,
r2......,rn. These fragments
contain sufficient information to reconstruct the original relation r. As we
shall see, this reconstruction can take place through the application of either
the union operation or a special type of join operation on the various
fragments. There are two different schemes for fragmenting a relation:
horizontal fragmentation and
Q6.
Describe the approaches for incorporating object orientation capabilities in
databases.
Answer:
Approaches for incorporating object orientation capabilities in databases: There are at least six approaches
for incorporating object orientation capabilities in databases :
1. Novel database data model/ data
language approach: The
most aggressive approach develops entirely new database management system with
object orientation capabilities. Most of the research projects in
object-oriented databases have pursued
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