Monday, October 2, 2017

IT SPECIALISED OFFICER TEST



1. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate the feature?
a) Point to Speech on the Tool menu, and then click Show Text To Speech Toolbar.
b) Click validation on the data menu.
c) Point to speech on the tools menu, and then click speech recognition.
d) All of the above
e) None of these

2. Which of the following statements is true?
a) To insert link in Ms Excel, Ctrl + K is used.
b) One can edit selected cell in Excel by pressing the F2 key.
c) Shift + space is used to select the entire row in Excel.
d) Ctrl + space is used to select the entire column in Excel.
e) All 1), 2), 3) and 4) are true

3. For multiple selection in any file system you have..
a) Radio button
b) Local area network
c) Notification area
d) Yes/ No box
e) None

4. Which of the following is the characteristic of a file server?
a) It manages file operations and is shared on a network.
b) It manages file operations and is limited to one PC.
c) It acts as fat client and is shared on a network.
d) It acts as fat client and is limited to one PC.
e) None of these

5. Advantage of X.25 network is that...
a) frame delivery is more reliable
b) frames are delivered in order
c) flow control is provided
d) All the above
e) None of these

6. A ........ is a pre-designed document that already has co-ordinating fonts, a layout, and
a background.
a) guide
b) model
c) ruler
d) template
e) None of these

7. To make a notebook act as a desktop model, the notebook can be connected to a ...... which
is connected to a monitor and other devices.
a) bay
b) docking station
c3) port
d) network
e 5) None of these

8. First Technopark in India is in....
a) Bangalore
b) Kolkata
c) Thiruvananthapuram
d) Delhi
e) None

9. What is the meaning of 'Hibernate' in Windows XP/ Windows 7?
a) Restart the computers in safe mode
b) Restart the computers in normal mode
c) Shutdown the computer terminating all the running applications
d) Shutdown the computer without closing the running applications
e) Restart the computers all the running applications

10. The RF communication can be broadly classified in how many types?
a) Three
b) Four
c) Two
d) Six
e) Ten

11. _____ is sometimes said to be object oriented, because the only way to manipulate kernel objects is by invoking methods on their handles.
a) Windows NT
b) Windows XP
c) Windows VISTA
d) Windows 95/98
e) Windows 7

12. In OSI network architecture, the dialogue control and token management are responsibility of __
a) session layer
b) network layer
c) transport layer
d) data link layer
e) None of the above

13. Which of the following case does not exist in complexity theory?
a) Best case
b) Worst case
c) Average case
d) Null case
e) All of the above

14. A computer program that converts an entire program into machine language is called a/ an
a) Interpreter
b) Simulator
c) Compiler
d) Commander
e) Proposer

15. Which of the following formulas will Excel not be able to calculate?
a) =SUM(Sales)−A3
b) =SUM(A1:A5)*.5
c) =SUM(A1:A5)/(10−10)
d) =SUM(A1:A5)−10
e) = SUM(A1:A5)−A5

16. What are plastic cards the size of a credit card that contains an embedded chip on which digital information can be stored?
a) Customer relationship management systems cards
b) E-government identity cards
c) FEDI cards
d) Smart cards
e) Aadhar card

17. During software development which factor is most crucial?
a) People
b) Process
c) Product
d) Project
e) Purpose

18. How many OSI layers are covered in the X.25 standard?
a) Two
b) Three
c) Seven
d) Six
e) eight

19. SDLC stands for?
a) Software Design Life Cycle
b) Software Development Life Cycle
c) System Design Life Cycle
d) System Development Life Cycle
e) None of these

20. When a subroutine is called, the address of the instruction following the CALL instructions
stored in/ on the ___
a) stack pointer
b) accumulator
c) program counter
d) stack
e) pointer

21. What component of .NET includes services used to support web services?
a) Platform
b) Framework
c) Visual Studio
d) System
e) Mather board

22. Which of the following is not one of the four primary focuses of e-government?
a) G2G
b) G2B
c) IG2B
d) IG2G
e) IG2I

23. ____is not a category of EPS.
a) E banking
b) Direct payments
c) Retailing payments
d) Cash on delivery
e) All of these

24. One of the distinguished features of super-computer over other category of computer is ____
a) parallel processing
b) highest accuracy level
c) more speed
d) more capacity
e) less speed

25. Which class is used to control the data being used by application?
a) Document class
b) View class
c) Frame class
d) Application class
e) Software class

26. What kind of architecture does mobile computing deploy?
a) Two layered
b) Three layered
c) Four layered
d) Five layered
e) Six layered

27. Which of the following is the most common method for online payment?
a) Card based system
b) Cheque based system
c) e cash system
d) All the above
e) None of the above

28. Which of the following is not a product matrix?
a) Size
b) Reliability
c) Productivity
d) Functionality
e) Quality

29. Which of the following transmission systems provide the highest data rate in individual device?
a) Computer bus
b) Telephone lines
c) Voice and mode
d) Lease lines
e) Only voice

30. The most common addressing techniques employed by a CPU is ___
a) Immediate
b) Direct
c) Indirect
d) Register
e) All of the above

31. The key F12 opens a:
a) Save As dialog box
b) Open dialog box
c) Save dialog box
d) Close dialog box
e) Edit dialog box

32. Which of the following signal is not standard RS-232-C signal?
a) VDR
b) RTS
c) CTS
d) DSR
e) DLR

33. The indirect change of the values of a variable in one module by another module is called ___
a) internal change
b) inter-module change
c) side effect
d) side-module update
e) internal effect

34. Operating system is also known as:
a) Database
b) System software
c) Hardware
d) Printer
e) Operating system

35. Which of the following statement is correct?
a) Terminal section of a synchronous modem contains the scrambler
b) Receiver section of a synchronous modem contains the scrambler
c) Transmission section of a synchronous modem contains the scrambler
d) Control section of a synchronous modem contains the scrambler
e) None of the above

36. To send another station a message, the main thing a user has to know is
a) how the network works
b) the other station's address
c) whether the network is packet-switched or circuit - switched
d) whether this is a voice or data network
e) None of the above

37. The data base administrator's function in an organization is
a) to be responsible for the more technical aspects of managing the information contained in organizational databases.
b) to be responsible for the executive level aspects of decisions regarding the information management
c) to show the relationship among entity classes in a data warehouse
d) to define which data mining tools must be used to extract data
e) None of the above

38. Each of the following is a true statement except
a) online systems continually update the master file
b) in online processing, the user enters transactions into a device that is directly connected to the computer system
c) batch processing is still used today in older systems or in some systems with massive volumes of transactions
d) information in batch systems will always be up-to-date
e) None of the above

39. When you save a presentation, ............
a) all slides in a presentation are saved in the same file
b) two files are created; one for graphics and one for content
c) a file is created for each slide
d) a file is created for each animation or graphic
e) None of the above

40. In a client/ server model, a client program
a) asks for information
b) provides information and files
c) serves software files to other computers
d) distributes data files to other computers
e) None of the above

41. A top to bottom relationship among the items in a database is established by a ______
(A) Network Schema
(B) Relational Schema
(C) Hierarchical Schema
(D) None of the above

42. Aggregation is a special form of _______
(A) Specialization
(B) Association
(C) Generalization
(D) None of the above

43. In E-R Diagram, _________ represents Key Attribute.
(A) Ellipse with underlying line
(B) Rectangle with underlying line
(C) Double rectangle
(D) None of the above

44.  Which TCL command is used to permanently save any transaction into database?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above

45.  Which TCL command restores the database to last committed state?
(A) rollback
(B) savepoint
(C) commit
(D) None of the above

46.  _______ is used to control privilege in Database.
(A) Data Manipulation Language
(B) Data Definition Language
(C) Data Query Language
(D) Data Control Language

47.  Which model remains operative until the software is required?
(A) Waterfall model
(B) Incremental model
(C) Prototyping model
(D) Spiral model

48.  In oracle, which tablespace is the minimum required when creating a database?
(A) System tablespace
(B) Undo tablespace
(C) temporary tablespace
(D) None of the above

49.  Which of the following is another name for weak entity?
(A) Dominant
(B) Child
(C) Owner
(D) None of the above

50.  ODBC is based on ________
(A) C++ language
(B) RDBMS
(C) Structured Query Language
(D) C language

1
A
2
B
3
A
4
A
5
D
6
D
7
B
8
C
9
D
10
A
11
A
12
D
13
D
14
C
15
D
16
D
17
A
18
B
19
B
20
D
21
B
22
C
23
D
24
C
25
A
26
B
27
A
28
C
29
A
30
E
31
A
32
A
33
C
34
B
35
C
36
B
37
A
38
D
39
A
40
D
41
C
42
B
43
A
44
D
45
A
46
D
47
D
48
A
49
B
50
C

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.