SLC 2071 Question of DBMS

Group A (Any four)   4 X 1 =4

1.       Write the Full form of DBMS.

2.       Define Relational Calculus.

3.       What is View?

4.       What is meant by Data Integrity?

5.       What does Functional Dependency mean?

6.       Define Transaction.

7.       What is Data Encryption?

Group B (any eight) 8 X 2=16

8.       What is ER Model? Write its notation.

9.       What are TRC and DRC?

10.   Define the Relational Algebra.

11.   Write any four name of operators used in Relational calculus.

12.   What is Relational Database?

13.   What are the important features of SQ L? Write any four of them.

14.   How can you create view? Write down the syntax.

15.   List the constraints in data integrity.

16.   Write the syntax of view to retrieve and update.

17.   Write any differences between Trivial and Non-Trivial dependencies.

18.   What is two-phase commit protocol?

19.   Define deadlock with block diagram.

20.   What is transaction concurrency?

21.   Define database security mechanism.

Group C (Any Four) 4 X 5 = 20

22.   Consider the following database and write relational algebra for the given problems.

Employee

Emp_ID	Name	City	Comp_Name	Salary
001	Sajina Gurung	Birgunj	A	44,000
002	Kiran Sharma	Kathmandu	A	40,000
003	Punam Kunwar	Pokhara	B	38,000
004	Asmit Shreshtha	Palpa	C	25,000

i). Find the name of Employee who earn more than 38,000.

ii). Find the name of all employee who work in A.

iii). Find the name list of all employee.

iv). Find the name of employee who earn least.

v). Re-arrange the name of cities in ascending order.

23.   Define optimization with block diagram.

24.   Explain the three levels of Architecture.

25.   Explain the closure set of dependencies.

26.   Explain the database normalization process from un-normalized to 2NF with example.

27.   Explain Serialibility and isolation levels,

28.   Introduce DAC (Discretionary Access Control) and MAC ( Mandatory Discretionary Access Control).