Wednesday, May 28, 2008

COBOL AND DATA PROCESSING

2028/DC2 May 2008
Paper II - COBOL and Data Processing
Time: Three Hours Maximum: 100 Marks

Part A - (20x2 = 40 Marks)
Answer ALL Questions

  1. Explain about A margin and B Margin. Give example.
  2. Write the purpose of IDENTIFICATION DIVISION.
  3. Write the machine dependent section
  4. Give the level numbers used for RENAMES Clause and CONDITION NAMES.
  5. Give examples for Numeric and Non-Numeric literals.
  6. Specify any two sections of DATA DIVISION.
  7. What is a statement?
  8. Write the equivalent statement in COBOL if BASIC <>
  9. Mention a few relational operators in COBOL.
  10. What is CONDITION-NAME condition?
  11. How do you organize if 'if block' or 'else block' contains more than one statement? write the syntax of your organisation.
  12. What is the purpose of ALTER statement?
  13. Give the syntax of SET verb.
  14. List down the different types of condition.
  15. Give the flow chart for PERFORM...........VARYING.
  16. What is the purpose of REDIFINE Clause?
  17. What is meant by file updation?
  18. What is the purpose of RECORD CONTAINS Clause in FD?
  19. Explain the terms
    1. Logical Record
    2. Unblocked File
  20. What is an optional file? How can it be specified? Explain

    PART B (5x12 = 60 Marks)
    Answer ALL questions
  21. (a) Explain the FILE SECTION and WORKING-STORAGE SECTION in the DATA DIVISION in detail
    Or (b) Write in detail the various editing features available in COBOL.
  22. (a) Write a COBOL program for performing a Multiplication
    or (b) A Cloth shop offers a festival discount for the following items:
    SAREE COST > 50 DISCOUNT 50%
    SHIRT COST > 150 DISCOUNT 25%
    OTHER-ITEMS NO DISCOUNT
    write a program to implement the above using condition name.
  23. (a) Write a note on
    (i) Qualification of Data Names
    (ii) SIGN Clause
    or (b) Write a COBOL Program to count the number of words in a given text
  24. (a) Explain STRING and UNSTRING Verbs with examples
    or (b) Explain any four procedure division statements of sequential file
  25. (a) Write a program in COBOL for the central library to read data in the following format:
    1-5 Book Code
    6-25 Title
    26-30 Price
    31-40 Publication
    41-50 ISBN
    51-55 Category
    56-60 Edition
    61-65 Month of pricuring.
    The program should ensure that:
    (i) Book code is within the range 00001 to 19999
    (ii) Price is a positive integer.
    (iii) Title is not blank.
    (iv) ISBN should contain only numbers.

    Also calculate the money spend in a given month for the procurement of books

    or
    (b) Write a program to calculate income-tax of each employee from their annual with the following conditions:
    Annual Income Income Tax
    >0 and <= 100000 NIL
    >100000 and <= 150000 20% of annual income
    above 1500000 30% of annual income

Sunday, May 18, 2008

Software Engineering

DC 3 October 2004
Answer ALL questions
  1. Write down three dimensions of the quality of software product.
  2. How programmers spend their time in software engineering while developing the software?
  3. What are the activities in management process?
  4. What are the difference between throwaway approach and evolutionary approach?
  5. What are the functions of democratic team in a project?
  6. Define: Portability
  7. What are the major factors that influence software cost?
  8. What are the components of risk management plan?
  9. Define: Modularity
  10. What are the different levels of cohesion?
  11. What is a data flow diagram?
  12. What are HIPO diagram?
  13. What are the primary goal of object oriented programming?
  14. What are the activities performed by the 'Test Plans' ?
  15. Define: Walk Through
  16. What are the uses of symbolic execution tool?
  17. Explain: Validation
  18. Explain: Functional testing.
  19. What is meant by time in reliability models?
  20. Explain structural induction
    PART B - (5x12 = 60 Marks)
  21. (a) Explain different characters of a software process.
    or (b) Explain the the factors that influence quality and productivity in software development
  22. (a) Explain the COCOMO model in detail
    or (b) Explain different types of software risks in detail.
  23. (a) Explain various design notation and specification used in the design phase of software development.
    or (b) Explain various techniques for verification.
  24. (a) Explain the following
    (i) Topdown approach
    (ii) Bottom-up approach
    or (b) Write short notes on
    (i) Data Binding
    (ii) Mile Stones
    (iii) Inspections
  25. (a) Explain various testing process in detail.
    or (b) Explain the activities performed during S/W development to enhance the maintainability of a S/W product.

Information Technology and it's application

DC 7 October 2007
Paper VII - Information Technology and It's Applications
Time: Three Hours

Answer ALL the questions
Part A (20x2 = 40 Marks)
  1. What are webpages?
  2. What is the purpose of web browsers.?
  3. Define File Transfer Protocol.
  4. What is an internet?
  5. Write a note on ARPANET.
  6. What is HTTP?
  7. What is the main advantage of E-Mail?
  8. Write the use of Microsoft Outlook Express.
  9. Distinguish between FTP Site and FTP Server.
  10. Define Dial-up connection.
  11. What is the purpose of MODEM?
  12. What is ISDN Service?
  13. Define Simplex Transmission.
  14. What is an odd parity?
  15. Define Protocol
  16. What are web servers?
  17. What is IRC?
  18. What is the structure of an email address?
  19. What are mailing lists?
  20. Define TCP/IP.
  21. (a) Explain the history of Internet
    or (b) Describe the different services provided by the internet.
  22. (a) Discuss about Domain Name System IP addressing
    or (b) Describe the arrangement and equipement for connection ISPs.
  23. (a) Describe the setps to configure our machine for TCP/IP.
    or (b) Explain the following
    (i) Parity
    (ii) Duplex
  24. (a) Describe th working of E-Mail
    or (b) Explain the advantages and disadvantages of E-Mail.
  25. (a) Descibe the benefits of Information Provider
    or (b) Explain about Search Engines.

Windows and Visual Basic

5043/DC 6
October 2007

Paper VI - Windows and Visual Basic
Time: Three Hours

Answer ALL questions
PART A - (20x2=40 Marks)
  1. Write a note on Control Panel Icon.
  2. List down the features of Windows.
  3. How to create a new folder?
  4. What are Mouse Events?
  5. How to save a word document?
  6. How to change the font size in word document?
  7. Write a note on: Autotext features in MS-Word.
  8. Define: Range
  9. How to delete a row in a worksheet?
  10. Write a note on: Pie chart.
  11. List the names of menus in VB Screen.
  12. What is the purpose of Msgbox() function?
  13. Write a note on: Properties Windows.
  14. How to introduce comments in VB Program?
  15. Write a note on: Command Button.
  16. What are functions?
  17. List the datatypes in VB.
  18. List the form properties.
  19. How to startup forms?
  20. What are control arrays?
  21. (a) Explain the activities in selecting, moving and sizing windows
    or (b) Discuss the various features of MS-Word
  22. (a) Explain the uses of various in EDIT menus of MS-Word
    or (b) Explain the Auto correct and Auto Save features in MS-Word
  23. (a) Write a VB program to convert Temperature in celcius to Frenheit and vice versa.
    or (b) Explain about scroll bars and check box controls in VB.
  24. (a) Explain the use of any six mathematical functions in MS-Excel with examples.
    or (b) Explain about creating copying and moving operations in MS-Excel.

Client Server Computing with Oracle

5042/DC5 October 2007
Paper V - Client/Server Computing with Oracle
Time: Three Hours

Answer All Questions
Part A - (20x2 = 40 Marks)
  1. Define Relational Model
  2. What are attributes?
  3. Define: Concurrency.
  4. Define: DBMS.
  5. What is meant by client?
  6. Define: Object Oriented Programming.
  7. Give the general syntax of INSERT command.
  8. What is SQL?
  9. Write a note on commit Command.
  10. Define: DDL.
  11. What are variables?
  12. Define: function.
  13. What are triggers?
  14. List the functions of DBA.
  15. Define: Database Back up.
  16. Define: Domain.
  17. What is meant by Client/Server model?
  18. Define: Role
  19. What are Blocks in PL/SQL?
  20. What is DBA?

    Part B - (5x12=60 Marks)

  21. (a) What are the advantages and disadvantages of Relationl Model? Discuss briefly.
    or (b) Discuss about Database security and Data integrity.
  22. (a) Explain the benifits and pitfalls of client/server computing
    or (b) write a short notes on client application interface.
  23. (a) Explain the general syntax of the following statements in SQL with examples.
    (i) Select
    (ii) Update
    (iii) Delete
    or (b) Describe in detail, the use of any TEN nemeric functions with examples.
  24. (a) Explain the different loop structures in PL/SQL with examples.
    or (b) Write a PL/SQL statement to find the area and circumference of a circle.
  25. (a) Describe the general syntax of 'create procedur' command with example.
    or (b) write short notes on Server Manager Interface.