Which of the following statements is true for three-tier architecture?
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.
Which of the following are valid minimum & maximum zoom sizes in MS word?
Answer: 10, 500
Sol. 10 and 500 are valid minimum & maximum zoom sizes in MS word.
Each time you turn on your computer, it will check on the control file
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.
Name the program a personal computer's microprocessor uses to get the computer system started after you turn it on
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.
Which of the following statements is not true about cache memory?
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.
WORM stands for?
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.
Who among the following is/were inventor of transistors?
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.
Who invented the QWERTY keyboard?
Answer: Christopher Latham Sholes
Sol. Christopher Latham Sholes invented the keyboard in 1868.
What is Windows Vista?
Answer: Operating System
Sol. Windows Vista is an operating system, designed and marketed by Microsoft Inc.
In the ER diagram, what does an ellipse represent?
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.
Which of the following statements is true for entity integrity?
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.
Which of the following is not a type of SQL statement?
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.
Which of the following is not a type of DVD?
Sol. DVD-ROM, DVD-R and DVD-RW are all types of DVD.
Which among the following devices has highest storage capacity?
Sol. Solid State Drive (SSD) has the highest storage capacity. It can store up to 4 TB of data.
Which of the following statements is true for a piconet?
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.
Which communication mode allows both the sender and the receiver to transmit data at the same time over a single communication channel?
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.
On which of the following models does the working of Bluetooth devices depend?
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.
Which operating system is defined as self-contained in device and resident in ROM?
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.
A(n) ________ allows you to access your e-mail from anywhere
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!
Which of the following options is used to display information such as title, page number of the document?
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.
Miscellaneous GK Questions