DATABASE MANAGEMENT SYSTEMS

Multiple choices:

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

Q2. ___________connects computers which are very remotely placed.
a. Local Area Network
b. Wide Area Network
c. Both (a) & (b)
d. None

Q3. A column in a table is called__________
a. Field
b. Record
c. Tuple
d. Link

Q4. DDL stands for ___________
a. Data Definition Language
b. Data Decision Language
c. Database Definition Language
d. None

Q5. SQL stands for ___________
a. Structured Query Language
b. Statement Query Language
c. Strict Query language
d. None

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?