Institute of Human Resources Development Second Semester DDTPM by Levone


									                          Institute of Human Resources Development.
               Second Semester DDTPM Exanrinatton, December 2006
                                Scheme 2002 - Regular/Supplementary

                   DDTPM 201 PC MAINTENANCE & NETWORKING

Time:3Hrs                                                            Maximum: 100 Marks

           (Answer all questions. Each question carries 1 mark)

Fill in the blanks

1 the first microprocessor introduced by Intel in 1970.

2 EPIC stands for...................

3. an extremely fast, small memory between CPU and main memory.

4. The time required to position the read/write head over the desired track in a magnetic disk is --

5. a computer processor used to supplement the functions of the primary processor.

Select the most appropriate answer from choices given.

6. Dual Layer recording allows DVD-R and DVD+R discs to store data

upto.......................per disc.

       a) 4.7 GB                       b) 8.5 GB   c) 8.5 MB         d) 4.7 MB

7. the process of capturing data by contrasting reflectivivity at
   predetermined positions on a Page.

   a) Optical Mark Recognition b) Speech Recognition             c) MICR      d) OPR

8. a "try before you buy" software.
   a) Public Domain Software                 b) Firmware       c) Software        d) Shareware
9. a thin, flat display device made up of any number of colour or     monochrome
pixels arrayed in front of a light source or reflector
   a) Liquid Crystal Display                 b) VGA               c) Pixels        d) EGA

10 A device that convert digital signals to analog signals is.................................
   a) packet              b) Modem           c) Emulator                    d) Code

                                      (Answer any TEN. Each question carries 5 marks)

11. What are the Basic PC Components.
12. What are on-line and off-line systems.
13. What are the diffrent typesof mouse .
14. Explain USB pen drive.
15. Explain the different types of Read only Memory.
16. Explain CD-ROM and DVD.
17. Briefly explain the working principles of MICR, OCR and OMR devices.

18. What are routers and gateways.?              /.

19. What are the benefits that the LCD desktop monitors offer over the conventional CRT
20. Explain the different types of memory modules.
21. Explain the basic components of a communication systems.
22. Explain SCSI and IDE.
                                              PART - C
                     (Answer any TWO full questions. Each question carries 20 marks)

23. a) Compare different processor.                                                              (10)
    b) Explain the use of cache memory in computer systems.                                            (5)
    c) Explain any two input devices.                                                            (5)

24. a) Explain the working of joysticks and light pen.                                            (5)

    b) What are SDRAM, DDRRAM and RDRAM.                                                         (10)
    c) How partitioning is done on a hard disk?                                                            (5)

25. a) Explain the different types of impact and non-impact printers.                                      (8)
    b) What are spooling and buffering?                                                                    (6)
    c) Explain the concept of power supply unit in a computer?                                            (6)

26. a) Explain the different types of unbounded media.                                                   (10)
    b) What do you meant by communication protocol                                                       (5)
    c) Explain LAN and WAN                                                                               (5)

                           Institute of Human Resources Developlnent
                      Second Semester DDTPM Examination, December 2006
                              Scheme 2002 - Regular/Supplementary

                          DDTPM 202 DATABASE APPLICATIONS

Time:3Hrs                                                                  Maximum : 100 Marks

                                 Part A
             (Answer all questions. Each carries 1 mark)

Fill in the blanks
1    The set of possible values, a given attribute can have is called.............................

2     ............................................. is the custodian of the data and controls the data    Structure.

3      In the relational model columns are called ...................................

4 a mechanism for protecting transitions from interference on the part
of concurrently executing transitions.

5     A candidate key which is not the primary key is called.....................

Choose the correct answer

6     .......................command is used in SQL to change the content of rows in a table.

7     An example for DCL command is.

8     Multiple queries can be combined by using..............operator is Oracle.
      a)JOIN b)VIEW . c)UNION d) none of these.

9      In Visual Basic..................command is used to stop the program execution at
       any stage of execution.
       a)EXIT b)END c)STOP d)BREAK

10    The level of database architecture which is closest to the user.
      a) INTERNAL b)EXTERNAL c)CONCEPTUAL d) none of these

                                Part B
             (Answer any TEN questions. Each carries 5 marks)

11    Explain the different database users.

12    Define primay key, alternate key, foreign key and candidate key.

13    Explain any five aggregate functions in SQL.

14    Explain sorting and example wilh example.

16 What is the need of file add record locking. Explain.

17 What are the searching conunands in dBase ?

18 What are the advantages of DBMS ?

19 What is distributed database ?

20 What are the uses and advantages Of Views in SQL ?

21    Show the use of the folowing clauses
     a) HAVING           b) 1N             c) GROUP BY
     d) ORDER BY          e) LIKE

22   What is system integrity?

                (Answer any TWO questions. Each carries 2O marks)
23   What is MySQL ? Explain the syntax and example of the following
     a) Create a database   b) Creating a table    c)Inserting data into table
     d) Add a new field     e) list all records   f) Delete a record
     g) Sort the data       h) Remove the table.

24 a) What are the database models? Explain
   b) What are the advantages and disadvantages of DBMS ?

25   Consider the following table-Employee.
     EmpNo                number(3)
     EmpName               varchar2(35)
     Detination             varchar2(I5)
     Department            varchar(10)
     Salay                 number(7)
     City                  varchar2(l5)

And do the following
a) Display the details of employees whose names start wi1h 'B'.

b) Add a new column Date_ of Joining (date).

c) Show the amount required to pay salary of employees of each department.

d) Show the name of employee who have the highest salary.

e) Increment the salary of employees by 3%.

a) Explain any Five data type conversion functions in SQL.

b) Explain any Five properties of.control in Visual Basic ?

                      Institute of Human Resources Development
                     Second Semester DDTPM Examination, June 2005
                          Scheme 2002 - Regular/Supplementary


Time:3Hrs                                                         Maximum: 100 Marks.

                                            PART A
              (Answer all questions from 1 to 10. Each question carries 1 mark)

Choose the correct answer.
  1. Computer screen can be considered a matrix of discrete cells, each of which can be
      made bright is called.............

              a) Pixels b) Monitor c) CRT d) None of the above

   2. Which of the following tag do not require a terminator

                a) <U> b) <BR> c) <B> d) <H>

   3. GIMP is

          a) Image Editing Program b) Programming Language

          c) Word Processor d)None of the above

   4. Which one is picture file format

          a) WAV b) BMP c) DOC d) XLS

   5. The process of selecting the desired area of a picture is

          a) Crop b) cut out    c) copy d) extract

Fill in the blanks
   6. WYSIWYG stands for ------------------ an example for web browser.

    8.An account with a must to connect to the internet an example for search engine in Internet.

  10. URL stands for ------------------------

                                              PART B
                            (Answer any 10 questions. Each carries 5 marks)

    11. What is the difference between Tracking and kerning?
    12. What is image resolution?
    13. Differentiate primary and secondary colors.
    14. What are the different image modes?
    15. Write notes on the following
            a. Superscript and Subscripts
            b. Drop cap
16. What are the different formats of text?
17. Write a note on the following
                   a) CMYK
                   b) RGB Colors
                   c) HSL/HSB
18. What is template?
19. What is Layer?
20. What are the different Blending modes in GIMP?
21. What are the different methods for a computer system to create, manipulate and
    output an image?
22. What is a hyperlink?

                                                                  PART C
                                     (Answer any TWO questions. Each carries 20 marks)
23. a) What is DTP? What are the advantages of DTP?                  (15)
       b) Threading and unthreading of text
24. a) What are the uses of frames in Page Maker?                    (8)
       b) Write note on a) Index b) Hyphenation c) Master page       (12)
25. a) What are the different types of printers?                         (5)
b) What are the different document setups in page maker and what are the different
layouts for your document?                                       ( 15)
26.a) Give one example for image editing $oftware and explain different features of

b) Write short note on a) World Wide Web b) web pages c) web site (10)
- --


To top