Dear
students get fully solved assignments
Send
your semester & Specialization name to our mail id :
“
help.mbaassignments@gmail.com ”
or
Call
us at : 08263069601
ASSIGNMENT
DRIVE
|
SPRING
2015
|
PROGRAM
|
BCA
(REVISED FALL 2012)
|
Semester
|
3
|
SUBJECT
CODE & NAME
|
BCA3020 - Database Management System
|
CREDIT
|
4
|
BK
ID
|
B
1479
|
MAX.MARKS
|
60
|
Note:
Answer all questions. Kindly note that answers for 10 marks questions should be
approximately of 400 words. Each question is followed by evaluation scheme.
Q.1
What is Database? Explain its properties.
Answer: A database is a collection of
information that is organized so that it can easily be accessed, managed, and
updated. In one view, databases can be classified according to types of
content: bibliographic, full-text, numeric, and images. In computing, databases
are sometimes classified according to their organizational approach. The most
prevalent approach is the relational database, a tabular database in which data
is defined so that it can be reorganized and accessed in a number of different
ways. A distributed database is one that can be dispersed or replicated among
different points in a network. An object-oriented programming database is one
that is congruent with the data defined in object classes and subclasses.
Q.2
Write the functions of the following
(a)
Storage Manager
Answer: Storage Resource Monitor provides comprehensive storage
performance monitoring and alerting across all your storage arrays to ensure
peak performance and avoid capacity surprises.
Storage Manager is the interface to the
systems storage service.
Q.3
List and explain the important responsibilities of database manager.
Answer: A database manager (DB manager) is a computer program, or a set of
computer programs, that provide basic database management functionalities
including creation and maintenance of databases. Database managers have several
capabilities including the ability to back up and restore, attach and detach,
create, clone, delete and rename the databases. Database managers are used to
manage local and remote databases. They discover databases based on the Web
server and provide the ability to connect to any of the databases residing in
the network. They provide a handful of administrative functionalities such as
managing tables, views and stored procedures, as well as run ad hoc queries.
Q.4
What is Relational Database Management System? Explain three aspects of RDBMS.
Answer: A relational database management system (RDBMS) is a database
management system (DBMS) that is based on the relational model as invented by
E. F. Codd, of IBM's San Jose Research Laboratory. Many popular databases
currently in use are based on the relational database model.
RDBMSs are a common choice for the storage
of information in new databases used for financial records, manufacturing and
logistical information, personnel data, and other applications since the 1980s.
Relational databases have often replaced legacy hierarchical databases and
network databases because they are easier to understand and use. However,
relational databases have been challenged by object databases, which were
introduced in an attempt to address the object-relational impedance mismatch in
relational databases, and XML databases.
Q.5
What do you mean by Embedded SQL? How do you declare variables and exceptions?
Answer: Advantages of PL/SQL:
·
Better Performance
·
Integration with Oracle
·
Cursor FOR Loops
·
Procedures and Functions
·
Packages
·
PL/SQL Tables
·
User-Defined Records
Q.6
What are the disadvantages of Data Distribution?
Answer: In a distributed database, data is
stored in different systems across a network. For Example, in mainframes,
personal computers, laptops, cell phones, etc. Array expressions specify
concurrency but not locality. That is,
they specify opportunities for parallel execution but not how these opportunities should be
exploited so as to minimize communication costs on a parallel computer. HPF
introduces data distribution directives to provide the programmer with control
over locality. These directives work as follows
Q.7
Write a note on the following
a)
SUBSET Mapping
Answer: In DBMS Writing a Java application
that stores data in a RDBMS can be as simple as slapping a few data-aware
components on a form. However, if you rely on data-aware controls you lose the
benefits of encapsulation and set yourself up for a larger maintenance burden
ahead. (See the sidebar "Benefits of the Business Object"). Proper
object-relational integration requires a strategy for mapping the object model
to the relational model in order for Java objects to become persistent to the
RDBMS. A persistent object is one that can automatically store and retrieve
itself in permanent storage.
b)
SUPERSET Mapping
Answer: A persistent class with a superset
mapping contains attributes derived from columns of multiple tables. This type
of mapping is also known as table spanning.
Dear
students get fully solved assignments
Send
your semester & Specialization name to our mail id :
“
help.mbaassignments@gmail.com ”
or
Call
us at : 08263069601
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.