STUPIDSID
1 (a)
Define: (1) Data (2) Entity (3) Meta Data (4) Super key (5) Not Null (6) Data Integrity (7) Dual
7 M
1 (b)
Differentiate Between: (1) update and insert (2) primary key and foreign key (3) grant and revoke (4) row and column
7 M
2 (a)
Define DBMS. Explain the DBMS languages with examples: DDL, DML, and DCL.
7 M
Answer any one question from Q2 (b) & Q2 (c)
2 (b)
Who is DBA? Explain the role of DBA in DBMS.
7 M
2 (c)
Explain the three level architecture of DBMS and its advantages.
7 M
Answer any two question from Q3 (a), (b) & Q3 (c), (d)
3 (a)
Define E-R Diagram. Draw E-R diagram with Customer, Loan and Payment sets.
7 M
3 (b)
Write query for the following:
(1) To create a table from a table.
(2) To eliminate duplicate rows.
(3) To add a new column in the table
(4) To sort data in a table
(1) To create a table from a table.
(2) To eliminate duplicate rows.
(3) To add a new column in the table
(4) To sort data in a table
7 M
3 (c)
List the steps in proper sequence in order to convert an ER and EER diagram into tables.
7 M
3 (d)
Explain any three Aggregate functions and Scalar functions with examples.
7 M
Answer any two question from Q4 (a), (b) & Q4 (c), (b)
4 (a)
What is functional dependency? Explain the its types in detail.
7 M
4 (b)
What is a view? Explain how to create, its types and significance in DBMS.
7 M
4 (c)
What is Normalization? What are its characteristics? Explain 2NF and 3NF in detail.
7 M
4 (d)
Explain all types of Joins with commands and examples.
7 M
Answer any two question from Q5(a), (b) & Q5 (c), (d)
5 (a)
Define Transaction. Explain the transaction properties and transaction states.
7 M
5 (b)
What is locking? Explain Two phase locking and its types.
7 M
5 (c)
What is deadlock? Explain necessary conditions for deadlock and methods for handling it.
7 M
5 (d)
Define Failure? Explain Log based Recovery.
7 M
More question papers from Database Management System