Computer Awareness MCQs | Computer Multiple Choice Questions with Answers

Answer: It is more secure

Sol. In the three-tier architecture, there is an additional server, called the application server, between the client and database servers. The application server reduces the work of the database server, thereby making application processing efficient. It is more secure because the client cannot access the database directly. However, it is more complex to build.

Answer: 10, 500

Sol. 10 and 500 are valid minimum & maximum zoom sizes in MS word.

Answer: Cammand.com, io.sys, msdos.sys

Sol. In the PC bootup sequence, the first sector of the boot disk is loaded into memory and executed. If this is the DOS boot sector, it loads the first three sectors of IO.SYS into memory and transfers control to it. IO.SYS then: loads the rest of itself into memory-initializes each default device driver -loads the DOS kernel and calls its initialization routine. The kernel is stored in MSDOS.SYS- processes the MSDOS.SYS- processes the CONFIG.SYS file- loads COMMAND.COM- displays the bootsplash in Windows.

Answer: BIOS

Sol. BIOS (basic input/output system) is the program a personal computer's microprocessor uses to get the computer system started after you turn it on. It also manages data flow between the computer's operating system and attached devices such as the hard disk, video adapter, keyboard, mouse and printer.

Answer: Cache memory is a form of Read only Memory (ROM)

Sol. Cache memory is a form of Random Access Memory (RAM) that is directly associated with the microprocessor.

Answer: Write Once Read Many

Sol. In computer storage media, WORM (write once, read many) is a data storage technology that allows information to be written to a disc a single time and prevents the drive from erasing the data. The discs are intentionally not rewritable, because they are especially intended to store data that the user does not want to erase accidentally.

Answer: Both (a) and (c)

Sol. Walter Houser Brattain was an American physicist, along with John Bardeen and William Shockley, invented the point-contact transistor.

Answer: Christopher Latham Sholes

Sol. Christopher Latham Sholes invented the keyboard in 1868.

Answer: Operating System

Sol. Windows Vista is an operating system, designed and marketed by Microsoft Inc.

Answer: Attributes

Sol. In ER diagram, different components are represented with different symbols. Common symbols include rectangles, ellipses, diamonds and lines, where a rectangle represents an entity, an ellipse represents an attribute, a diamond represents a relationship and a line represents a linking between the entity and attribute.

Answer: It states that a table must have a primary key

Sol. Entity integrity states that a table must have a primary key and the columns defined to be the primary key must be unique and not null. It also ensures that duplicate rows are not inserted in the table.

Answer: Data Standard Language

Sol. Common categories of SQL statements include DML, DCL, DDL, TCL, etc. DDL statements are used to define a database structure, DML statements are used for the management of data within database objects and DCL statements are used for setting privileges to access data.

Answer: DVD-O

Sol. DVD-ROM, DVD-R and DVD-RW are all types of DVD.

Answer: SSD

Sol. Solid State Drive (SSD) has the highest storage capacity. It can store up to 4 TB of data.

Answer: Option (c) and (d)

Sol. Piconet is an adhoc network that works on the Bluetooth technology and connects up to eight devices. It is also called personal area network (PAN). A scatternet is a type of ad hoc computer network consisting of two or more piconets.

Answer: Full-duplex mode

Sol. In the simplex mode, communication is always unidirectional, for example television. In the half-duplex mode, communication is bidirectional but one at a time, which means only one of the parties can send data at a time. Walkie-talkie is an example of half duplex communication. In the full-duplex mode, communication is bidirectional, which means both the parties can transmit data simultaneously. Telephone is an example of full-duplex communication. The semi-duplex mode is not and type of communication mode.

Answer: Master/slave

Sol. The working of Bluetooth devices is based on a master/slave model. This model contains 266 devices out of which one is a master device and 255 and slave devices. Any device can be master and the master device can select up to seven slave devices and communicate with them simultaneously.

Answer: Embedded OS

Sol. An embedded operating system is a specialized OS for use in the computers built into larger systems. Embedded Operating System is self-contained in device and resident in ROM.

Answer: Webmail interface

Sol. Webmail (or web-based email) is any email client implemented as a web application running on a web server. Examples of webmail software are Roundcube and SquirrelMail. Examples of webmail providers are AOL Mail, Gmail, Outlook.com and Yahoo!

Answer: Header and Footer

Sol. The header is a section of the document that appears in the top margin, while the footer is a section of the document that appears in the bottom margin. Headers and footers generally contain information such as the page number, date, and document name.