(A) Explain the role of keys in Database Management System. Different…

Question

(A) Explain the role of keys in Database Management System. Differentiate between super key, primary key, candidate key and foreign key. (12)

(B) How is Embedded SQL different from Dynamic SQL. (8)

Related pages

• Keys and Integrity Rules — topic
• RDBMS syllabus

More PYQs on Keys and Integrity Rules

• (A) What are integrity constraints in SQL? (12) (B) Explain the Security in SQL. (8)
• (a) How are tuples identified in a relation ? What are different types of keys in a DB ? (b) Write a note on Relational Algebra with suitable example.