Database Management Systems
Section A: Objective Type & Short Questions (30 Marks)
„h This section consists of Multiple Choice and Short answer type questions.
„h Answer all the questions.
„h Part one carries 2 marks each & Part Two carries 5 marks each.
Part One:
Multiple choices:
1. A collection of related sets of data items along with necessary data/ information associated with
it.
a. Data
b. Information
c. Process
d. Database
2. ___________connects computers which are very remotely placed.
a. Local Area Network
b. Wide Area Network
c. Both (a) & (b)
d. None
3. A column in a table is called__________
a. Field
b. Record
c. Tuple
d. Link
4. DDL stands for ___________
a. Data Definition Language
b. Data Decision Language
c. Database Definition Language
d. None
5. SQL stands for ___________
a. Structured Query Language
b. Statement Query Language
c. Strict Query language
d. None
Examination Paper of Information Technology
7
IIBM Institute of Business Management
Part Two:
1. List the different types of DBMS.
2. Differentiate between .DBMS. and .RDBMS..
3. What do you mean by .Data Dictionary.?
4. Differentiate between discretionary access control and mandatory access control.
Section B: Caselets (40 marks)
„h This section consists of Caselets.
„h Answer all the questions.
„h Each Caselet carries 20 marks.
„h Detailed information should form the part of your answer (Word limit 200 to 250 words).
Caselet 1
Database management system is the complex software which is aimed at the management of the
information stored in the database effectively. A high-quality management system helps organize,
manipulate, transform, store, retrieve and create data professionally. It is important that the whole
information kept in the database could be accessible, manageable, and easy for manipulation. A
successful DBMS should possess a strict logical structure, which enables everyone to find the required
data easily. The high-quality management system gives the opportunity for the user to change the
required information without any harm to the whole application. Database management systems are
extremely important today, because the humanity lives in the age of information and the whole
information is kept in databases which require professional skilful management and flexibility.
Every organization, private and public, connected with business or not possesses the necessary
information which is essential for its proper functioning. The information is supposed to be stored in
security and only the employees of an organization can have access to it. The idea of a good database
management system is to make the work of an organization easier, faster and of higher quality,
because the easier and the faster the access to the data is, the faster the work will be. Moreover, if the
information becomes out-of-date, the experts can modify it and introduce the necessary changes to
make it valid.
1. What are the roles of a database in present scenario?
Caselet 2
The most dramatic advance of the past decade in software technology has been the development of
database management systems (DBMS). There is little question about the potential of these systems
for enhancing system support to managers and users while reducing design, structuring, and
END OF SECTION A
Examination Paper of Information Technology
8
IIBM Institute of Business Management
maintenance problems. Database systems also provide a way of improving information system
flexibility by decoupling user-oriented data structures from physical storage methods. In spite of the
vast potential of database management systems, the information systems community has not reacted
with the total enthusiasm that might have been expected. Significant resistance has been encountered
in some organizations, both from users, systems managers, and programming staff members. Although
the literature on the features of database systems is substantial, there is little discussion of resistance
problems encountered during the actual implementation and use of these systems in organizations. The
purpose of this panel is to examine issues related to resistance toward DBMS in organizations. The
panel members, each of whom is experienced in this area, will examine a number of organizational,
technical, and application issues pertinent to the problem of resistance. The discussion will focus on
why this resistance has occurred and how, if at all possible, it could have been avoided. Both
behavioral and technical issues will be examined. This session should be of interest to both the
practitioner and theorist alike. Database management systems are collectively the most significant
software product advance in the last decade. There is little question about the potential of these
systems for improving data management in organizations. Yet not all persons show a level of
enthusiasm for these systems that their capabilities would merit. Users and systems persons alike have
been known to resist acquisition and/or introduction of database management systems, sometimes
strongly. In the discussion that follows, the problem of resistance as it applies to database management
systems is introduced. The intent is to raise issues for research and investigation rather than to provide
concrete answers to problems.
1. Discuss various anomalies in databases. How would you improve data management in
organizations?
Section C: Applied Theory (30 marks)
„h This section consists of Long Questions.
„h Answer all the questions.
„h Each question carries 15 marks.
„h Detailed information should form the part of your answer (Word limit 150 to 200 words).
1. What do you understand by relational data model? Explain relational constraints and relational
database schemas
2. What are the similarities and dissimilarities in the software development life cycle and database
development life cycle?
S-2-300813
END OF SECTION B
END OF SECTION C
No comments:
Post a Comment