Monday, 27 March 2017


Q1. Which type of operation in the given options can be performed a CD-RW?
(a) read and write information
(b) read, write and rewrite information
(c) only write information
(d) only read information
(e) None of these

Q2. By firmware we understand _______.
(a) physical equipment used in a computer system
(b) a set of instructions that causes a computer to perform one or more tasks.
(c) the people involved in the computing process.
(d) a set of programs that is pre-installed into the read only memory of a computer during the time of manufacturing
(e) None of these

Q3. What is an ad hoc query?
(a) Pre-planned question
(b) Pre-scheduled question
(c) Spur-of-the-moment question
(d) Question that will not return any results
(e) None of these

Q4. A _________ is used to direct and dispatch data packets between different networks.
(a) Connection
(b) Bridge
(c) Gateway
(d) Hub
(e) Router

Q5. Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational.
(a) 10 
(b) 8
(c) 12 
(d) 6
(e) 5

Q6. What is the maximum zoom percentage in Microsoft PowerPoint?  
(a) 100%
(b) 200%
(c) 400%
(d) 500%
(e) None of these 

Q7. Which among the following option does DBMS helps to achieve?
(a) Data independence 
(b) More redundancy 
(c) Centralised manner to control of data  
(d) Both (a) and (c)
(e) None of the above 

Q8. What is Telnet? 
(a) Network or Telephones 
(b) Television Network 
(c) Remote Login 
(d) All of these 
(e) None of these 

Q9. What does the computer Motherboard contain that houses setting configurations and is powered by the onboard battery?
(a) CMOS
(b) RAM
(c) DRAM
(d) CPU
(e) None of these 

Q10. Which of the following is a machine independent program? 
(a) High level language 
(b) Low level language 
(c) Assembly language 
(d) Machine language 
(e) None of these 

Q11. The analytical engine developed during first generation of computers used __________ as a memory unit.
(a) RAM
(b) Floppies
(c) Cards
(d) Counter wheels
(e) None of these

Q12. Which of the following places the common data elements in order from smallest to largest?
(a) Character, File, Record, Field, Database, File
(b) Character, Record, Field, Database, File
(c) Character, Field, Record, File, Database
(d) Bit, Byte, Character, Record, Field, File, Database
(e) None of the above

Q13. What does DRAM stands for?
(a) Digital Random Access Memory
(b) Dynamic Random Access Memory
(c) Dividing Random Access Memory
(d) Dynamic Recording Access Memory
(e) None of these

Q14. __________ has the shortest access times.
(a) Cache Memory
(b) Virtual Memory
(c) Secondary Memory
(d) All of the above
(e) None of these

Q15. EPROM is generally erased by using ______.
(a) ultraviolet rays
(b) infrared rays
(c) 12V electrical pulse
(d) 24V electrical pulse
(e) None of these

S1. Ans (b)
Sol.  CD-RW (Compact Disc-Rewritable) is a digital optical disc storage format. A CD-RW disc is a compact disc that can be written, read arbitrarily many times, erased, and written again.  

S2. Ans (d)
Sol.  Firmware is programming that's written to the read-only memory (ROM) of a computing device. Firmware, which is added at the time of manufacturing, is used to run user programs on the device.

S3. Ans (c)
Sol.  An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. 

S4. Ans (e)
Sol.  A router is used to route data packets between different networks. It reads the information in each packet to tell where it is going. If it is destined for an immediate network it has access to, it will strip the outer packet (IP packet for example), readdress the packet to the proper Ethernet address, and transmit it on that network. 

S5. Ans (c)
Sol.  Dr Edgar F. Codd, after his extensive research on the Relational Model of database systems, came up with twelve rules of his own, which according to him, a database must obey in order to be regarded as a true relational database.

S6. Ans.(c)
Sol. 400% is the max. zoom percentage in PowerPoint.

S7. Ans.(d)
Sol.  DBMS reduces data redundancy, provide a centralised manner to control of data and enabled data independence.

S8. Ans.(c)
Sol.  Telnet is an application layer protocol used on the Internet or local area networks to provide a bidirectional interactive text-oriented communication facility using a virtual terminal connection. 

S9. Ans.(a)
Sol. The CMOS is a physical part of the motherboard: it is a memory chip that houses setting configurations and is powered by the on board battery. The CMOS is reset and loses all custom settings in case the battery runs out of energy. Additionally, the system clock resets when the CMOS loses power.

S10. Ans.(a)
Sol. It is a machine independent language. It enables user to write programs in a language which resemble English words and familiar mathematical symbols.

S11. Ans. (d)
Sol. The analytical engine developed during first generation of computers used counter wheels as a memory unit

S12. Ans. (c)
Sol. Smallest to largest: Character, Field, Record, File, Database

S13. Ans. (b)
Sol. DRAM stands for Dynamic Random Access Memory.

S14. Ans. (a)
Sol. Cache Memory has shortest access time. Cache memory, also called CPU memory, is random access memory (RAM) that a computer microprocessor can access more quickly than it can access regular RAM

S15. Ans. (a)
Sol. EPROM is generally erased by using ultraviolet rays.