Introduction of Computer Science MCQ

Introduction of Computer Science MCQ

1.The OSI reference model is
A) Worthless
B) A protocol
C) Not a protocol
D) None of these ✔️

2.A data packet is a packet header together with
A) A network layer
B) An administrative layer
C) User Data ✔️
D) A packet switch

3.The application layer of the OSI model is the
A) Seventh Layer ✔️
B) Sixth layer
C) Fifth layer
D) Fourth layer

4.Working of the WAN generally involves
A) Satellite ✔️
B) Frame delay
C) ATM
D) User agent

5.Which of the following technique provides dedicated communication channel between two stations.
A) Switch network
B) Circuit Switching ✔️
C) Packet switching
D) None of these

6.End-to-end connectivity is provided from host-to-host in
A) Network layer
B) Session layer
C) Data link layer
D) Transport Layer ✔️

7.Base band is
A) Transmission of Signals without Modulation ✔️
B) A signal all of whose energy is contained within a finite frequency range.
C) The simultaneous transmission of data to a number of stations
D) All of the above

8.The simultaneous transmission of data to a number of stations is known as
A) Broad cast ✔️
B) Bandwidth
C) Aloha
D) analog transmission

9.The communication mode that supports data in both directions
A) Simplex
B) Half Duplex ✔️
C) Duplex
D) Bultiplex

10.Modulation is the process of
A) Sending a file from one computer to another computer
B) Converting Digital Signals to Analog Signals ✔️
C) Converting analog signals to digital signals
D) Echoing every character that is received

11.A distributed network configuration in which all data/information pass through a central computer is
A) Bus network
B) Star Network
C) Duplex
D) Multiplex

12.To connect a computer with a device in the same room, you might be likely to use
A) A Coaxial Cable ✔️
B) A dedicated time
C) A ground station
D) All of the above

13.Administrative supervision of database activities is the responsibility of the
A) Data Base Administrator ✔️
B) DP Manager
C) DB Manager
D) VP-DP administrator

14.Which of the following component of a computer system is the most important to a data base management system
A) Mouse
B) High resolution video display
C) Printer
D) High Speed, Large Capacity Disk ✔️

15.What is the serious problem(s) of file management systems
A) Data redundancy
B) Difficult to update
C) Program dependence
D) All of the Above ✔️

16.Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time
A) Master file
B) Transaction File ✔️
C) Report
D) Query file

17.In a database, related fields are grouped to form
A) Record ✔️
B) File
C) Bank
D) Field group

18.A table consists of
A) Fields and columns
B) Rows and Columns ✔️
C) Rows and cells
D) None of these

19.The purpose of an index is to provide……….. to the file it is indexing
A) Storage area
B) Access Path ✔️
C) Name
D) Number

20.The database environment has all of the following components except
A) Users
B) Separate Files ✔️
C) Database
D) Database administrator

21.Which of the following is an advantage of the database approach
A) Elimination of data redundancy
B) Ability to associate related data
C) Increased security
D) All of the Above ✔️

22.When changes occur in a data item, if every file which contains that field should not be updated then, it leads to
A) Data redundancy
B) Data inconsistency ✔️
C) Data security
D) Data loss

23.When the same data field is stored more than once in a file, then it leads to
A) Data Redundancy ✔️
B) Data inconsistency
C) Data dependency
D) Data independency

24.Data security threats include
A) Privacy invasion
B) Hardware failure
C) Fraudulent manipulation of data
D) All of the Above ✔️

25.Updating a database means
A) Revising a file structure
B) Reorganizing the database
C) Modifying or adding records
D) All of the Above ✔️

26.Firmware means
A) Software
B) Hardware
C) Software Available on Hardware ✔️
D) None of these

27.For each instructions of program in memory the CPU goes through a
A) Decode – fetch – execute sequence
B) Execute – store – decode sequence
C) Fetch – Decode – Execute Sequence ✔️
D) Fetch – execute – decode sequence

28.Which of the following is the ascending order of data hierarchy
A) Bit – byte – record – field – data base – file
B) Bit – Byte – Field – Record – File – Database ✔️
C) Bit – byte – file – field – record – database
D) Bit – record – byte – field – file – database

29.A microcomputer consists of at least an input unit, an output unit, microprocessor unit and a
A) Stabilizer
B) Memory Unit ✔️
C) Printer
D) Network

30.Magnetic tape can serve as
A) Input media
B) Output media
C) Secondary storage media
D) All of the Above ✔️

31.Super computers are mainly useful for
A) Mathematical Intensive Scientific Applications ✔️
B) Data-retrieval operations
C) Input-output intensive processing
D) All of the above

32.Which of the following storage is volatile
A) Semiconductor Memory ✔️
B) Floppy disk
C) CD-ROM
D) Core memory

33.RAM chips
A) Allow The Computer to Store Data Electronically ✔️
B) Store data indefinitely unless you delete it
C) Are secondary memory
D) All of the above

34.EEPROM is
A) Easily erasable
B) Non-erasable
C) Effectively erasable
D) Electrically Erasable ✔️

35.Multiprocessing
A) Makes the operating system simpler
B) Allows multiple processes to run simultaneously
C) Is completely understood by all major computer vendors
D) Allows The Same Computer to Have Multiple Processors ✔️

36.How many units in a single bus structure will communicate at a time
A) 1
B) 2 ✔️
C) 3
D) 14

37.Arithmetic logic unit
I. perform arithmetic operations
II. store data
III.perform comparison
IV.communicate with input devices of the
above the correct one is
A) I Only
B) II Only
C) I and II Only
D) I and III Only ✔️