Miscellaneous Computer Science MCQ Questions with Answers

Question. The most common communications devices all use ___ transmission, a continuous electrical signal in the form of a wave.
(a) analog
(b) digital
(c) automatic
(d) all
(e) None of these

Answer. A

Question. A (n) __________ adapter can move data at 128,000 bps, more than double a standard modem
(a) Fax
(b) Dial-Up
(c) Telephone modem
(d) ISD
(e) None of these

Answer. D

Question. Which of the following devices takes data sent from one network device and forwards it to all devices on the network regardless of the intended recipient?
(a) Switch
(b) DNS Server
(c) Hub
(d) Gateway
(e) All

Answer. C

Question. Star Topology is based on a Central Device that can be __________.
(a) HUB
(b) Switch
(c) Router
(d) Both 1 and 2
(e) Gateway

Answer. D

Question. Which of the following network devices/systems translates data from one format to another?
(a) DHCP Server
(b) Hub
(c) Gateway
(d) NIC
(e) Switch

Answer. C

Question. In this network arrangement, all computers have equal status.
(a) Client/server
(b) Client-to-client
(c) Peer-to-peer
(d) Token ring
(e) Server/ Terminal

Answer. A

Question. HUB is a _________ Device and Switch is a ________ Device.
(a) Unicast, Multicast
(b) Multicast, Unicast
(c) Broadcast, Unicast
(d) Unicast, Unicast
(e) Multicast, Multicast

Answer. C

Question. A network of personal computers that share hardware, software, and data is called a ________.
(a) local area network (LAN)
(b) metropolitan area network (MAN)
(c) wide area network (WAN)
(d) plain old telephone service (POTS)
(e) None of these

Answer. A

Question. Which of the following devices modulates digital signals into analog signals that can be sent over traditional telephone lines?
(a) Router
(b) Gateway
(c) Switch
(d) Modem
(e) NIC

Answer. D

Question. _________ processing method allows both remote access and remote processing.
(a) Analog transmission
(b) Centralized data processing
(c) Distributed data processing
(d) Digital transmission
(e) Hierarchy processing

Answer. C

Question. Which of the following is not Unary operation?
(a) Select
(b) Project
(c) Rename
(d) Union
(e) None of these

Answer. D

Question. Which of the following is not binary operation?
(a) Union
(b) Project
(c) Set Difference
(d) Cartesian Product
(e) None of these

Answer. E

Question. A computer system that uses communications equipment to connect two or more computers and their resources is a __________.
(a) network
(b) hub
(c) bridge
(d) router
(e) firewall

Answer. A

Question. The language used by application programs to request data from the DBMS is referred to the-
(a) DML
(b) DDL
(c) query language
(d) All of the above
(e) None of these

Answer. A

Question. COMMIT and ROLLBACK in DBMS are the example of -
(a) DDL
(b) DML
(c) TQL
(d) DQL
(e) None of these

Answer. C

Question. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
(a) Relational
(b) Structural
(c) Network
(d) All of the above
(e) None of these

Answer. B

Question. A network of geographically distant computers and terminals is called a:
(a) Integrated Services Digital Network (ISDN)
(b) local area network (LAN)
(c) metropolitan area network (MAN)
(d) wide area network (WAN)
(e) All of the above

Answer. D

Question. Which class of IP address provides a maximum of only 254 host addresses per network ID?
(a) Class E
(b) Class B
(c) Class C
(d) Class D
(e) Class A

Answer. C

Question. In Data base , properties of any entity are represented by its -
(a) Setting
(b) Tuples
(c) Attributes
(d) Degree
(e) None of these

Answer. C

Question. Which of the following devices translates hostnames into IP addresses?
(a) DNS Server
(b) Hub
(c) DHCP Server
(d) Firewall
(e) MAC

Answer. A

Question. Which of the following is a type of DBMS Software?
(a) Data
(b) My SQL
(c) MS-office
(d) utility
(e) None of these

Answer. B

Question. Set of permitted values of each attribute is called ______.
(a) Domain
(b) Relation
(c) Tuple
(d) Schema
(e) None of these

Answer. A

Question. Which of the following is NOT a type of Microsoft Access database object?
(a) Queries
(b) Workbooks
(c) Forms
(d) Tables
(e) None of these

Answer. B

Question. ________ method places all processing, hardware, and software in one central location.
(a) Wide area data processing
(b) Network data processing
(c) Centralized data processing
(d) Distributed data processing
(e) None of these

Answer. C

Question. Data items grouped together for storage purposes are called-
(a) Record
(b) Title
(c) List
(d) string
(e) None of these

Answer. A

Question. A command to remove a relation from an SQL database is ____.
(a) Delete table <table name>
(b) Drop table <table name>
(c) Erase table <table name>
(d) Alter table <table name>
(e) None of these

Answer. B

Question. The feature that database allows to access only certain records in database is:
(a) Forms
(b) Reports
(c) Queries
(d) Tables
(e) None of these

Answer. C

Question. Switch is a device of _________ Layer of OSI Model.
(a) Network Layer
(b) Data Link Layer
(c) Application Layer
(d) Session Layer
(e) None of these

Answer. B

Question. Database utility exist in —————— menu ?
(a) Format
(b) tools
(c) File
(d) Edit
(e) None of these

Answer. B

Question. The complete picture of data stored in database is known as
(a) System flowchart
(b) Schema
(c) record
(d) DBMS
(e) None of these

Answer. B

Question. In which object sql is used ?
(a) Query
(b) Form
(c) Report
(d) Macro
(e) None of these

Answer. A

Question. Which of the following devices takes data sent from one network device and forwards it to the destination node based on MAC address?
(a) Hub
(b) Switch
(c) Gateway
(d) Modem
(e) All

Answer. B

Question. What is there in record ?
(a) Collection of field
(b) collection of Number
(c) Collection of rows
(d) All of above
(e) None of these

Answer. A

Question. The protocol that makes Internet universality possible is _________.
(a) FEP
(b) WAN
(c) POTS
(d) TCP/IP
(e) MAN

Answer. D

Question. Which is not related to database ?
(a) Table
(b) Query
(c) Form
(d) Macro
(e) None of these

Answer. C

Question. The default date format in SQL is?
(a) DD-MON-YY
(b) DD-MM-YY
(c) DD-MM-YYY
(d) DD-MM-YYYY
(e) None of these

Answer. C

Question. Entities having primary key are called?
(a) Primary Entities
(b) Strong Entities
(c) Weak Entities
(d) Primary Key
(e) None of these

Answer. B

Question. Type of a file is identified by -
(a) File
(b) Attribute
(c) Extension
(d) Properties
(e) None of these

Answer. C

Question. The primary key must be ____.
(a) Unique
(b) Not null
(c) Both 1 and 2
(d) Either 1 or 2
(e) None of these

Answer. C

Question. A subset of characters within a data field is known as
(a) Record
(b) File
(c) Data string
(d) Byte
(e) None of these

Answer. C

Question. Computer systems that transmit data over communications lines, such as telephone lines or cables are called______.
(a) home-based systems
(b) centralized data systems
(c) data networks
(d) data communications systems
(e) Wi-Fi system

Answer. D

Question. Snapshot of the data in the database at a given instant of time is called _____.
(a) Database Schema
(b) Database Instance
(c) Database Snapshot
(d) All of the above
(e) None of these

Answer. B

Question. Which of the following devices is used to connect same network segments and manage the traffic between them?
(a) Switch
(b) Hub
(c) Modem
(d) Repeater
(e) Bridge

Answer. E

Question. What is the function of relationship ?
(a) Relate multiple table
(b) Relate multiple form
(c) Relate table and form
(d) Relate queries and forms
(e) None of these

Answer. A

Question. The raw facts and figures are:
(a) Program
(b) Information
(c) Snapshot
(d) Reports
(e) None of these

Answer. E

Question. Which operation is not permitted by query?
(a) delete
(b) entry
(c) Modify
(d) create table
(e) None of these

Answer. B

Question. In the E-R diagrams, the term cardinality is a synonym for the term?
(a) Attribute
(b) Degree
(c) Entities
(d) Cartesian
(e) None of these

Answer. D

Question. TRUNCATE statement in SQL is a ____.
(a) DML statement
(b) DDL statement
(c) DCL statement
(d) TCL statement
(e) None of above

Answer. B

Question. Logical design of the database is called ______.
(a) Database Snapshot
(b) Database Instance
(c) Database Schema
(d) All of the above
(e) None of these

Answer. C

Question. For adding number of hours to a date, which of the following statement is used ?
(a) Date + Number
(b) Date + Number/24
(c) Date+Number of Hours
(d) Date +Hour/30
(e) None of above

Answer. B

Question. The RDBMS terminology for a row is _______?
(a) Tuple
(b) Relation
(c) Attribute
(d) Degree
(e) Field

Answer. A

Question. Which of the following operations need the participating relations to be union compatible?
(a) UNION
(b) INTERSECTION0
(c) DIFFERENC
(d) All of the above
(e) None of these

Answer. D

Question. A command that lets you change one or more fields of a record is?
(a) Insert
(b) Modify
(c) Look-up
(d) All of above
(e) None of above

Answer. A

Question. What is the minimum number of wires needed to send data over a serial communication link layer ?
(a) 1
(b) 2
(c) 4
(d) 6
(e) None of these

Answer. B

Question. Device that connect to the network without using cables is called———.
(a) Distributed
(b) Wireless
(c) Centralized
(d) Open source
(e) None of these

Answer. B

Question. In an ER Diagram, ellipse with underlying lines is used to represent _________?
(a) attribute
(b) Key attribute
(c) Composite attribute
(d) Multivalued attribute
(e) Entity

Answer. B

Question. What is a relationship called when it is maintained between two entities?
(a) Unary
(b) Binary
(c) Ternary
(d) Quaternary
(e) 1 and 2

Answer. B

Question. Which of the following operation is used if we are interested in only certain columns of a table?
(a) PROJECTION
(b) SELECTION
(c) UNION
(d) JOIN
(e) Intersect

Answer. A

Question. The conceptual model is _______ .
(a) dependent on hardware
(b) dependent on software
(c) dependent on both hardware and software
(d) independent of both hardware and software
(e) None of these

Answer. D

Question. ________ is a process when relation between two entity is treated as a single entity.
(a) Normalization
(b) Aggregation
(c) Generalization
(d) Specialization
(e) Simplification

Answer. B

Question. Which of the following is a valid SQL type?
(a) CHARACTER
(b) NUMERIC
(c) FLOAT
(d) DATE
(e) All of the above

Answer. E

Question. Which database level is closest to the users?
(a) External
(b) Internal
(c) Physical
(d) Conceptual
(e) None of these

Answer. A

Question. The loss in signal power as light travels down the fiber is called
(a) Attenuation
(b) Interruption
(c) Scattering
(d) Propogation
(e) None of these

Answer. A

Question. Which are the two ways in which entities can participate in a relationship?
(a) Passive and active
(b) Total and partial
(c) Simple and Complex
(d) All of the above
(e) None of these

Answer. B

Question. Which device can not be shared in Network?
(a) Computer
(b) Keyboard
(c) Floppy
(d) Printer
(e) None of these

Answer. B

Question. The result of the UNION operation between R1 and R2 is a relation that includes _______.
(a) All the tuples of R1
(b) All the tuples of R2
(c) All the tuples of R1 and R2
(d) All the tuples of R1 and R2 which have common columns
(e) None of these

Answer. D

Question. The most important and powerful computer are typically____.
(a) Desktop
(b) Network client
(c) Network server
(d) Networkstation
(e) Super computer

Answer. E

Question. _________ constraint is used to restrict actions that would destroy links between tables?
(a) Primary key
(b) Foreign Key
(c) Check
(d) Not Null
(e) Unique

Answer. B

Question. A data dictionary is a special file that contains?
(a) the data types of all fields in all files
(b) the names of all fields in all files
(c) the widths of all fields in all files
(d) All of above
(e) None of above

Answer. D

Question. It is better to use files than a DBMS when there are _______ .
(a) Stringent real-time requirements
(b) Multiple users who wish to access the data
(c) Complex relationships among data
(d) All of the above
(e) None of these

Answer. B

Question. In OSI network architecture, the routing is performed by ............. ?
(a) Network layer
(b) Data link layer
(c) Transport layer
(d) Session layer
(e) None of these

Answer. A

Question. Which of the following option appropriate is a comparison operator in SQL?
(a) =
(b) LIKE
(c) BETWEEN
(d) All of the above
(e) None of these

Answer. D

Question. Which is the first layer of OSI model-
(a) Physical layer
(b) Link layer
(c) Transport layer
(d) Network layer
(e) None of these

Answer. A

Question. Which of the following performs modulation and demodulation ?
(a) Fiber optics
(b) Satellite
(c) Coaxial Cable
(d) Encoder/Decoder
(e) None of these

Answer. E

Question. Bandwidth means -
(a) Channel capacity
(b) Data transmission
(c) Cable lengt
(d) All
(e) None of these

Answer. D

Question. Example of connectivity is_______
(a) Internet
(b) Floppy disk
(c) Powercord
(d) Data
(e) None of these

Answer. A

Question. The user account can only be created by the
(a) User
(b) Network administrator
(c) Security administrator
(d) Project incharge
(e) None of these

Answer. B

Question. Digital signal used in ISDN have -
(a) Discrete value
(b) Any value
(c) whole no value
(d) fractional value
(e) None of these

Answer. A

Question. Which of the following has highest complex interconnection?
(a) Bus
(b) Ring
(c) Star
(d) Mesh
(e) None of these

Answer. D

Question. In a table of data base, degree refers
(a) total numer of row
(b) row in a table
(c) column in a table
(d) total number of column in a table
(e) none of these

Answer. D

Question. A ____________ uses long-distance transmission media to link computers separated by distance.
(a) circuit-switching network
(b) Wi-Fi
(c) WAN
(d) LAN
(e) None of these

Answer. C

Question. Which one of the following is used as connect to the internet?
(a) Web browser
(b) Net fitter
(c) Windows 95
(d) Cable
(e) None of these

Answer. D

Question. Computers connected to a LAN (Local Area Network) can—
(a) Run faster
(b) Go on line
(c) Share information and/or share peripheral equipment
(d) E-mail
(e) None of these

Answer. C

Question. The Switching Elements are also called as _____.
(a) Host
(b) Terminal
(c) Interface Message Processors (IMPs)
(d) Both 1 and 2
(e) Subnet

Answer. A

Question. Which of the following is NOT considered as a network communications device?
(a) Network interface card (NIC)
(b) Modem
(c) Data bus
(d) Router
(e) None of these

Answer. C

Question. What is the function of network neighbourhood?
(a) To navigate shared computer and folder in Network
(b) To identify who is living near to you
(c) Send messages to neighbouring computer
(d) Both 1 & 2
(e) None of these

Answer. A

Question. Who decide about the division of work with respect to IT security?
(a) Data owner
(b) Senior Manager
(c) Data Custodian
(d) Data user
(e) None of these

Answer. B

Question. The full form of DDL is _______?
(a) Dynamic Data Language
(b) Detailed Data Language
(c) Data Definition Language
(d) Data Derivation Language
(e) Data Dimensional Language

Answer. C

Question. An unauthorized user is a network _______ issue.
(a) Performance
(b) Reliability
(c) Security
(d) Firewall
(e) None of these

Answer. C

Question. Which of the following is an invalid IP Address -
(a) 10. 226. 0. 15
(b) 192. 168. 0.12
(c) 10. 265. 0 .115
(d) 192. 168. 0. 1
(e) None of these

Answer. C

Question. Which of the following refers to a small, single-site network?
(a) LAN
(b) DSL
(c) RAM
(d) USB
(e) CPU

Answer. A

Question. What is a stub network?
(a) A network that has only one entry and exit point.
(b) A network with only one entry and no exit point.
(c) A network with more than one exit point.
(d) A network with more than one exit and entry point.
(e) A network with more than one entry point.

Answer. A

Question. Which of the following terms is used to describe a hardware- or software-based device that protects networks from outside threats?
(a) NIC
(b) Gateway
(c) Firewall
(d) Hub
(e) Server

Answer. C

Question. The distance a simple signal can travel in one period is called ________.
(a) Wavelength
(b) Frequency
(c) Propagation speed
(d) Both 1 and 2
(e) None of these

Answer. B

Question. Which of the following services use TCP?
(a) DHCP
(b) SMTP
(c) FTP
(d) HTTP
(e) 2, 3 and 4

Answer. E

Question. CBS is the example of -
(a) LAN
(b) WAN
(c) Internet
(d) Intranet
(e) None of these

Answer. D

Question. In a large DBMS?
(a) Each user can see only a small part of the entire database
(b) Each user can access every sub schema
(c) Each sub schema contains every field in the logical schema
(d) All of above
(e) None of above

Answer. A

Question. Which device is used to connect a computer over the Telephone Network.
(a) Router
(b) Hub
(c) VSAT
(d) Gateway
(e) None of these

Answer. E

Question. Which layer of OSI Model is closest to the user-
(a) Physcial layer
(b) Transport layer
(c) Application layer
(d) Network layer
(e) None of these

Answer. C

Question. Which of the following is considered as a broad band communications channel?
(a) co-axial cable
(b) fiber optic cable
(c) microwave circuits
(d) satellite systems
(e) All of the above

Answer. E

Question. Which of the following communication mode support two way traffic but only in one direction at a time?
(a) Simplex
(b) half-duplex
(c) three-quaters duplex
(d) All of the Above
(e) None of these

Answer. B

Question. Which of the following is NOT a type of broadband Internet connection?
(a) Cable
(b) DSL
(c) Dial-up
(d) Satellite
(e) None of these

Answer. C

Question. Copper wire is an example of?
(a) Guided Transmission Media
(b) Shield Media
(c) Group Media
(d) Unguided Transmission Media
(e) None of these

Answer. A

Question. Work group means ?
(a) Computer in Network
(b) Individual user
(c) Individual deposit
(d) All of above
(e) None of these

Answer. A

Question. Which of the following is not an example of security and privacy risk ?
(a) Hackers
(b) Spam
(c) Virus
(d) Identity theft
(e) None of these

Answer. B

Question. Which of the following is an advantage of a View?
(a) Data security
(b) Derived columns
(c) Hiding of complex queries
(d) All of the above
(e) None of these

Answer. D

Question. Which one is a valid IP address?
(a) 300.215.317.3
(b) 302.215.417.5
(c) 202.50.20.148
(d) 202-5-20-148
(e) None of these

Answer. C

Question. Which type of transmission media is known as regular telephone wire?
(a) Wi-Fi
(b) Twisted-pair wire
(c) Fiber optic cable
(d) Coaxial cable
(e) All

Answer. B

Question. What is the purpose of a firewall on a computer?
(a) To protect a computer from unauthorized access
(b) To protect a computer in case of fire
(c) To protect a computer from spam
(d) All of the above
(e) None of these

Answer. A

Question. Which of the following layer is not in OSI model?
(a) Physical layer
(b) Internet layer
(c) Network layer
(d) Transport layer
(e) Application layer

Answer. B

Question. Which topology requires a central controller or hub?
(a) Mesh
(b) Star
(c) Bus
(d) Ring
(e) Tree

Answer. B

Question. Which topology requires a multipoint connection?
(a) Mesh
(b) Star
(c) Bus
(d) Ring
(e) Tree

Answer. C

Question. Netware is a product of which company ?
(a) Microsoft
(b) Redhat
(c) Novell
(d) Window
(e) None of these

Answer. C

Question. A communication processor that connects dissimilar networks by providing the translation from one set of protocol to another is—
(a) Modem
(b) Gateway
(c) Router
(d) Bridge
(e) All of these

Answer. B

Question. A group of computers and other devices connected together is called________.
(a) Network
(b) Intranet
(c) Internetworking
(d) Both 2 and 3
(e) Extranet

Answer. A

Question. Transmission Lines are also called as________.
(a) Circuits
(b) Channels
(c) Trunks
(d) Circuits channels, or trunks
(e) Wire

Answer. C

Question. Network which is connected over a Geographic area is called -
(a) LAN
(b) MAN
(c) WAN
(d) CAN
(e) None of these

Answer. C

Question. How many collision domains are created when you segment a network with a 12-port switch?
(a) 1
(b) 12
(c) 5
(d) 2
(e) 10 12

Answer. C

Question. Which protocol does Ping use?
(a) TCP
(b) ARP
(c) ICMP
(d) BootP
(e) UDP

Answer. A