Download PDF
Free download in PDF Computer Awareness Multiple Choice Questions(MCQs) & Answers. These multiple choice questions on Computer Science are very useful for NIELIT, BCA, B.Sc. MCA, M.Sc. B.Tech, M.Tech, BE, ME students an interview for various positions like Web Developer, System Analyst etc.
(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.
Please share this page