CS III DBMS IMP QUESTIONS

 Cs iv sem imp questions:(DBMS)

Unit 1:

A) question

1. What is DBMS ? Explain advantages of DBMS

2. Problems of file processing system

3. Explain data models(types)

4. Explain 3 level ANSI SPARC architecture

5. Functions of DBMS

6. Components of DBMS

7. Types of Database users

Unit 2: 

A)

1. Explain entity , attribute, relationship

2. Explain degree of relationship

3. Explain super type and subtype

4. Explain specialization and generalization

5. Explain integrity constraints 

B question

1. What is normalization? Explain types of normalization

2. Explain 1 NF and 2 NF

3. Compare 3NF and BCNF

 Unit 3. 

A)

1. What is sql ? Explain data types in sql

2. Explain ddl commands

3. Explain dml commands

4. Explain SQL operators

5. Explain sub queries

6. What is view ? Explain view operations

B

1. What is pl SQL ? Explain pl SQL data types

2. Explain cursors

3. Explain triggers

 Unit 4.:

A) question

1. What is transaction? Explain transaction properties

2. Explain strict 2phase locking

3. What is deadlock? Explain deadlock detection and prevention

4. Explain timestamping

5. Explain database recovery and its techniques

B question

1) what is data base security threats? Explain how to achieve database security

2 ) explain backup and recovery techniques