Docstoc

PGDCA_NS_

Document Sample
PGDCA_NS_ Powered By Docstoc
					 DE–028                                                 11


                             DISTANCE EDUCATION

               P.G.D.C.A. (NS) EXAMINATION, DECEMBER 2010.

              INFORMATION TECHNOLOGY AND MANAGEMENT

                                   (2000 onwards)

Time : Three hours                       Maximum : 100 marks

                            Answer any FIVE questions.

                          All questions carry equal marks.

1. (a)     Write note on IT and the manager?                 (10)

     (b)   Briefly explain changing technology and its applications.
                 (10)

2. Give a detail note on proliferation of computers.         (20)

3. (a)     Define operating system? Explain its functions. (10)

     (b)   Explain the features of word processing.          (10)

4. (a)     What is meant by client server model?             (10)

     (b)   With example explain different Architectures.     (10)

5. Write a brief note on Internet and Electronic Commerce.
                                   (20)

6. (a)     Write a brief note on WAN.                        (10)

     (b)   What is meant by protocol? Explain.               (10)

7. Discuss the impact of IT on management.                   (20)

8. (a)     How storage devices work? Explain various storage devices?
                     (10)

     (b)   Explain in detail about instruction set?          (10)

                                  ————————



                                          1            DE–028
 DE–029                                                         12


                                DISTANCE EDUCATION

               P.G.D.C.A. (N.S.) EXAMINATION, DECEMBER 2010.

                                OFFICE AUTOMATION

                                     (2000 onwards)

Time : Three hours                          Maximum : 100 marks
                               Answer any FIVE questions.
                           All questions carry equal marks.

1.    (a)   Explain the usage of Menu Bars and Tool Bars.

2.    (b)   List the steps necessary to start a program and opening a document in
            WORD.

3.    (a)   How to cut and paste a particular word into a text?

4.    (b)   Explain the steps in changing Font and Font size.

5.    (a)   How to insert, moving and resizing pictures in the word document?

6.    (b)   How is spell–checking invoked in word?

7.    (a)   Explain the Autofill features of Excel.

8.    (b)   Explain the steps to create a work sheet.

9.    (a)   How do you create a chart using chart wizard?

10.   (b)   Write the steps for creating a new database.

11.   (a)   What are the various types of primary keys in Access?

12.   (b)   How do you adding, inserting and deleting records in Access?

13.   (a)   Explain the different types of queries in Access.
14.   (b)   How     to   create     power    point      presentation     from   a    word
            outline?

15.   (a)   Explain      the       procedure          for     creating      slides     in
            power point.
16.   (b)   How tables are created in WORD? Explain.




                                            2               DE–028
                                  ————————
 DE–030                                                      13


                              DISTANCE EDUCATION

               P.G.D.C.A. (NS) EXAMINATION, DECEMBER 2010.

                             PROGRAMMING IN C/C++

                                   (2000 onwards)

Time : Three hours                        Maximum : 100 marks

                            Answer any FIVE questions.

                          All questions carry equal marks.

1. (a)     Explain the structure of C++ program.

     (b)   What are the steps involved in program development? Explain.

2. (a)     How numbers are handled in C? Explain.

     (b)   Explain about different types of constants supported in C.

3. (a)     Explain the formatted I/O in C.

     (b)   Explain I/O supported by C++.

4. (a)     What are the operators supported by C++? Explain.

     (b)   Discuss scope of variables.

5. (a)     Explain if ... else if and Nested if with suitable example.

     (b)   Explain rules for coding for...loop with suitable example.

6. (a)     Explain about any five string functions with suitable example.
     (b)   Write a C program to arrange ten names in alphabetical order.

7. (a)     Compare array and pointers with suitable examples.
     (b)   Write a ‘C’ program to compute factorial using function.

8. (a)     Write a C++ program to read the contents of a file.
     (b)   Write a C program to create a data file.



                                           3            DE–028
                                   ————————
 DE–031                                                      14


                               DISTANCE EDUCATION

                            P.G.D.C.A. (NS) EXAMINATION,
                                   DECEMBER 2010.

                            WINDOWS AND VISUAL BASIC

                                    (2000 onwards)

Time : Three hours                         Maximum : 100 marks

                              Answer any FIVE questions.
                                                              (5  20 = 100)

1. (a)     What is multitasking? Discuss about windows multitasking.
   (10)

2.   (b)   What are the controls used in VB? Explain them.(10)

3. (a)     Describe the windows control panel and explain how can you use Printer
           Manager. (8)

4.   (b)   Illustrate the uses of the following tools :      (12)

           (i)    Msg box

           (ii)   Input Box

           (iii) Check Box.

5. (a)     How do you align and designing the text using Fonts and Styles?
               (10)

6.   (b)   Write a program to implement recursive function.
                                                          (10)

7. (a)     Discuss about virtual memory and PIF Editor.      (10)

8.   (b)   Describe the working principle of FOR.....NEXT statement with an
           example. (10)

9. (a)     Write about Object Linking and Embedding in windows.
                (8)

     (b)   How a control array can be created at run time? Also write the sailent
           features          of           the           control           arrays.
                                                         (12)



                                            4             DE–028
10. (a)     What is Managing Group? Explain.                    (8)

11.   (b)   Write a VB program to prepare student mark statement.
                 (12)

12. (a)     Give short notes on

            (i)    Graphics in windows.

            (ii)   Pagination.                                 (10)

      (b)   Describe the properties of MDI Form.               (10)

13. (a)     Explain about the role of objects in VB.            (8)
      (b)   What is Procedure? Also write an event procedure to convert a text from
            lowercase to uppercase. (12)



                                    ————————
 DE–032                                                        15

                                 DISTANCE EDUCATION

                   P.G.D.C.A. (NS) EXAMINATION, DECEMBER 2010.

                                  RDBMS AND ORACLE

                                    (2000 Onwards)

Time : Three hours                        Maximum : 100 marks

                              Answer any FIVE questions.
                            All questions carry equal marks.

1. (a)      Write a detailed picture of Schema and Subschema.
                               (10)
(b)   Describe the facilities available in Data Manipulation Language (DML). (10)

2. (a)      Explain the semantic problems of Relational Model.
                                                          (10)
(b)   Discuss the mapping operation in SQL with suitable examples.
           (10)

3. (a)      Explain the Data manipulation facilities in Relational Model.
                 (10)
(b)   Explain the three possible Assertions in Data control facilities.
           (10)


                                           5            DE–028
4. (a)      Explain the client/server system.                 (10)
(b)   Give a detailed note on Oracle database architecture.                   (10)

5. (a)      Write about the properties of RDMS and benefits of Oracle.
                 (10)
(b)   Explain in detail on various DATE functions that are used in Oracle.
           (10)

6. (a)      Explain about procedures and functions. How it can be differ each other?
                 (10)
(b)   How can you join multiples tables in Oracle? Explain with examples.
          (10)

7. (a)      What are the data types available in Oracle? Explain.
                (10)
(b)   Explain about Sub Queries in Oracle with examples.
                                                              (10)

8. Write short notes on the following :
(a)   Embedded SQL.                       (10)
(b)   Triggers.                           (10)



                                    ———————
  DE–033                                                      16

                              DISTANCE EDUCATION

                  P.G.D.C.A. (NS) EXAMINATION, DECEMBER 2010.
                      INTERNET AND JAVA PROGRAMMING
                                    (2000 Onwards)

Time : Three hours                          Maximum : 100 marks
                             Answer any FIVE questions.
                           All questions carry equal marks.

1. (a)      Explain the structures of Network Topologies.     (10)
      (b)   Describe the TCP/IP.                              (10)

2. (a)      Describe the different types of ports.            (10)
      (b)   How can you create web server?                    (10)


                                            6         DE–028
3. (a)     Write about mail transfer protocol.                (5)
     (b)   Discuss domain name system.                        (5)
     (c)   Write about Telnet feature.                        (5)
     (d)   Write note on FTP.                                 (5)

4. (a)     Discuss the Entertainment features on the Internet.
                      (10)
     (b)   Discuss the application of Internet at school.    (10)

5. (a)     Write note on electronic commerce.                 (5)
     (b)   How can you find jobs in Internet?                 (5)
     (c)   Describe the different data types available in Java.
                                                             (10)

6. (a)     Discuss array concept in java with example.       (10)
     (b)   Explain control statements in java with example.
                                                          (10)

7. (a)     Discuss class and object with example.            (10)
     (b)   Write note on applet.                              (5)
     (c)   What is constructor overloading?                   (5)

8. (a)     Explain character handling functions with example.
                     (10)
     (b)   Write a program to find sum of given N numbers.
                                                         (10)

                                   ————————
  DE–990                                                    17


                             DISTANCE EDUCATION

                     P.G.D.C.A. (Non–Semester) EXAMINATION,
                                  DECEMBER 2010.

                                C++ AND MS–OFFICE

                                   (2000 onwards)

Time : Three hours                       Maximum : 100 marks
     1.    Examiner has to select ONE from C++ and another from MS Office.

                                          7            DE–028
     2.    Each question carries 50 marks.
     3.    Questions are given to the candidates by lot system.

                                   (C++ PROGRAM)

1. Write a C++ program for temperature conversion between Celcius and
Fahrenheit with options for C to F and F to C.
     Formula : F  9 / 5  C  32 and C  5 / 9  F  32

                             Cut here

2.   Write a C++ program to print the highest mark and the lowest mark in a class
     in                the                 subject                ‘‘programming
     in C/C++’’.

                             Cut here

3.   Write a C++ program to arrange a given set of numbers in ascending and
     descending order.

4 Write a C++ program to read and display the following data : regno, name and sex
of students, with member functions getdata( ) and putdata( ) using class and objects.

                             Cut here

                         5   Write a C++ program to illustrate single inheritance,
                             where the base class consists of the regno, name and sex
                             of students and the derived class, height and weight of
                             students. The program should display the contents on
                             screen.

                             Cut here

                                     (MS OFFICE)

                         1   Prepare PONGAL and DEEPAVALI greeting cards with
                             picture insertion and alignment. Write the procedure to
                             take hard copy.

                             Cut here

                         2   Create the following worksheet on MSEXCEL.
            Regno Name Mark 1 Mark 2 Mark 3 Total Average


                                           8            DE–028
               –        –           –        –        –        –        –

     (a)   Using formula and function find the total, average maximum and
           minimum total marks.

     (b)   Sort the names in alphabetical order.

     (c)   Create the bar chart for average mark with proper titles, legend and
           Gridlines.
(a) Using MS-Excel calculate, mean and standard deviation for the following
format.
     Salesperson name             Amount of sales
                                  1998      1999      2000
           –                        –         –         –
     (a)   Enter the necessary detail.
     (b)   Sort the total sales in descending order.
     (c)   Extract the data whose total sales amount is more than one lakh.
     (d)   Draw the bar chart and switching between 2-D and 3-D chart types.

                                Cut here
                            3   Create address table with following fields
           Field name                  Data type
           Name                  Text
           Age                   Number
           Sex                   Text
           Street                Text
           City                  Text
           PIN                   Number
     (a)   Add 5 records.
     (b)   Display the fields name, street alone on the screen.
     (c)   Display the records for Age > 20
     (d)   Sort the table in the ascending order of name.

                                Cut here

                            4   Prepare three slides with a text and picture expressing
                                the introduction of new product.

                                        ————————
  DE–991                                                     18




                                             9            DE–028
                                 DISTANCE EDUCATION

                  P.G.D.C.A. (NS) EXAMINATION, DECEMBER 2010.

                              VISUAL BASIC AND ORACLE

                                        (2000 onwards)

Time : Three hours                           Maximum : 100 marks
   Examiner has to select TWO questions One from ORACLE and another from
                               VISUAL BASIC.
                             Each question carries 50 marks.
                 Questions are to be given to the candidates by lot system.

                                          ORACLE
   1 (a)   Create table route for the given column definitions.
                               Column Name   Data type
                               Routeid        number (5)
                               Category       number (5)
                               Origin      varchar 2 (20)
                               Destination varchar 2 (20)
                               Fare        number (7, 2)
                               Distance       number (3)
                               Capacity       number (3)
     (b)   Inter values of your own for 5 records from this table.
           (i)     Display all the columns
           (ii)    Display the route id, fare where category is 1
           (iii) Display all the columns with distance greater than 200.
(a) (a)    Write a PL/SQL block to display the reverse of numbers between 1 and
100.

     (b)   Write a PL/SQL block to add sum of digits.
(a) Write a PL/SQL block to satisfy the following conditions accepting routeid as
the user input for the table.
                              Cut here
                               Column Name          Data type
                               Routeid              number (5)
                               Category             number (5)
                               Origin             varchar 2 (20)
                               Destination        varchar 2 (20)


                                             10             DE–028
                               Fare               number (7, 2)
                               Distance             number (3)
                               Capacity             number (3)
      and insert your own data.

      (a)     If the distance is less than 500, then update the fare to be 200.00

      (b)     If the distance is between 501 and 1000 then update the fare with 450.

      (c)     If the distance is greater than 1000, then display a message.
(a) Write a database trigger before delete for each row not allowing deletion and
                            Cut here
give appropriate message on a table. Create a sample table.
(b)   Create the table for super market bill preparations system as follow
      Customer Name
      Item Name
      Cost
      Number of items
      Amount
      Date.
      Write SQL commands to do the following :
      (a)     To display data on the date
      (b)     To display data on the customer name
      (c)     To display high amount and lowest bill
      (d)     Update the amount with cost number of items
      (e)     To list the data with item name.

                                Cut here

                                      VISUAL BASIC
(a) (a) Write event procedure to determine whether the given string is
polindrome or not.
      (b)     Write a procedure to convert temperature from Farenhite to Centigrade.
(a) Create a form with Text Box, Combbox and command button and do the
                        Cut here
following operation
      (a)     Add the university name in the combo box at the run time
      (b)     Sort the university names in the Alphabetical order.




                                             11            DE–028
(a) Using MS Flex grid control, display the multiplication and addition table of 20
rows and 4 columns.
(b) Write a VB project with necessary controls for getting student information like
                           Cut here
roll no, name and percentage. Display the grade using Msg Box. Grade is fixed as
follows.

     if percentage > = 75 Distinction

     Percentage > = 60 and < 75 FIRST Class

     Percentage > = 50 and < 60 Second Class

     Percentage > = 40 and < 50 THIRD Class.
(a) Write a VB project to display the sum of even numbers from 1 to n according
                           Cut here
your choice.



                                 ————————




                                        12          DE–028

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:10
posted:9/23/2011
language:English
pages:12