Solved Paper Assistant Programmer 2018 [Part-1]- HPSSC Hamirpur

Solved Paper Assistant Programmer 2018

Series – A

Post Code – 649

1. How many different heading elements are supported by HTML?

1. 5
2. 4
3. 3
4. 6

2. ———–is the application of ICT for delivering Government services to the citizens.

1. E-Commerce
2. E-Governance
3. E-Banking
4. E-Mail

3. A large capital letter used as a decorative element at the beginning of a paragraph in MS-Word is called

1. Superscript
2. Mail Merge
3. Drop Cap
4. Small cap

4. Which of the following is a method for digital transactions for money transfer?

1. Debit/Credit Cards
2. UPI
3. Net Banking
4. All of the above

5. Which of the following Java code fragments will create an array of five integers?

1. int a[]; a=new int(5);
2. int a[]=[1,3,2,1,0];
3. int a[]=new int950;
4. all of the above

6. What is the full form of CSS?

1. Cascading Style Sheets
2. Cohesive Style Spreadsheet
3. Common Stylesheet
4. Creative Style session

7. What is the correct ‘C’ expression for the formula b^2-4ac/2a?

1. b*b-4*A*C/2*a
2. (b*b)-4*a*c/(2*a)
3. b*b-4*a*c/(2*a)
4. (b*b- 4*a*c)/(2*a)

8. ————–is a non-linear data structure in which elements are organized in a hierarchy of parents and children?

1. Queue
2. List
3. Tree
4. Dequeue

9. What will be the address of the cell at 27^th row and 35^th column in an Excel worksheet?

1. A1: A9
2. AA35
3. AI27
4. A1:35

10. Which of the following statements are correct about WWW?

1. It was invented by Vint Cerf.
2. It consists of a huge number of HTML documents hosted on a large number of servers
3. It can be accessed using a special client software called web browsers.

1. (i) and (iii)
2. (i and (ii)
3. (ii) and (iii)
4. All of the three

11. Which of the following storage media uses flash memory?

1. Magnetic tape
2. CD-ROM
3. Floppy disk
4. Pen Drive

12. Which of the following statements is incorrect about ‘C”

1. ‘C’ is a case-insensitive language.
2. A ‘C’ program must be compiled and linked before execution
3. ‘C’ supports the concept of pointers.
4. C’ is a high-level language

13. Which of the following sorting algorithms can be conveniently implemented using recursion?

1. Selection sort
2. Bubble sort
3. Insertion sort
4. Merge sort

14. Which of the shortcut key to center-align the paragraph text in Ms-word?

1. Ctrl + M
2. Ctrl +C
3. Ctrl+J
4. Ctrl+E

15. Which of the following is an example of system software?

1. Music player
2. Operating System
3. Word processor
4. Paintbrush

16. Which of the following clauses in SQL SELECT statements is used to filter the resultant rows of the query as per the given condition?

1. FROM
2. GROUP BY
3. ORDER BY
4. WHERE

17. A ——is a small piece of data stored within the web browser on a client computer by a website.

1. Token
2. Cookie
3. Database
4. Text file

18. What is the basic requirement for a binary search algorithm?

1. Array elements must be sorted.
2. The element being searched must be present in the array.
3. The number of elements in the array must be less than 100.
4. All of these

19. What is the maximum value that can be stored in a variable of type short java?

1. 65535
2. 16767
3. 32767
4. 127

20. What is the full form of SEO?

1. Search Engine Optimization
2. Search enabled operation
3. Software Engineering organization
4. Semi-elastic object

21. What is the correct CSS rule to set the background color of <h1> elements to red?

1. .h1 {background-color : red;}
2. #h1{background-color: red;
3. H1{background-color: red;}
4. <h1>{background-color: red;}

22. Who among the following developed the Java language?

1. Steve Jobs
2. James Gosling
3. Allan Turing
4. Bjarne Stroustrup

23. Which of the following is a DDL SQL command?

1. DELETE
2. UPDATE
3. INSERT
4. CREATE

24. What is the right syntax of declaring and defining the array a = [1,7,4,2,3] in ‘C’?

1. Int a=[1,7,4,2,3];
2. Inta[]={1,7,4,2,3};
3. Int a[] = 1,7, 4,2,3;
4. Int a[]=[1,7,4,2,3];

25. What will be output of following code fragment in a java program?

Int x=40;

Inty=++x;

System.out.println(“X=+x=”, y=”+y);

1. X=40,y=40
2. X=41, y=40
3. X=41, y=41
4. X=40, y=41

26. a/an —————- is a diagrammatic representation of the sequence of operation to be performed to solve a given problem.

1. Flowchart
2. Data flow diagram
3. Gatt chart
4. Algorithm

27. Who is known to be the father of World-wide-web?

1. James Gosling
2. Tim Berners-lee
3. Dennis Ritchie
4. Charles Babbage

28. A bug in a program is also known as

1. Fault
2. Exception
3. Syntax Error
4. Semantic Error

29. Which of the following is not a valid cell reference in MS-Excel?

1. A$(
2. $A9
3. A9
4. A:9

30. ——–is a problem-solving technique in which a larger problem is solved by combining solutions of identical but smaller sub-problems.

1. Union
2. Pointer
3. Recursion
4. Structured programming

31. Which of the following web browsers is developed by Google?

1. Firefox
2. Edge
3. Chrome
4. Internet Explorer

32. WWW uses ———application layer protocol for requesting and delivering web pages.

1. FTP
2. UDP
3. SMTP
4. HTTP

33. ————–is an application condition that may arise during program execution that if not handled properly may cause unexpected behavior of the program.

1. Syntax Error
2. Fault
3. Semantic Error
4. Exception

34. Which of the following HTML Tags is used to insert a horizontal line in a webpage?

1. <hr>
2. <br>
3. <li>
4. <line>

35. In a certain Ms-Excel worksheet, the contents of cells are as under:

A1=39,  B1=42, C1=37, A2=41, B2=74, C2=40

What will be the result of the formula= SUM=(A1: C1)?

1. 80
2. 118
3. 115
4. 273

36. Which of the following is the correct SQL query to fetch the details of all employees from the ‘emp’ table who are getting more than 25000 as salary?

1. SELECT * FROM emp GETTING salary >25000;
2. SELECT * FROM emp WITH salary >25000;
3. SELECT * FROM emp HAVING salary >25000;
4. SELECT * FROM emp WHERE salary >25000;

37. A Program that appears to be a useful application to the user, but in fact is designed with a malicious intent is called a

1. Trojan
2. SPAM
3. Worm
4. Virus

38. Which of the following is not a lopping control statement in ‘C’?

1. While
2. For
3. If……else
4. Do…while

39. Drum and flatbed are types of

1. Printers
2. Scanners
3. Monitors
4. Keyboards

40. What is the 2’s compliment of (001010111)2

1. (01010110)2
2. (11010111)2
3. (01010111)2
4. (11010110)2

41. Which of the following SQL statements is used to change the width of a table column?

1. UPDATE TABLE
2. TRUNCATE TABLE
3. ALTER TABLE
4. CHANGE TABLE

42. Which of the following features of the C language is not found in Java?

1. File handling
2. Arrays
3. Pointers
4. Functions

43. ——data structure is also known as Last In First Out (LIFO)?

1. Tree
2. Stack
3. Queue
4. Array

44. A ———— Is a special type of variable that can hold the address of some other variable?

1. Pointer
2. Structure
3. Static
4. Register

45. Which of the following is not a valid data type in Java?

1. Double
2. Short
3. Unsigned int
4. Byte

46. Which of the following is a function of an operating system?

1. Resource Management
2. Database management
3. Word processing
4. All of these

47. Which of the following languages is used as a scripting language in HTML documents?

1. Python
2. Java
3. JavaScript
4. FORTRAN

48. The ————-data type in SQL based RDBMS can hold character data of variable lengths.

1. CHAR
2. VARCHAR
3. STRING
4. DOUBLE

49. Which of the following C operators is also known as the conditional operator?

1. >>
2. ->
3. ?:
4. ++

50. What shall be the output of the following segment of a ‘C’ program?

1. 0
2. 310
3. 200
4. C8

51. Information on a computer is stored as

1. Analog data
2. Digital data
3. Modem data
4. Hybrid data

52. Who was the first computer programmer in the history of computer?

1. Augusta Ada Byron
2. Claude E. Shanron
3. George Moore
4. Peter Norton

53. Which of the following is fourth generation computers language?

1. Machine language
2. C-language
3. FORTRAN
4. SQL

54. Conversion of computer generated a result in human acceptable form is a function of

1. CPU
2. Input interface
3. Output interface
4. RAM

55. The comparison of data inside the arithmetic logic unit is referred to as a/an

1. Instruction
2. Data operation
3. Conditional Operation
4. Logical Operation

Read next: ॥ Part-2 ॥  Part-3 ॥