Database Management Systems - A collection of related sets of data items along with necessary data information associated with it.a. Data b. Information c. Process d. Database

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

www.mbacasestudyanswers.com

ARAVIND – 09901366442 – 09902787224

Database Management Systems

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

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: Case lets (40 marks)

Case let 1

1. What are the roles of a database in present scenario?

Case let 2

1. Discuss various anomalies in databases. How would you improve data management in
organizations?

2. What do you understand by relational data model? Explain relational constraints and relational database schemas

3. What are the similarities and dissimilarities in the software development life cycle and database development life cycle?

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

www.mbacasestudyanswers.com

ARAVIND – 09901366442 – 09902787224