IT in Management Set 1

QN1. When a key is pressed on the keyboard, which standard is used for converting the keystroke into the corresponding bits

a) ANSI

b) ASCII

c) EBCDIC

d) ISO

Answer

Answer: a) ANSI

QN2. Which device is used as the standard pointing device in a Graphical User Environment

a) Keyboard

b) Mouse

c) Joystick

d) Track ball

Answer

Answer: b) Mouse

QN3. Which of the following is not an output device?

a) Scanner

b) Printer

c) Flat Screen

d) Touch Screen

Answer

Answer: c) Flat Screen

QN4. Which of the following devices have a limitation that we can only information to it but cannot erase or modify it

a) Floppy Disk

b) Hard Disk

c) Tape Drive

d) CDROM

Answer

Answer: a) Floppy Disk

QN5. Which technology is used in Compact disks?

a) Mechanical

b) Electrical

c) Electro Magnetic

d) Laser

Answer

Answer: d) Laser

QN6. Which of the following storage devices can store maximum amount of data?

a) Floppy Disk

b) Hard Disk

c) Compact Disk

d) Magneto Optic Disk

Answer

Answer: b) Hard Disk

QN7. The programs which are as permanent as hardware and stored in ROM is known as

a) Hardware

b) Software

c) Firmware

d) ROMware

Answer

Answer: c) Firmware

QN8. EPROM can be used for

a) Erasing the contents of ROM

b) Reconstructing the contents of ROM

c) Erasing and reconstructing the contents of ROM

d) Duplicating ROM

Answer

Answer: c) Erasing and reconstructing the contents of ROM

QN9. The contents of information are stored in

a) Memory data register

b) Memory address register

c) Memory access register

d) Memory arithmetic register

Answer

Answer: a) Memory data register

QN10. Algorithm and Flow chart help us to

a) Know the memory capacity

b) Identify the base of a number system

c) Direct the output to a printer

d) Specify the problem completely and clearly

Answer

Answer: d) Specify the problem completely and clearly

QN11. Which of the following is the oldest spread sheet package?

a) VisiCalc

b) Lotus 1-2-3

c) Excel

d) StarCalc

Answer

Answer: a) VisiCalc

QN12. How many characters can be typed in a single cell in Excel?

a) 256

b) 1024

c) 32,000

d) 65,535

Answer

Answer: d) 65,535

QN13. A Worksheet can have a maximum of ___ number of rows

a) 256

b) 1024

c) 32,000

d) 65,536

Answer

Answer: d) 65,536

QN14. Comments put in cells are called

a) Smart Tip

b) Cell Tip

c) Web Tip

d) Soft Tip

Answer

Answer: b) Cell Tip

QN15. Comments can be added to cells using

a) Edit -> Comments

b) Insert -> Comment

c) File -> Comments

d) View -> Comments

Answer

Answer: b) Insert -> Comment

QN16. Which menu option can be used to split windows into two

a) Format -> Window

b) View -> Window ->Split

c) Window -> Split View -> Split

Answer

Answer: b) View -> Window ->Split

QN17. Which of the following is not a valid data type in Excel

a) Number

b) Character

c) Label

d) Date/Time

Answer

Answer: b) Character

QN18. Data can be arranged in a worksheet in an easy to understand manner using

a) Auto Formatting

b) Applying Styles

c) Changing fonts

d) All of these

Answer

Answer: d) All of these

QN19. Which area in an Excel window allows entering values and formulas

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

Answer

Answer: c) Formula Bar

QN20. Multiple calculations can be made in a single formula using

a) Standard Formulas

b) Array Formula

c) Complex Formulas

d) Smart Formula

Answer

Answer: b) Array Formula

QN21. An Excel Workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and Charts

Answer

Answer: d) Worksheets and Charts

QN22. Which of the following is not a database application?

a) dBase

b) Edit

c) FoxPro

d) Access

Answer

Answer: b) Edit

QN23. which of the following is a database management tool developed by Microsoft?

a) dBase

b) Access

c) Personal Oracle

d) Sybase

Answer

Answer: b) Access

QN24. HSAM stands for ____

a) Hierarchic Sequential Access Method

b) Hierarchic Standard Access Method

c) Hierarchic Sequential and Method

d) Hierarchic Standard and Method

Answer

Answer: a) Hierarchic Sequential Access Method

QN25. Threats to data security may be ____ threats to the database.

a) Direct

b) Indirect

c) Both Direct and Indirect

d) None of these

Answer

Answer: a) Direct

QN26. Which of the following is not a logical database structure?

a) Chain

b) Network

c) Tree

d) Relational

Answer

Answer: a) Chain

QN27. An organized collection of logically related data is known as

a) Data

b) Meta data

c) Database

d) Data versus Information

Answer

Answer: c) Database

QN28. The processing of an application between a client and a ____ processor.

a) Front end

b) Back end

c) Both

d) None of these

Answer

Answer: c) Both

QN29. The____ is not formal enough to be implemented directly in a programming language.

a) Analysis model

b) E R model

c) Object oriented model

d) Object oriented data mode

Answer

Answer: a) Analysis model

QN30. Size of a database are usually measured in terms of

a) Terabytes

b) Megabytes

c) Data bytes

d) Giga bytes

Answer

Answer: d) Giga bytes

QN31. In databases, Locking level is also called as

a) Granularity

b) S lock

c) X lock

d) Dead lock

Answer

Answer: a) Granularity

QN32. Wired networks…

a) Can be simpler to secure than wireless networks

b) Can involve running long wires through walls

c) Generally use Ethernet cables

d) All of the above

Answer

Answer: b) Can involve running long wires through walls

QN33. Wireless networks…

a) Can only have one type of operating system on them

b) Have a limited range that can be furthered reduced by physical obstacles

c) Only work with laptops

d) Are quite difficult to secure

Answer

Answer: b) Have a limited range that can be furthered reduced by physical obstacles

QN34. Modems

a) Stand for “Modulator/demodulators”

b) Connect to multiple computers

c) Broadcast wireless signals

d) Only work with AOL

Answer

Answer: b) Connect to multiple computers

QN35. What is a router?

a) A device that make sures all devices on your network get power

b) A device that manages the data flow of a network

c) A device that always has a firewall for security

d) A device that connects to the internet and a modem

Answer

Answer: a) A device that make sures all devices on your network get power

QN36. ______ shares characteristics with both hardware and software

a) Operating system

b) Software

c) Data

d) None

Answer

Answer: a) Operating system

QN37. Which of the following statements is true about ERP Implementation?

a) “As-Is” stage follows “To-Be” stage.

b) “To-Be” stage follows “As-Is” stage.

c) “Go-Live” stage and “As-Is” stage can proceed simultaneously.

d) None of the above.

Answer

Answer: c) “Go-Live” stage and “As-Is” stage can proceed simultaneously.

QN38. Which of the following factor does not contribute to the success of ERP?

a) Focus on business processes and requirements first.

b) Focus on achieving a healthy ERP ROI (Return on Investment), including post-implementation performance measurement.

c) Strong project management and resource commitment.

d) Lack of budget.

Answer

Answer: d) Lack of budget.

QN39. Who plays and important role in the selection of ERP Package?

a) Consultants

b) Vendors

c) Users

d) All of the above.

Answer

Answer: d) All of the above.

QN40. Enterprise-wide resource planning systems (ERP systems) attempt to:

a) Integrate all corporate information in one central database

b) They do not allow information to be retrieved from many different organizational positions

c) They allow any organizational object to be made invisible.

d) They allow information to be stored in multiple databases.

Answer

Answer: a) Integrate all corporate information in one central database