Database Management System Questions and Answer | As per SBTE Bihar Syllabus

1. Write PL/SQL program to calculate factorial of a given number.

2.Define index. Explain types of index. | DBMS | As per SBTE Bihar Syllabus

3. Explain set operators with example

4. Explain any four functions of database administrator.

5. Describe shared lock and exclusive locking strategy in brief

6. Explain for loop in PL/SQL with example.

7. State and explain 1NF and 2NF with example.

8. Describe data abstraction with neat diagram.