Annamalai University 2010-2nd Year Bachelor in Computer Applications (BCA) B.C.A & 2011 - Question Paper
Register Number :
Name of the Candidate :
5 7 0 6
B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
( PART - III )
(PAPER - XII)
( Revised Regulations )
(Including Lateral Entry )
December ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION-A (8x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Explain the modern benefits of networking.
2. Explain the network structure.
3. Discuss the network topologies.
4. Write short notes on network operating system.
5. Explain the history of internet working.
6. Discuss internet working challenges.
7. Explain the network interfaces.
8. Explain the different types of firewall.
9. Discuss the message switching.
10. Explain the ISDN services.
SECTION-B (3 x 20 = 60)
Answer any THREE questings.
All questions carry equal marks.
11. (a) Discuss the development of computer
networks.
(b) Describe the network applications.
12. Describe any four-transmission media.
13. (a) Describe the internet working models.
(b) Explain the ISO OSI reference model.
14. (a) Explain the different types of bridges.
(b) Describe the network security beyond firewalls.
15. (a) Explain the concept of circuit switching and packet switching.
(b) Discuss ISDN architecture.
Name of the Candidate :
17 0 6 B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
(PART-III)
( PAPER - XII)
(Revised Regulations )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION-A (8x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Explain the modern benefits of computer networks.
2. Write short notes on network software.
3. Explain the network components.
4. Discuss wireless media.
5. Explain the history of internet working.
6. Discuss internet working challenges.
7. Explain the concept of Hubs.
8. Explain the different types of switches.
9. Explain the characteristics of WAN.
10. Discus ISDN signaling.
SECTION - B (3 x 20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. (a) Discuss network software.
(b) Describe the various network applications.
12. (a) Explain the two types of co-axial cable, (b) Describe the communication schemes.
13. (a) Discus internet working models.
(b) Describe the ISO OSI reference model.
14. (a) Explain the concept of proxy servers.
(b) Discuss network security.
15. (a) Discuss various switching methodologies, (b) Describe the ISDN architecture.
7. List the different types of firewalls.
8. What is meant by routers ? Explain.
9. List the characteristics of LAN.
10. Enumerate the use of ISDN.
PART - B ( 3x20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. Explain the use of computer networks in detail.
12. Explain in detail network operating systems.(20)
13. (a) What are the advantages of reference
models ? Explain. (10)
(b) Write a note on internetworking models.(10)
14. What is switching ? Explain the different types of switching and their advantages. (20)
15. (a) List the salient features of
(i) LAN.
(ii) WAN. (5+5) (b) Write a note on message switching. (10)
Name of the Candidate :
B.C.A. DEGREE EXAMINATION, 2011
(SECOND YEAR)
(PART - III)
( PAPER - XII)
260. COMPUTER NETWORKS
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A ( 8x 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. What is meant by network ? Explain.
2. Write a note on network software.
3. Explain about twisted pair.
4. Explain the different communication schemes.
5. Explain the challenges faced in internetworking.
6. Explain about the history of internet.
Turn Over
4
Prepare a cost sheet to show the prime cost, factory cost and total cost of production of 3,000 units.
8. From the following particulars, calculate the sales required to earn a profit of Rs. 1,20,000 :
Rs.
Sales - 6,00,000
Variable costs - 1,37,500 Fixed costs - 1,80,000
9. What is capital budgeting? State its importance.
10. Explain the concept of working capital.
SECTION - B (3 x 20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. From the following trial balance as on 31st March, 2010, prepare the trading and profit and loss account for the year ended 31st March, 2010 and a balance sheet as on that date :
Register Number :
Name of the Candidate :
5 6 9 1
B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
( PART - III)
(PAPER - VIII)
620 /220. BUSINESS AND ACCOUNTING
(New Regulations and Revised Regulations)
(Including Lateral Entry Systems ) December ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION-A (8x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Why and how trial balance is prepared?
2. Draft journal entries for the following transactions :
(a) Purchased goods for cash from M/s. X & Co. Rs. 5,000.
(b) Purchases returns to M/s Y & Co. Rs. 500.
(c) Bought furniture from Godrej Company for cash Rs. 30,000.
(d) Insurance premium paid in advance Rs. 600.
3. State the limitations of financial statements analysis.
4. What is meant by ratio analysis ?
5. How does marginal cost differs from total cost ?
6. Rectify the following errors unearthed before the preparation of trial balance :
(a) Good sold to Exe for Rs. 500 has been entered in the purchases book.
(b) Rs. 5,250 paid for wages to workmen for construction of cycle shed has been debited to wages account.
(c) Insurance premium paid Rs. 300 on proprietors life insurance policy has been debited to sundry expenses account.
(d) Goods returned by Wye Rs. 200 was found to be unrecorded though included in stock on hand.
A small scale manufacturer has given to you the following information relating to the manufacture of a standard product (output
3,000 units) for the month of March, 2010 :
|
Rs. | |
|
Raw materials consumed |
- 60,000 |
|
Direct wages |
- 18,000 |
|
Manufacturing overheads |
- 11,280 |
|
Administrative overheads |
- 18,100 |
|
Selling overheads |
- 6,250 |
|
Particulars |
Rs. |
Rs. |
|
Drawings |
20,000 |
- |
|
Captial |
- |
1,89,000 |
|
Plant and Machinery |
80,000 |
- |
|
Sundry debtors |
70,000 |
- |
|
Sundry creditors |
- |
50,000 |
|
Purchases |
1,03,000 |
- |
|
Sales |
- |
2,20,000 |
|
Sales returns |
10,000 |
- |
|
Wages |
40,000 |
- |
|
Cash in hand |
5,000 |
- |
|
Cash at bank |
10,000 |
- |
|
Salaries |
38,000 |
- |
|
Stock on hand (1-4-2009) |
45,000 |
- |
|
Rent |
10,000 |
- |
|
Manufacturing expenses |
7,000 |
- |
|
Bills receivable |
12,000 |
- |
|
Bills payable |
- |
20,000 |
|
Bad debts |
5,000 |
- |
|
Carriage inwards |
9,000 |
- |
|
Furniture |
15,000 |
- |
|
4,79,000 |
4,79,000 |
Stock on 31st March, 2010 was valued at Rs. 50,000.
12. What do you understand by flexible budjet? When it is desirable to prepare ?
13. The expenses for budgeted production of
10,000 units of a standard product in a factory are furnished below :
|
Per unit | |
|
Materials |
140 |
|
Labour |
50 |
|
Variable overheads |
40 |
|
Fixed overheads (Rs. 2,00,000) |
20 |
|
Variable expenses (Direct) |
10 |
|
Selling expenses (10 % fixed) |
26 |
|
Distribution expenses (20 % fixed) |
14 |
|
Administration expenses (Rs. 1,00,000) |
10 |
|
Total cost per unit |
310 |
Prepare a budget for production of 8,000 units and 6,000 units and indicate cost per unit at both levels.
Assume that administration expenses are fixed for all levels of production.
14. What is funds flow statement? State its managerial uses.
15. A company is considering to replace on existing machine by the new one. There are two models Mj and M2 of the new machine. Prepare a statement of profitability sharing the pay-back period from the following information and advise the company about the model to be preferred from the information given below :
|
Model M |
Model M2 | |
|
Estimated life (years) |
4 |
5 |
|
Rs. |
Rs. | |
|
Cost of machine |
18,000 |
36,000 |
|
Estimated savings in | ||
|
scrap |
1,000 |
1,600 |
|
Estimated savings in | ||
|
direct wages |
12,000 |
16,000 |
|
Additional cost of | ||
|
maintenance |
1,600 |
2,000 |
|
Additional cost of | ||
|
supervision |
2,400 |
3,600 |
P1
A
Stock on 31st March, 2009 was valued at Rs. 26,800.
Prepare the final accounts for the year ended 31st March, 2009.
Register Number :
Name of the Candidate :
16 9 1 B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
(PART-III)
(PAPER - VIII)
620 /220. BUSINESS AND ACCOUNTING
(New Regulations and Revised Regulations)
(Including Lateral Entry )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION-A (8x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. What is Trial Balance? State the errors disclosed by it.
2. The following data are extracted from the published accounts of two companies :
|
EXE Ltd. Rs. |
WYE Ltd. Rs. | |
|
Sales |
32,00,000 |
30,00,000 |
|
Profits after tax |
1,23,000 |
1,58,000 |
|
Equity capital |
10,00,000 |
8,00,000 |
|
Long term debt |
8,00,000 |
6,60,000 |
|
Creditors |
3,82,000 |
5,49,000 |
|
Short term bank credit |
60,000 |
2,00,000 |
|
Inventories |
3,31,000 |
8,09,000 |
|
Other current assets |
5,44,000 |
4,52,000 |
|
Fixed assets |
15,59,000 |
15,90,000 |
You are to prepare a statement of comparative liquidity and profitability ratios of the two companies.
3. Explain briefly how comparative income statements are prepared.
4. Explain any two methods of costing.
15. The following is the trial balance of a small scale manufacturer as on 31st March, 2009 :
|
Debit Rs. |
Credit Rs. | |
|
Cash in hand |
540 |
- |
|
Cash at bank |
12,630 |
- |
|
Purchases |
1,40,675 |
- |
|
Sales |
- |
2,58,780 |
|
Returns inwards |
2,680 |
- |
|
Returns outwards |
- |
1,500 |
|
Wages |
20,480 |
- |
|
Fuel and power |
4,730 |
- |
|
Carriage on sale |
3,200 |
- |
|
Carriage on purchases |
2,040 |
- |
|
Stock (1-4-2008) |
25,760 |
- |
|
Buildings |
30,000 |
- |
|
Freehold land |
20,000 |
- |
|
Machinery |
20,000 |
- |
|
Patents |
7,500 |
- |
|
Salaries |
15,000 |
- |
|
General expenses |
13,000 |
- |
|
Insurance |
600 |
- |
|
Drawings |
15,245 |
- |
|
Capital |
- |
82,000 |
|
Sundry debtors |
14,500 |
- |
|
Sundry creditors |
- |
6,300 |
|
3,48,580 |
3,48,580 |
13. Define marginal costing and explain the advantage of marginal costing.
14. The expenses for the production of 5,000 units in a factory are given as follows :
|
Materials |
Per Unit Rs. 50 |
|
Labour |
20 |
|
Variable overheads |
15 |
|
Fixed overheads (Rs. 50,000) |
10 |
|
Administrative expenses (5 % variable) |
10 |
|
Selling expenses (20 % fixed) |
6 |
|
Distribution expenses (10 % fixed) |
5 |
|
Total cost per unit Rs. |
116 |
You are required to prepare a budget for the production of 7,000 units.
5. There are two projects, X and Y. Each projects requires an investment of Rs. 20,000. You are required to rank these projects according to the Pay Back Method from the following information :
|
Year |
Project - X Rs. |
Project - Y Rs. |
|
1 |
1,000 |
2,000 |
|
2 |
2,000 |
4,000 |
|
3 |
4,000 |
6,000 |
|
4 |
5,000 |
8,000 |
|
5 |
8,000 |
- |
6. Why is capital budgeting significant for a firm?
7. A manufacturer of medicines used machines for personal purposes worth Rs. 200, distributed as samples worth Rs. 1,500 and gave to his office staff worth Rs. 1,000 for their personal use.
Show the treatment of these items in accounts.
8. Explain the various kinds of working capital.
9. Find out the balance or overdraft as per pass book from the following particulars :
(a) Bank overdraft as per cash book on 30th April, 2009 Rs. 2,000.
(b) Cheques issued but not presented for payment Rs. 1,350.
(c) Cheques deposited but not yet collected by bank Rs. 500.
(d) Bank charges Rs. 80 made by the bank not yet entered in the cash book.
(e) Interest on investments collected by the bank and credited in the pass book amounted to Rs. 905.
10. State the objectives of budgetary control.
Answer any THREE questions.
All questions carry equal marks.
11. Describe the different methods used for financial statement analysis.
12. Draft journal entries to rectify the following errors :
(a) Paid wages for the construction of a cycle shed debited to wages account.
(b) Purchased goods for the personal use of the proprietor Rs. 300, debited to purchases account.
(c) Paid repairing charges on an old machinery purchased Rs. 2,500 debited to general expenses account.
(d) Paid rent to landlord Rs. 3,000, debited to landlords account.
(e) Sold old furniture for Rs. 150, passed through sales book.
Register Number :
Name of the Candidate :
B.C.A. DEGREE EXAMINATION, 2011
(SECOND YEAR)
(PART-III)
(PAPER-VIII)
(Including Lateral Entry System )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION-A (8x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. What is Journal? What are the subdivisions of Journal?
2. Rectify the errors in the followings statements before the preparation of Trial Balance:
(a) A sale of old furniture for T 860 has been passed through to sales book.
(b) Licence fee for the proprietors gun 300 has been debited to renewal expenses account.
(c) T 3,750 paid for wages to carpenters for making show - cases had been charged to wages account.
(d) Goods sold to S.Lai & Sons for T 540 has been entered in the sales book as T 450.
3. State the need for financial statements analysis.
4. Explain the usefulness of Trend percentages in the interpretation of financial performance of a company.
5. What are the salient features of marginal costing?
Taxation to be regarded at 50% of profit before charging depreciation. Which model would you recommend to the company for business?
14. What is Budgetary control? State its objectives.
15. For the production of 10,000 Electrical Automatic Irons, the following are the budgeted expenses:
Per unit T
Direct materials - 60
Direct labour - 30
Variable overheads - 25
Fixed overheads (Tl,50,000) - 15
Variable expenses (Direct) - 5 Selling expenses
(10% Fixed) - 15
Administration expenses
( 30,000 rigid for all
levels of production) - 5
Distribution expenses
(20%) fixed) - 5
Total cost of sale per unit 160
Prepare a Budget for production of 6,000 irons showing distinctly the cost per unit.
8. You are given the following data for the year
2009 - 2010.
Variable cost 6,00,000
Fixed cost 3,00,000
Net profit 1,00,000
Sales 10,00,000
Find :
(a) P/V Ratio and (b) B.E.P.
9. State the methods of ranking investment proposals.
10. What is marginal costing? State its utility.
SECTION-B (3 x 20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. From the following particulars, prepare a cost sheet showing
(i) The cost of materials consumed,
(ii) Prime cost,
(iii) Works cost,
(iv) Total cost
and (v) Profit.
Stock of raw materials T
(1st Jan., 2009) 30,850
Work-in-progress (1.1.2009) 60,850
Purchases of raw materials 1,43,250
Direct wages 1,78,500
Factory overheads 1,42,800
General overheads 1,12,700
Stock of raw materials
(31st Dec., 2009) 37,700
Work-in-progress
(31st Dec., 2009) 67,750
Sales for the year 8,60,625
12. Explain the various factors influencing the working capital requirement.
13. None such company is considering the purchase of a new machine which will carryout some operations performed manually. X and Y are alternative models. From the following information, you are required to prepare a profitability statement and work out the payback period for each model.
|
Model - X |
Model - Y | |
|
Estimated life (years) |
5 |
6 |
|
Cost of Machine (T) |
1,50,000 |
2,50,000 |
|
Cost of Indirect Materials (T) |
6,000 |
8,000 |
|
Estimated savings in scrap (T) |
10,000 |
15,000 |
|
Additional cost of maintenance (T) |
19,000 |
27,000 |
|
Estimated earnings in direct wages (T) | ||
|
Employees not required (number) |
150 |
200 |
|
Wages per employee (T) |
600 |
600 |
6. Draft Journal entries to record the following
transactions:
(a) Started business with cash borrowed from wife T 1,00,000.
(b) Paid A 1,950 in full settlement of his account for T 2,000.
(c) Draw goods for domestic consumption amounting to T 1,200.
(d) Paid customs duty by cheque T 3,000.
7. Calculate the Gross profit ratio from the following information:
Sales
Sales returns
10,000
Opening stock
20,000
Purchases
60,000
Purchases returns
15,000
Closing stock
5,000
Turn Over
Register Number :
Name of the Candidate :
5 7 0 5
B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
( PART - III)
( PAPER - XI)
250. VISUAL BASIC
( Revised Regulations )
(Including Lateral Entry )
December ] [ Time : 3 Hours
Maximum: 100 Marks
SECTION - A (8x5= 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Write in detail about
(a) Standard properties of text boxes.
(b) Special properties of text boxes.
Turn Over
2. List editing tools and explain briefly.
3. Write a note on the special features of visual basic.
4. Write a short notes on VB tools.
5. Write a VB program to design a form which includes list box.
6. What do you mean by Array ? Explain with an example.
7. What are the different data types used in VB?
8. Explain the decision making statements in VB with their syntax.
9. Compare and contrast functions and procedures.
10. Explain about testing in VB.
Answer any THREE questions.
All questions carry equal marks.
11. How Arrays are used in functions and procedures ? Explain with examples.
12. Explain the COM control inVB.
13. Write a program to insert, update and retrieve employee name and numbers from a database.
14. Create a student mark sheet using VB.
15. Explain about record set objects.
Name of the Candidate :
17 0 5 B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
(PART - III)
( PAPER - XI )
( Revised Regulations )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION - A (8 x 5 = 40)
Answer any EIGHT questions.
1. Write a brief note on forms available in visual basic.
2. Write short notes on VB tools.
3. What do you mean by array?
4. Explain about Do events and sub main with examples.
5. What are the salient features of control array ?
6. Explain conditional statements.
7. Compare and contrast functions and procedures.
8. Explain determine loops with example.
9. Write a brief note on data manager.
10. How do you test a program and find bugs?
SECTION - B ( 3 x 20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. Develop a VB program to simulate the working of a simple calculator.
12. What is file handling? Write a file handling statement inVB.
13. Write a program to insert, update and retrieve employee name and numbers from a database.
14. Write a program to sort and search the numbers.
15. Explain data bound controls.
4. Explain about the dialog box functions.
5. Write a program to sort the numbers in VB.
6. Discuss data types with examples.
7. Explain Rich Text Box and Timer Control with an example.
8. Explain about COM control in VB.
9. Explain the built-in functions.
10. Write a brief note on data manager.
SECTION - B ( 3x20=60)
Answer any THREE questions.
All questions carry equal marks.
11. Develop a VB program to simulate the working of a simple calculator.
12. How do you use list and arrays in functions and procedures ? Explain with an example.
13. Develop a bio-data query form in VB and store the data in a database using controls.
14. Explain databound controls.
15. Explain about error trapping.
Name of the Candidate :
B.C.A. DEGREE EXAMINATION, 2011
( SECOND YEAR )
( PART - III )
(PAPER - XI )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION - A ( 8 x 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. List the various controls available in VB Tools Box.
2. Explain the steps for adding controls to a form.
3. Write a note on the special features of Visual Basic.
Turn Over
4
14. Explain Boyce Codd Normal Form (BCNF ).
15. Explain in detail cursor managemnet in PL-SQL (20)
Name of the Candidate :
5 2 8 5
B.Sc. DEGREE EXAMINATION, 2010
(COMPUTER SCIENCE)
(SECOND YEAR)
(PART - III)
( PAPER - XII)
240. RELATIONAL DATABASE MANAGEMENT SYSTEM
( Revised Regulations )
(Including Lateral Entry )
( Common with B.C.A. Revised Regulations & Double Degree)
December ] [ Time : 3 Hours
Maximum : 100 Marks
Answer any EIGHT questions.
ALL questions carry equal marks.
1. What are obeject based logical models?
2. What are integrity constraints?
3. Explain physical schema.
4. What are the features of ER model ?
5. What are the several aspects of SQL?
6. What is QBE?
7. What are the problems caused by redundency?
8. Explain closure property.
9. What is Anonymous Block inPL-SQL?
10.Write the syntax of while loop inPL-SQL.
PART - B (3 x 20= 60)
Answer any THREE questions.
ALL questions carry equal marks.
11. Explain with a neat diagram, the architecture of a database system.
12. Design and draw an ER diagram for a University project
* Professors have SSN, name and age and research speciality.
* Projects have project number, sponsor name, starting date and ending date.
* Graduate students have SSN, name, age and degree program.
* Each project is managed by one professor.
* Professors can manage multiple projects.
* Each projet is worked on by more than one graduate student.
13. Write short notes on :
|
(a) |
Equi join. |
(5) |
|
(b) |
Cross join. |
(5) |
|
(c) |
Other join. |
(5) |
|
(d) |
Self join. |
(5) |
|
Turn Over |
Name of the Candidate :
12 8 9 B.Sc. DEGREE EXAMINATION, 2010
(COMPUTER SCIENCE)
( SECOND YEAR )
(PART - III)
( PAPER - XI)
240. RELATIONAL DATABASE MANAGEMENT SYSTEM
( Revised Regulations )
[( Common with B.C.A. (Revised Regulations )]
( Including Lateral Entry )
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A ( 8 x 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Explain various queries in DBMS.
2. Define the foreign keys and domain with examples.
3. What are the various relationship defined in ER- diagram ? Explain with examples.
4. Define the various relational calculus used in DBMS.
5. With neat diagram, explain the database commands.
6. Explain the following with examples :
(a) Union.
(b) Inersect.
7. What do you understand by normal form ? Explain any one of normal forms.
8. What are the different kinds of dependency? Explain any one type of dependency.
9. Define the PL/SQL commands.
10. What are the various type of manipulation in PL/SQL ?
Answer any THREE questions.
All questions carry equal marks.
11. (a) Explain various entity relationship model
with examples. (10)
(b) Define the various data model defined in DBMS. (10)
12. (a) Define difference between relational
algebra and relational calculus. (10)
(b) Write a detailed notes on E-R diagram with examples. (10)
13. Explain with example the DLL and DML commands work in SQL. (20)
14. Explain the various features in QBE. (20)
15. Explain the advantage of PL / SQL and process of declaring variables in PL/ SQL. (20)
(c) List the total number of employees in each department with more than 10 employees.
(d) List the project number, project name and no. of employees who work on that project.
13. Explain about Boyce Cod normal form in detail.
14. With neat diagram, explain the database management system architecture.
15. What is database model ? Explain any two type of data model with example.
Name of the Candidate :
B.Sc. DEGREE EXAMINATION, 2011
(COMPUTER SCIENCE)
(SECOND YEAR)
( PART - III)
(PAPER -XII)
240. RELATIONAL DATABASE MANAGEMENT SYSTEM
( Common with B.C.A. &
Double Degree, Including Lateral Entry. )
May ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION - A (8x5=40)
Answer any EIGHT questions.
All questions carry equal marks.
1. What is the role of a DBA ?
2. Compare primary key with foreign key.
3. What is a composite key ?
4. What is generalization in ER diagram ?
5. Write the syntax of SELECT statement with example.
6. Explain about INTERSECT statement with example.
7. What is functional dependance ? Explain.
8. Explain about the anomalies in third normal form.
9. Write the syntax of EXIT WHEN statement in PL-SQL.
10. Explain about the block structure in PL-SQL.
SECTION-B ( 3x20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. Design an ER diagram for an IT training group. The company has 12 instructors and can handle upto 100 trainees for each training section. The company offers 5 advanced technology courses, each of which is taught by a team of 2 or more
instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session.
12. Consider the following relations :
Employee (empID), First Name, Last name, address, DOB, sex, position, dept, no.)
Department (dpt.no, dept.name, mgr, empID)
Project ( Proj.no, proj name, dept.no)
Work on (empID, proj no, hours worked) Write the SQL statement for the following :
(a) List the name and addresses of all the employees of IT dept.
(b) List the total hours worked by each employee, arranged in order of department number, and within department, alphabetically by surname.
Turn Over
Register Number:
Name of the Candidate :
5 2 8 1
B.Sc. DEGREE EXAMINATION, 2010
(COMPUTER SCIENCE)
(SECOND YEAR)
(PART - III)
( PAPER - VIII)
( Revised Regulations )
( Common with B.Sc. (I. T) Revised Regulations and B.C.A. Revised Regulations & Double Degree)
December ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A (8 x 5 = 40)
Answer any EIGHT questions.
ALL questions carry equal marks.
1. Compare multiprogramming systems with multiprocessing systems.
2. Explain contact switch with suitable diagram.
3. Illustrate elevator algorithm with example.
4. What is Beladys anomaly? Explain.
5. What are the design principles of UNIX ?
6. Write short notes on programmer interface in UNIX.
7. Give a note on the history of Windows NT.
8. Write short notes on Windows NT security model.
9. What are the contents of the registration tables in LINUX ?
10. How is security provided in LINUX systems?
SECTION - B (3 x 20= 60)
Answer any THREE questions.
ALL questions carry equal marks.
11. (a) Explain the different types of
operating system structures. (10)
(b) What are the various performance criteria for scheduling algorithms ? (10)
12. Explain in detail the different types of file allocation methods. (20)
13. Write in detail about interprocesses communication in UNIX. (20)
14. Discuss in detail the networking principles of Windows NT. (20)
15. Explain in detail memory management in Linux.
Name of the Candidate :
12 8 5 B.Sc. DEGREE EXAMINATION, 2010
(COMPUTER SCIENCE )
(SECOND YEAR)
(PART - III )
(PAPER - VIII )
( Revised Regulations )
[( Common with B.Sc. (Information Technology) & B.C.A. (Revised Regulaions)]
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A (8 x 5 = 40)
Answers any EIGHT questions.
All questions carry equal marks.
1. Write short notes on buffering and spooling.
2. Explain with neat diagram the different states a process undergoes.
3. Discuss in short thrashing.
4. What are the various operations performed on a file ?
5. Explain the history of UNIX system.
6. Compare DOS with UNIX.
7. What are the design principles of Windows NT ?
8. How is virtual memory management done by Windows NT ?
9. Explain :
(a) Open software. (2)
(b) Licensed software. (2)
(c) Share ware. (1)
10. Explain with example the Fork and Exel commands.
Answer any THREE questions.
All questions carry equal marks.
11. Explain the advantages and disadvantages of shortest job first scheduling and round roking scheduling with example.
12. Explain Bankers algorithm with suitable example.
13. Explain UNIX file system with a neat diagram.
14. Discuss in detail the various system components of Windows NT.
15. Discuss the various Kernel Modules in LINUX.
5. Explain the UNIX I/O system.
6. Explain the UNIX user interface.
7. Write short notes on Windows NT file system.
8. Briefly explain the history of Windows NT.
9. Discuss about Linux scheduling.
10. Explain the Linux file system.
PART - B ( 3x20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. Describe any two preemptive process scheduling algorithms with an example.
12. Explain the segmented memory management.
13. Describe the implementation of UNIX interprocess communication.
14. Describe the Windows NT history and design principles.
15. Explain the Linux process and memory management.
Name of the Candidate :
B.Sc. DEGREE EXAMINATION, 2011
(COMPUTER SCIENCE)
(SECOND YEAR)
220 / 250 / 210. OPERATING SYSTEMS
[ Common with B.Sc.(I. T) & B.C.A.& Double Degree, Lateral Entry J
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A ( 8x 5=40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Explain the operating system structure.
2. Explain the FCFS process scheduling algorithm with an example.
3. What are the necessary conditions for a deadlock ? Explain.
4. Describe the single contiguous memory management.
Turn Over
Register Number :
Name of the Candidate :
5 7 0 4
B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR)
( PART - III)
(PAPER - IX)
230. DATA STRUCTURES AND ALGORITHMS
( Revised Regulations )
(Including Lateral Entry )
December ] [ Time : 3 Hours
Maximum: 100 Marks
PART - A (8x5= 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Explain the various operations of data structures.
2. Explain the recursion application of stack.
3. With the help of a procedure, explain the insertion of a node at the end of a singly linked list.
4. Explain circular queue with a neat diagram.
5. Write a short note on binary tree representation.
6. Explain with an example, how a general tree can be converted into a binary tree.
7. Explain the selection sort with an example.
8. Write the procedure for merge sort and explain.
9. Explain tree search with an example.
10. Explain any one method of hashing.
PART - B (3 x20= 60)
Answer any THREE questions.
All questions carry equal marks.
11. (a) Explain the operations on a list with
examples. (10)
(b) Explain with an example, how in-fix notation can be converted into pre-fix notation. (10)
12. (a) Explain the simulation using linked lists.(10)
(b) Write a detailed note on other list structures. (10)
13. Explain the various binary tree traversal methods with examples. (20)
14. Explain the following with a procedure and example :
(a) Tree sort.
(b) Radix sort. (20)
15.(a) Explain binary search with a procedure and example. (10)
(b) Explain general search trees with examples. (10)
Name of the Candidate :
17 0 4 B.C.A. DEGREE EXAMINATION, 2010
(SECOND YEAR )
(PART - III)
(PAPER - IX )
230. DATA STRUCTURES AND ALGORITHMS
(Revised Regulations)
( Including Lateral Entry )
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A ( 8 x 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. What is meant by data type ? Write short notes on its various types.
2. Explain the push operation of a stack with a procedure and an example.
3. Briefly explain the sequential representation of a queue.
4. Write a procedure to delete a node from the linked list. Explain it with an example.
5. What is a binary tree? Write a brief note on the sequential representation of the binary tree.
6. Write a brief note on the properties of a binary serach tree.
7. Explain the insertion sort with a procedure and example.
8. Write a procedure for selection sort. Explain it with an example.
9. Explain the linear search method with a procedure.
10. Write a brief note on division method in hashing technique.
Answer any THREE questions.
All questions carry equal marks.
11. Describe the various applications of stack.
12. Write a procedure to arrange the nodes in ascending order in a linked list. Explain with an example. (20)
13. Explain in detail, the conversion of general trees to binary trees. (20)
14. Describe the tree searching method. (20)
15. Describe the general search trees. (20)
Name of the Candidate :
B.C.A. DEGREE EXAMINATION, 2011
( SECOND YEAR )
(PART - III )
(PAPER - IX )
230. DATA STRUCTURES AND ALGORITHMS
May ] [ Time : 3 Hours
Maximum : 100 Marks
PART - A ( 8 x 5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Briefly explain the various data structues.
2. Briefly explain the various operations of data structures.
3. What is queue ? Write a short note on the sequential representation of a queue.
4. Write a brief note on the various list structures.
5. Briefly explain the various binary tree representations.
6. Briefly explain about the applications of trees.
7. Explain about insertion sort with an example.
8. Explain about merge and radix sorts with examples.
9. Explain the breadth first search procedure with an example.
10. Explain about the depth first search procedure with an example.
PART - B ( 3x20=60)
Answer any THREE questions.
All questions carry equal marks.
11. (a) Explain the various operations of stacks with
examples. (10)
(b) Explain how an in-fix notation can be changed to post-fix and pre-fix notation.(10)
12. (a) Describe the various operations of queues.
(10)
(b) Explain in detail, about the various insertions in a singly linked lists. (10)
13. (a) Explain any two binary tree traversal
methods with examples. (10)
(b) Explain the Huffman algorithm with an example. (10)
14. (a) With a procedure and example, explain quick
sort method. (10)
(b) Explain about address calculation sort with procedure and example. (10)
15. (a) Describe about general search trees. (10) (b) Write a detailed note on hashing. (10)
|
Attachment: |
| Earning: Approval pending. |
