STUPIDSID
1 (a)
What is role of a DBMS, and what are its advantages?
10 M
1 (b)
Explain in detail in built control and Active-x control in VB.
10 M
2 (a)
Explain the following terms with examples :-
(i) an entity
(ii) a weak relationship
(iii) a strong relationship
(iv) a recursive relationship.
(i) an entity
(ii) a weak relationship
(iii) a strong relationship
(iv) a recursive relationship.
10 M
2 (b)
Use the small database shown in figure(1) and answer the question :-
(i) Identify the primary keys
(ii) Identify the foreign keys
(iii) Create the Entity Relationship Model(ERM)
(iv) Create the relational database.
Table Name : Student
Table name : Subject
Figure 1 small database :
(i) Identify the primary keys
(ii) Identify the foreign keys
(iii) Create the Entity Relationship Model(ERM)
(iv) Create the relational database.
Table Name : Student
| Stud_no | Stud_name | Stud_DOB |
| 10 | Bhuvi | 15-8-90 |
| 11 | Dhriti | 26-1-92 |
| 12 | Shree | 5-9-95 |
Table name : Subject
| Sub_code | sub_name | stud_no |
| 301 IT Th | DBMS | 12 |
| 302 IT Th | OOPS | 11 |
| 303 IT Th | AT | 12 |
| 304 IT Th | M-III | 10 |
| 305 IT Pr | DBMS | 11 |
| 306 IT Pr | OOPS | 12 |
| 307 IT Pr | AT | 11 |
Figure 1 small database :
10 M
3 (a)
Describe two-phase locking protocols and graph based protocols
10 M
3 (b)
Explain the use of logs and check points for recovery in a database.
10 M
4 (a)
Explain the terms ODBC and OLEDB.
10 M
4 (b)
What are the features of GUI? Explain dicision making statement and loop structures statement in VB.
10 M
5 (a)
What do you mean by deadlocks in database system? Explain the techniques for deadlocks prevention and deadlock detection.
10 M
5 (b)
Why transaction processing system usually allow concurrent executions? Give reasons.
10 M
6 (a)
What do you mean by a virtual table or a view. What are its characteristics?
10 M
6 (b)
Write a notes on relational algebra.
10 M
Write short notes on (any four):-
7 (a)
ACID properties
5 M
7 (b)
OODBMS and ORDBMS
5 M
7 (c)
DBA
5 M
7 (d)
Murphy's law of GUI design
5 M
7 (e)
EER model.
5 M
More question papers from Database Management Systems