Cs iv sem imp questions:(DBMS)

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

4. Explain 3 level ANSI SPARC architecture

5. Functions of DBMS

6. Components of DBMS

Or( b) question

1. Explain integrity constraints

2. Explain relational operators

3. What is relation? Explain properties of table Unit 2: 

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 3. 

A)

1. Explain entity , attribute, relationship

2. Explain degree of relationship

3. Explain super type and subtype

4. Explain specialization and generalization

B question

1. What is normalization? Explain types of normalization

2. Explain 1 NF and 2 NF

3. Compare 3NF and BCNF

 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