Osmania University (OU) 2007 B.E Computer Science /e main - Question Paper
Code No. 4218
FACULTY OF ENGINEERING B.E. 3/4 (CSE) I Sem. Suppl. Examination June - 2008 Subject: Data Base Management System
Note : (a) Answer all questions from Part-A and
(b) Answer five questions from Part-B.
PART - A (25 marks)
1. What is meant by Data Abstraction ? Explain. 3
2. Briefly explain about Weak Entity. 2
3. Describe aboutDomain Constraints. 3
4. Explain when a relation is said to be in First Normal Form. 2 '
5. List and explain about various steps in Query Processing. 3
6. Briefly explain aboutPinned Record. 2
7. Explain how to transform a Relational Expression. 3
8. Draw and explain State Diagram of a Transaction. 2
9. What is meant by Database Buffering ? Explain. 3
10. Explain about Stable Storage, 2
PART-B (5x10=50 marks)
11. (a) Describe about Storage Manager. 5
(b) Explain how to reduce E-R diagrams to tables. 5
12. (a) Explain about the following 3+3
(i) Security
(ii) Third Normal Form
(b) Differentiate between group by and order by clauses in SQL. 4
C- 103
13. (a) Construct the B+Tree and B-Tree for the following set of search key values where a node in the tree can accommodate three pointers. 3+3
15 25 35 45 55 65 75 85
(b) Describe about Dynamic Hashing. 4
14. (a) Describe about ACID Properties. 4
(b) Explain the following 3+3
(i) Conflict Equivalent
(ii) Catalog Information
15. (a) Describe about Immediate Database Modification. 4
(b) Explain the following. 3+3
(i) Transaction Rollback
(ii) Parallel Database Architecture
16. (a) What is the functionality of following operations in Relational Algebra ? 6
Rename Division Natural-Join
(b) Explain how to design the database. 4
17. Write short notes on any two of the following. 5+5
(a) Encryption
(b) Assertions
(c) Distributed Systems
Code No. 4025
FACULTY OF ENGINEERING B.E. 3/4 (CE/CSE/IT)I-Sem. Suppl. Examination
June - 2008 Subject: Managerial Economics and Accountancy
Time : 3 hours ] [Max. Marks : 75
Note : Answer all questions of Part A.
Answer five questions from Part B.
PART - A (25 Marks)
|
1. |
Define Managerial Economics. |
|
2. |
Distinguish between firm and industry. |
|
3. |
Demand Function. |
|
4. |
Briefly explain internal economies of scale. |
|
5. |
Explain the concept of Law of Demand. |
|
6. |
Monopoly and Duopoly. |
|
7. |
Differentiate between Cash discount and Trade discount. |
|
8. |
Why an analytical Petty Cash Book is maintained ? |
|
9. |
What is a Trial Blance ? |
|
10. |
How Bad debts are dealt in Final Accounts ? |
PART - B (5*10=50 Marks)
11. Explain the scope of Managerial Economics, also explain its relationship with other sciences.
12. What is perfect competition ? How the price and output are determined under perfect competition ?
13. What is working capital ? Explain the factors determining working capital requirements of a firm.
14. What is demand forecasting. ? Explain different methods of demand forecasting.
15. (a) What are the managerial uses of Break-even Analysis ?
(b) Find out the Break-even point and sales value to earn a profit of Rs.60,000.
Selling price per unit Rs. 15 Variable Cost per unit Rs. 10 Fixed Cost per unit Rs. 1,50,000
16. A decision is to be made between two cmpeting projects which require an equal investment of Rs.50,000 and are expected to generate net cash flows as under:
Years 1 2 3 4 5 6
Project-I 25000 15000 10000 Nil 12000 6000
Project-II 10000 12000 18000 25000 8000 4000
The cost of capital of the company is 10 % which project should be chosen ? Evaluate the project proposals under pay back period.
17. Prepare Trading and Profit & Loss Accqunt and Balance Sheet from the following particulars:
Trial Balance as on 31-12-2007.
|
Particulars |
Dr. Balance |
Cr. Balance |
|
Purchases |
16,000 |
-- |
|
Discount |
1,300 |
-- |
|
Wages |
6,500 |
-- |
|
Travelling Expenses |
500 |
-- |
|
Salaries |
2,000 |
-- |
|
Carriage Inwards |
275 |
-- |
|
Insurance & Rent |
150 |
-- |
|
Commission |
825 |
-- |
|
Cash at Bank |
2,750 |
-- |
|
Sundry expenses |
355 |
-- |
|
Interest on loan |
100 |
-- |
|
Buildings |
4,000 |
-- |
|
Machinery |
2,000 |
-- |
|
Opening Stock |
5,750 |
-- |
|
S. Debtors |
3,250 |
-- |
|
Capital |
-- |
10,655 |
|
Sales |
-- |
30,000 |
|
Loan |
-- |
3,000 |
|
S. Creditors |
- - |
2,100 |
45,755 45,755
Adjustments:
1. Closing stock Rs.6000
2. Rent outstanding Rs.60
C - 97/700
|
Attachment: |
| Earning: Approval pending. |
