SKR Engineering College 2007 B.E Information Technology CS1203 – SYSTEM SOFTWARE - Question Paper

ii) discuss Heap File (6)
(or)
b) i) discuss the need and working of distributed database. (8)
ii) Write short notes on complex data kinds. (8)

3. a) Write briefly on:
o Data warehousing (8)
o Data mining (8)
(or)
b) discuss the structure of XML data and document. (16)

4. a) i)Explain lock-based protocols and time-stamp based protocols.(8)
ii) discuss the conflict serializability and view serializability(8)
(or)
b) i) discuss about the transaction state and implementation of atomicity and durability.(8)
ii) Why concurrency control is needed.?(8)
5. a) i) When do you say that system is in a deadlock? discuss. (8)
ii) discuss the 2 approaches to deadlock prevention. (8)
(or)
b) i) discuss any 2 recovery techniques. (8)
ii) discuss about 2 phase locking. (8)


-All the Best-
















Engineering College
Department of Computer Science and Engineering
Internal Test-I

Semester : V Time: 100 minutes
Subject Name: Database Management Systems Date: 02/08/06

Part-A 2*5=10
1. Define DBMS.
2. What is data abstraction?
3. Write the application of DBMS
4. What is instance and schema?
5. What are the instruction execution steps in hardware-based speculation?

Part-B 8*5=10
6. Explain in detail about Data models.
7. Explain database system structure
8. Explain in detail about extended ER features.
9. Write short notes on the subsequent.
a. Constraints
b. Keys
c. Weak Entity sets
10. Explain in detail about ER diagram. provide the ER diagram for banking Enterprise.

















S.K.R Engineering College
Department of Computer Science and Engineering
Internal Test-I

Semester : V Time: 100 minutes
Subject Name: Database Management Systems Date: 02/08/06

Part-A 2*5=10
11. Define DBMS.
12. What is data abstraction?
13. Write the application of DBMS
14. What is instance and schema?
15. What are the instruction execution steps in hardware-based speculation?

Part-B 8*5=10
16. Explain in detail about Data models.
17. Explain database system structure
18. Explain in detail about extended ER features.
19. Write short notes on the subsequent.
d. Constraints
e. Keys
f. Weak Entity sets
20. Explain in detail about ER diagram. provide the ER diagram for banking Enterprise.



























S.K.R Engineering College
Department of Computer Science and Engineering
Internal Test-III
Semester : V Time: 100 minutes
Subject Name: Database Management Systems Date: 06/10/06
Part-A 2*5=10
1. Define functional dependency
2. What is heap file?
3. Define transaction.
4. Draw the structure of a typical node of a B+ tree and discuss briefly.
5. Stat the different pitfalls in relational database.
Part-B 8*5=40
6. State the goal of decomposition /normalization .Explain the level of normalization with example. (8)
7. What is hashing technique? discuss the hash file organization (8)
8. Write short notes on the subsequent.
a. Heap files (4)
b. Sorted file (4)
9. Explain the conflict serializability and view serializability (8)
10. Explain the B+ trees file organization methods: (8)

-All the Best-












S.K.R Engineering College
Department of Computer Science and Engineering
Internal Test-III
Semester : III Time: 100 minutes
Subject Name: System Software Date:07.10.06
Part-A 2*5=10
1. What is a absolute loader?
2. What is the function of linkage editor?
3. What is a linking loader?
4. List out any 2 loader choices with example.
5. Mention the usage of the directory by a loader.

Part-B
1. Explain the problems related to a loader.
a. Relocation (6)
b. Program linking (6) (12)
2. Explain the machine independent features of loader (8)
3. Explain the algorithm and data structures of a linking loader. (12)
4. What is bootstrap loader? discuss. (8)
-All the Best-

Earning:   Approval pending.