Computer Awareness MCQs | Computer Multiple Choice Questions with Answers

(1) What does the computer Motherboard contains that houses setting configurations and is powered by the onboard battery?
[A] DRAM
[B] RAM
[C] CMOS
[D] CPU
Answer: CMOS

Sol. The CMOS is a physical part of the motherboard: it is a memory chip that houses setting configurations and is powered by the onboard 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.

(2) Which of the following communications modes support two-way traffic but in only one direction of a time?
[A] Simplex
[B] Half-duplex
[C] Three-quarters duplex
[D] All of the above
Answer: Half-duplex

Sol. Half Duplex support two-way traffic but in only one direction of a time. For example, a walkie-talkie is a half-duplex device because only one party can talk at a time. In contrast, a telephone is a full-duplex device because both parties can talk simultaneously.

(3) Where are the files deleted from the hard disk sent to?
[A] Recycle bin
[B] Floppy disk
[C] Clipboard
[D] Clipart
Answer: Recycle bin

Sol. Files deleted from the hard disk sent to the recycle bin.

(4) Which of the following are type of Twisted Pair Cable?
[A] Coaxial Cable
[B] Shielded Twisted Pair (STP)
[C] Unshielded Twisted Pair (UTP)
[D] Only (b) and (c)
Answer: Only (b) and (c)

Sol. STP and UTP are type of Twisted Pair Cable which are mostly used in all Networks.

(5) 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
Answer: Spur-of-the-moment question

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.

(6) 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
Answer: 12

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.

(7) Which of the following is true about Page Preview Mode?
[A] You can see all pages of your document
[B] You can only see the page you are currently working
[C] You can only see pages that do not contain graphics
[D] You can only see the title page of your document
Answer: You can see all pages of your document

Sol. In page preview mode you can preview all the pages of the document.

(8) Network __________ is the arrangement of the various elements (links, nodes, etc.) of a computer network.
[A] Memory
[B] Topology
[C] Mainframe
[D] Protocol
Answer: Topology

Sol. Network topology is the arrangement of the various elements (links, nodes, etc.) of a computer network. There are two basic categories of network topologies: Physical topologies and Logical topologies.

(9) Which of the following terms is associated with Internet?
[A] Plotter
[B] Slide presentation
[C] Bookmark
[D] Pie Chart
Answer: Bookmark

Sol. A bookmark is a saved shortcut that directs your browser to a specific webpage. It stores the title, URL, and favicon of the corresponding page.

(10) A relational database consists of a collection of
[A] Tables
[B] Fields
[C] Records
[D] Keys
Answer: Tables

Sol. Relational database is a collection of Relations or Table. A table is also known as relation in RDBMS. Fields are the column of the relation or tables. Records are each row in relation. Keys are the constraints in a relation.

(11) The term attribute refers to a ___________ of a table.
[A] Record
[B] Column
[C] Tuple
[D] Key
Answer: Column

Sol. Attribute may refer to columns in a table and tuple refers to rows in a table.

(12) Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
[A] Instance, Schema
[B] Relation, Schema
[C] Relation, Domain
[D] Schema, Instance
Answer: Schema, Instance

Sol. Instance is an instance of time and schema is a representation.

(13) In relational database, a field is a
[A] Label
[B] Table of information
[C] Group of related tables
[D] Category of information
Answer: Category of information

Sol. A field is category of information.

(14) Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
[A] Candidate key
[B] Sub key
[C] Super key
[D] Foreign key
Answer: Super key

Sol. Super key is a set of one or more attributes taken collectively to uniquely identify a record.

(15) A __________ is an abstract model that describes, how the data are organized and represented.
[A] Data model
[B] Instances
[C] Schema
[D] Database
Answer: Data model

Sol. A Data Model is a logical structure of Database. Data model is an abstract model that describes, how the data are organized and represented.

(16) Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
[A] IDMS
[B] DB2
[C] DBase-II
[D] R:base
Answer: DB2

Sol. DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is designed to store, analyze and retrieve the data efficiently.

(17) Before use of DBMS information was stored using
[A] Cloud Storage
[B] Data System
[C] File Management System
[D] Cloud Computing
Answer: File Management System

Sol. Earlier File Management Systems were used, before the usage of DBMS.

(18) ____________ is an interface between low level database and application program.
[A] Database Associate
[B] Database Server
[C] Database or Store Manager
[D] Database Constrains
Answer: Database or Store Manager

Sol. Storage manager is a program module that provides the interface between the low-level data stored in the database and the application programs and queries submitted to the system.The storage manager is responsible to the following tasks: interaction with the file manager;and efficient storing, retrieving and updating of data.

(19) Which of the following is a binary number?
[A] 10101011
[B] 5600
[C] 2020
[D] None of the above
Answer: 10101011

Sol. Binary Numbers use only '0' and '1'.

(20) What type of software creates a smaller file that is faster to transfer over the Internet?
[A] Compression
[B] AVG
[C] Fragmentation
[D] MPEG
Answer: Compression

Sol. Compression is the process of reducing the size of a file by encoding its data information more efficiently. By doing this, the result is a reduction in the number of bits and bytes used to store the information.

View All Computer Awareness Questions Sets

Take Mock Tests

Missiles Mock Test Start Test!
SSC MTS Mock Test Start Test
IBPS CLERK MOCK TEST Start Test
SSC MTS 2022 JULY 26 Shift 1 (ENGLISH) Start Test!
SSC GD Previous Year Paper 2021 Nov 17 Shift - I (Hindi) Start Test!
SSC CGL Tier - 1 PYP 2022 April 21 Shift- 1 (ENGLISH) Start Test!
MPSC PAPER I MOCK TEST 1 (ENGLISH) Start Test!
IB Security Assistant Mock test 1 (english) Start Test!
UP POLICE CONSTABLE MOCK TEST 1 Start Test!
DELHI POLICE CONSTABLE MOCK TEST 1 (HINDI) Start Test!