HTET Solved paper of PGT Computer Science Group held on 01 February 2014

Haryana Teachers Eligibility Test 2014(Teachers for classes XI & XII) Solved paper of PGT Computer Science Group held on 01 February 2014[PART-I : 1 – 30] ( correct answers are highighted in deep saffron color)

1.  ___________ is not a physical tag. a) <B> b) <S> c) <Small> d) None of these

2.  ____________ first proposed the process of normalization. a) Edward Stephen b) Edward Codd c) Edgar W. Codd d) Edgar F. Codd

3.  A ____________ uses physical addresses. a) Router b) Repeater c) Gateway d) Bridge

4.  C++ was developed by__________ a) Dennis Ritchie b) Edgard Codd c) Ivan Bayross d) Bjarne Stroustrup

5.  ____________ is also called class interface. a) Member function b) Program access level c) Data Member d) Class tagname

6.  ____________ is an example of Half Duplex System. a) Keyboard b) Monitor c) Telephone d) Walkie-Talkie

7.  _____________ shortcut key is used to insert a new slide in the document presentation. a) Ctrl + N b) Ctrl + O c) Ctrl + Md) Ctrl + F

8.  A file which contains readymade styles that can be used in a presentation is called __________. a) Auto style b) Template c) Wizard d) Pre formatting

9.  _____________ are data items that never change the values during a program run. a) Integers b) Variables  c) Literalsd) Float

10. ______________is a way to bind the data & its associated functions together which allows them to be hidden. a) Structure b) Enum c) Class d) None of these

11. Overall System architecture is derived in _______________ phase. a) Coding b) Design c) Testing d) Maintenance

12. When two enteries about same data do not agree, the database is said to be ________. a) Inconsistent b) Unsecured c) Intended d) Integrated

13. _______________ sorting smallest key is taken again and again in unsorted array. a) Insertion b) Selection c) Bubble d) Heap

14. TCP connection is available at port _____________ on HTTP. a) 80 b) 60 c) 70 d) 92

15. Which gate does the following circuit represent? a) OR b) AND c) XOR d) NAND

16. ___________ function gives the total number of rows in a table. a) Variance b) Max c) Sum d) Count

17. What is an operating System? a) Application software b) Utility program c) Program Development tool d) System software

18. What is the last column of a worksheet? a) AV b) IV c) VI d) VA

19. Encapsulation is a way to implement ____________., a) Inheritance b) Polymorphism c) Data abstraction d) Overloading

20. A CPU’s processing power is measured in ______________. a) IPS b) CIPS c) MIPS d) Nanosecond

21. Macros are run or executed from ____________ menu. a) Toolsb) Insert c) Format d) Data

22. In _____________ insertion & deletion takes place only at top. a) Queue b) Sorting c) Link List d) Stack

23. A numbered list can be created by a) <ul> b) <list> c) <li> d) <ol>

24. If every ‘non-key’ attribute is functionally dependent on primary “key”, then the relation is in a) 3 NF b) 2 NF c) 4 NF d) BCNF

25. Microprocessor based computers started in ______________ generations. a) 1st b) 2nd c) 3rd d) 4th

26. ____________ is a Universal gate a) AND b) NOT c) NORd) XOR

27. In SQL decimal data type, _________indicates the number of significant digits the number is to have. a) Precision b) Scale c) Float d) None

28. The number of attributes in a relation is called _______________. a) Degree b) Domain c) Cardinalityd) String

29. _____________ is not a type of formatting in MS-Word. a) Character b) Paragraph c) Document d) Line

30. _____________ command gives virtual table with no data, but can be operated like any other table. a) SELECT b) CREATE c) CREATE VIEW d) None of these