Question rdms.
question 1.
a)What is a DBMS?
b)What do you mean by procedual access?
c)What do you mean by database tuning?

question 2.
a)What is the different between a file based database and DBMS?
b)List down some of the disadvantages of the file based database?
c)Define briefly the term data dictionary.

question 3.
a)Write down the features of a DBMS.
b)Give some advantages of data dictionary.

question 4.
a)Explain with an example what do you mean by multiuser access.
b)list some advantages of a DBMS.


Question C.
This section contains 2 question.Answer only 1 question.

Question 1.
a)List down some functions of a DBMS.
b)Write a short note on the following.
  a) Primary key     b) Constraints

Question 2
a)Data in a dbms is more secure more than are data in a file based database . Do you agree and why?
b)List some characteristics of a DBMS?

Section B
Question 1.
a)Briefly explain the objectives of SQL(Structure Query Language)
b)There are 3 major scopes in SQL which is Data Definition Language(DDL), Data Manipulation Language (DML) and Data Control Language (DCL).Give explaination for each scopes.

Question 2.
a)Briefly explain 2 goals of database development.
b)There are many tools on the market that come under the general category of computer AIDED Software System (CASE) goals for database design . List down 4 functions of CASE tools.
c)Briefly explain about conceptual design , logical design and physical design.