Maharashtra State Board of Technical Education 2012-3rd Sem Diploma Computer Engineering for Computer EngineeringSubject RDBMS (12065) - Question Paper
MSBTE Summer 2012 exam.
Relational Database Management System RDBMS(12065)
Computer Engineering - 3rd Semester
11122
3 Hours / 100 marks
Instructions - (1) All Questions are compulsory.
(2) Answer each next main Question on a new page.
(3) Figures to the right indicate full marks.
(4) Use of Non-programmable Electronic Pocket Calculator is permissible.
(5) Mobile Phone, Pager and any other Electronic Communication devices are not permissible in Examination Hall.
Marks
Attempt any TEN of the following: 20
a) Enlist advantages of DBMS over file processing system. *
b) Define - -
(i) Primary key
(ii) Candidate key
c) What is DCL?
d) What is meant by data model? Enlist different types of . data model.
e) What is meant by data redundancy? -
f) What is meant by query optimization?
g) What is deadlock?
h) Write various states of transaction. *
i) Enlist different components of DBMS, j) Write advantages of network model.
k) Define -
(i) Domain
(ii) Attribute
1) What is specialisation?
Attempt any FOUR of the following:
a) Explain client-server architecture?
b) Describe hierarchical model in brief.
c) Compare network and hierarchical model.
d) What is data dictionary and schema processor?
e) Explain data abstraction?
f) What is relational model? Explain attributes and domains.
Attempt any FOUR of the following:
a) Explain entity integrity constraints.
b) Describe relational calculus in brief.
c) What is relational algebra? Classify it.
d) Explain set operator?
e) Describe string function, date and time function? >
f) Explain cursor with an example.
4. Attempt any FOUR of the following:
12065
Marks
[3]
16
a) What are different data types of SQL? Explain with example. *
b) Describe different clauses in SQL. *
c) Explain PL/SQL Block Structure.
d) Explain Group by in SQL with example. v
e) Explain PL/SQL control structures.
f) Draw E-R diagram for hospital database.
5. Attempt any FOUR of the following: 16
a) Explain normalization with multivalued dependencies. -
b) Describe variable length record representation in files, using . Byte-string representation method with the help of example.
c) What is indexing? Explain dense index and sparse index. '
d) Describe in brief 2NF.
e) List and describe in brief several possible ways of organization of records in files.
f) What are different ALTER commands in SQL? Explain with f
example.
6. Attempt any TWO of the following:
a) Describe the general processing strategies in query processing.
b) Explain deadlock presentation scheme.
c) Explain with example time stamp based protocol.
16
4. Attempt any FOUR of the following:
12065
Marks
[3]
16
a) What are different data types of SQL? Explain with example. *
b) Describe different clauses in SQL. *
c) Explain PL/SQL Block Structure.
d) Explain Group by in SQL with example. v
e) Explain PL/SQL control structures.
f) Draw E-R diagram for hospital database.
5. Attempt any FOUR of the following: 16
a) Explain normalization with multivalued dependencies. -
b) Describe variable length record representation in files, using . Byte-string representation method with the help of example.
c) What is indexing? Explain dense index and sparse index. '
d) Describe in brief 2NF.
e) List and describe in brief several possible ways of organization of records in files.
f) What are different ALTER commands in SQL? Explain with f
example.
6. Attempt any TWO of the following:
a) Describe the general processing strategies in query processing.
b) Explain deadlock presentation scheme.
c) Explain with example time stamp based protocol.
16
|
Attachment: |
| Earning: Approval pending. |
