JOA-IT Solved Part 2 @HPPSC,Shimla 19 Feb 2017

Part 1 link here

26. Which of the following are components of Central Processing Unit (CPU)?

(A) Arithmetic Logic Unit, Mouse and Primary/Main Memory

(B) Arithmetic Logic Unit, Printer and Primary/Main Memory

(C) Control Unit, Monitor and Primary/Main Memory

(D) Arithmetic Logic Unit, Control Unit and Primary/Main Memory

27. What is the full form of URL?

(A) Uniform Registered Link

(B) Uniform Resource Locator

(C) Uniform Resource Link

(D) Unified Resource Link

28. In which of the following, Documents, Movies, Images and Photographs etc

are stored?

(A) Print Server

(B) Media Server

(C) Web Server

(D) File Server

29. What is the full form of GUI in reference to computers?

(A) Graphical Unified Interface

(B) Graphical User Interface

(C) Graphical User Instrument

(D) Graphical Unified Instrument

30. Which are the operations that are performed on RAM?

(A) Write only

(B) Read only

(C) Read and Write both

(D) It depends on the user

31. Which of the following is the outcome of data processing?

(A) Software Program-

(B) Data

(C) System

(D) information

32. DNS in Internet technology stands for?

(A) Domain Name System

(B) Dynamic Name System

(C) Distributed Name System

(D) Data Name System

33. Which of the following operations is not performed by a computer?

(A) Control

(B) Output

(C) Understand

(D) Input

34. The folders’ in an operating system are based on………….. structure.

(A) Doubly linked

(B) Queue

(C) Inverted tree

(D) Graph

35. Which of the following alignments will apply by default when some text is entered in a cell in a worksheet of Microsoft Excel?

(A) Centre

(B) Left

(C) Right

(D) None of these

36. Which of the following addressing modes can be used for writing formulas in a cell in a worksheet in Microsoft Excel?

(A) Relative

(B) Absolute

(C) Mixed

(D) All of these

37. What is a hyperlink?

(A) It is used to save the web site

(B) It is used to link web pages

(C) It is a link which is hypersensitive to user

(D) None of the above

38. Which of the following is not a component in multimedia?

(A) Audio

(B) Video

(C) Data

(D) Pen drive

39. IPR stands for?

(A) Intellectual Property Rights

(B) Illegal Property Rights

(C) Intellectual Property Rites

(D) None of these

40. Which of the following is not true for Microsoft PowerPoint presentation?

(A) The slides can be run with the help of slide show

(B) The access to a particular slide can be restricted

(C) The transition speed for the slides can be adjusted before running the slide show

(D) The transition speed for the slides cannot be adjusted before running

 the slide show

41. The full form of SQL is?

(A) Standard Query Language

(B) Structured. Queuing Language

(C) Standard Queuing Language

(D) Structured Query Language

42. An attribute in a table is a foreign key if the key from another table is used as an attribute in that table.

(A) Candidate

(B) Super

(C) Primary

(D) Foreign

43.Which one of the following attributes can be used as a primary key?

(A) Candidate Name

(B) Street Name

(C) Adhaar Card Number

(D) None of these

44. Under what condition, the subset of super key is a candidate key?

(A) All subsets are super keys

(B) Subset is a super key

(C) No proper subset is a super key

(D) Each subset is a super key

45. Create table employee (name varchar, id integer). What type of statement

is this?

(A) View

(B) DCL

(C) DML

(D) DDL

46. Which of the following devices can be used to connect a computer to the Internet through a telephone line?

(A) Modem

(B) Hub

(C) Extension Board

(D) None of these

47. Which of the following does not work on the principles of magnetization?

(A) Hard Disk Drive

(B) Floppy Disk Drive

(C) Magnetic Tape

(D) Pen Drive

48. Which of the following statements is false?

(A) The mouse can be used to scroll/move the cursor

(B) Keyboard can be used as an output device

(C) DVD can be used to store the data permanently

(D) Mike can be used to record voice in a computer

49.Which of the following is not a key on the Keyboard of a normal PC?

(A) +

(B) f

(C) Tab

(D) Sys

50. Internet is an example of…….?

(A) Local Area Network

(B) Metropolitan Area Network

(c) Wide Area Network

(D) Storage Network

Part 1 link here

Part 3 and 4 link here

Exit mobile version