4320 + Mcqs in Computer Science Page 59 McqOptions

2901.	Networks where end user workstations are tied to LAN servers to share resources and application processing.
A.	Internetworked enterprise
B.	Information super highway
C.	Business applications of telecommunications
D.	Client/Server networks
Answer» E.

Discussion

2902.	In OSI network architecture, the dialogue control and token management are responsibilities of
A.	session layer
B.	network layer
C.	transport layer
D.	data link layer
E.	None of the above
Answer» B. network layer

Discussion

2903.	The modify operation is likely to be done after
A.	Delete
B.	Look-up
C.	Insert
D.	All of the above
E.	None of the above
Answer» C. Insert

Discussion

2904.	One data dictionary software package is called
A.	DB/DC dictionary
B.	TOTAL
C.	ACCESS
D.	any of the above
E.	None of the above
Answer» B. TOTAL

Discussion

2905.	One approach to standardizing storing of data
A.	MIS
B.	structured programming
C.	CODASYL specifications
D.	All of the above
E.	None of the above
Answer» D. All of the above

Discussion

2906.	What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
A.	Special purpose packages
B.	Custom made programs
C.	Single function application packages
D.	Data management packages
E.	None of the above
Answer» E. None of the above

Discussion

2907.	In SQL, which command(s) is(are) used to change a table's storage characteristics?
A.	ALTER TABLE
B.	MODIFY TABLE
C.	CHANGE TABLE
D.	All of the above
E.	None of the above
Answer» B. MODIFY TABLE

Discussion

2908.	In SQL, which of the following is not a data definition language commands?
A.	RENAME
B.	REVOKE
C.	GRANT
D.	UPDATE
E.	None of the above
Answer» E. None of the above

Discussion

2909.	Database management systems are intended to:
A.	eliminate data redundancy
B.	establish relationships among records in different files
C.	manage file access
D.	maintain data integrity
E.	All of the above
Answer» F.

Discussion

2910.	In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
A.	CREATE PACKAGE
B.	CREATE SCHEMA
C.	CREATE CLUSTER
D.	All of the above
E.	None of the above ;
Answer» C. CREATE CLUSTER

Discussion

2911.	Goals for the design of the logical schema include
A.	avoiding data inconsistency
B.	being able to construct queries easily
C.	being able to access data efficiently
D.	All of the above
E.	None of the above
Answer» E. None of the above

Discussion

2912.	In order to use a DBMS, it is important to understand
A.	the physical schema
B.	all sub-schemas that the system supports
C.	one subschema
D.	both (a) and (b)
E.	None of the above
Answer» D. both (a) and (b)

Discussion

2913.	In SQL, which command(s) is(are) used to recompile a stored function?
A.	SET FUNCTION
B.	SET STORED FUNCTION
C.	ALTER FUNCTION
D.	All of the above
E.	None of the above
Answer» D. All of the above

Discussion

2914.	Report generators are used to
A.	store data input by a user
B.	retrieve information from files
C.	answer queries
D.	both (b) and (c)
E.	None of the above
Answer» E. None of the above

Discussion

2915.	Administrate supervision of database activities is the responsibility of the
A.	Database administrator
B.	DP Manager
C.	DB Manager
D.	DP administration
E.	None of the above
Answer» B. DP Manager

Discussion

2916.	Which of the following connectivity devices is used to extend a network on a purely mechanical basis?
A.	Gateway
B.	Switch
C.	Router
D.	Active hub
Answer» E.

Discussion

2917.	Which of the following transmission systems provides the highest data rate to an individual device
A.	Computer bus
B.	Telephone lines
C.	Voice band modem
D.	leased lines
E.	None of the above
Answer» B. Telephone lines

Discussion

2918.	The IEEE 802 project of the 1980s involved further defining the lower two layers of the OSI model. A number of standards were agreed upon during that time. Which of the following is the standard for Ethernet?
A.	802.2
B.	802.3
C.	802.4
D.	802.5
E.	802.6
Answer» C. 802.4

Discussion

2919.	If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
A.	Delete
B.	Update
C.	Sort Key
D.	Index
E.	None of the above
Answer» E. None of the above

Discussion

2920.	Which transmission mode is used for data communication along telephone lines?
A.	Parallel
B.	Serial
C.	Synchronous
D.	Asynchronous
E.	None of the above
Answer» C. Synchronous

Discussion

2921.	Who invented the modem?
A.	Wang Laboratories Ltd.
B.	AT & T Information Systems, USA
C.	Apple Computers Inc.
D.	Digital Equipment Corpn.
E.	None of the above
Answer» C. Apple Computers Inc.

Discussion

2922.	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.	full-of the above
E.	None of the above
Answer» C. three-quarters duplex

Discussion

2923.	Which of the following TCP/IP internet protocol a diskless machine uses to obtain its IP address from a server?
A.	RDP
B.	RARP
C.	RIP
D.	X.25
E.	None of the above
Answer» C. RIP

Discussion

2924.	When two computers communicate with each other, they send information back and forth. If they are separated by a reasonable distance, they can send and receive the information through a direct cable connection which is called a null-modem connection. Presently what is the maximum distance in metres permitted in this null-modem connection?
A.	80
B.	100
C.	30
D.	150
E.	None of the above
Answer» D. 150

Discussion

2925.	Eight stations are competing for the use of the shared channel using the modified Adaptive free walk protocol by Gallager. If the stations 7 and 8 are suddenly become ready at once, how many bit slots are needed to resolve the contention?
A.	1 slots
B.	5 slots
C.	10 slots
D.	14 slots
Answer» C. 10 slots

Discussion

2926.	You have been contracted to install a windows NT network in an office that is located in a strip mall. The office is located next to the power plant of the building, so a UPS (uninterruptible power supply) has already been installed. What type of cable should you use for the network cabling? Choose the best answer.
A.	TI
B.	UTP
C.	Fiber-optic
D.	PSTN
E.	STP
Answer» F.

Discussion

2927.	Communication circuits that transmit data in both directions but not at the same time are operating in
A.	a simplex mode
B.	a half-duplex mode
C.	a full-duplex mode
D.	an asynchronous mode
E.	None of the above
Answer» C. a full-duplex mode

Discussion

2928.	We can receive data either through our television aerial or down our telephone lines and display this data on our television screen. What is the general name given to this process?
A.	Viewdata
B.	Teletext
C.	Telesoftware
D.	Videotex
E.	None of the above
Answer» E. None of the above

Discussion

2929.	ASK, PSK, FSK, and QAM are examples of _____ encoding.
A.	digital-to-digital
B.	digital-to-analog
C.	analog-to-analog
D.	analog-to-digital
Answer» C. analog-to-analog

Discussion

2930.	What function does a serial interface perform in data communication?
A.	Converts serial data into audio signals
B.	Converts analog signals into digital signals
C.	Converts parallel data into a stream of bits
D.	Decodes incoming signals into computer data
E.	None of the above
Answer» D. Decodes incoming signals into computer data

Discussion

2931.	You need to determine whether IP information has been assigned to your Windows NT. Which utility should you use?
A.	NBTSTAT
B.	NETSTAT
C.	IPCONFIG
D.	WINIPCFG
E.	PING
Answer» D. WINIPCFG

Discussion

2932.	In a synchronous modem, the digital-to-analog converter transmits signal to the
A.	equalizer
B.	modulator
C.	demodulator
D.	terminal
E.	None of the above
Answer» B. modulator

Discussion

2933.	If the client receives an address from a DHCP server, what is the only information available in the Network Properties dialog box?
A.	The IP address
B.	The subnet address
C.	That the client is receiving its address from DHCP
D.	The default gateway
E.	None of the above
Answer» D. The default gateway

Discussion

2934.	An internetworking protocol that provides virtual circuit service across multiple X.25 protocol, is
A.	X.75
B.	X.25
C.	X.400
D.	X.21
E.	None of the above
Answer» B. X.25

Discussion

2935.	Which of the following TCP/IP protocol is used for transferring files from one machine to another?
A.	RARP
B.	ARP
C.	TCP
D.	FTP
E.	None of the above
Answer» E. None of the above

Discussion

2936.	IEEE project 802 divides the data link layer into an upper _____ sublayer and a lower _____ sublayer.
A.	HDLC, PDU
B.	PDU, HDLC
C.	MAC, LLC
D.	LLC, MAC
E.	None of the above
Answer» E. None of the above

Discussion

2937.	Two computers that communicate with each other use a simple parity check to detect errors for ASCII transmissions. Which of the following events will always lead to an undeleted error?
A.	one bit or any odd number of bits inverted in a block of data during transmission
B.	two bits or any even number of bits inverted in a block during transmission
C.	one bit or any odd number of bits inverted in a byte during transmission
D.	two bits or any even number of bits inverted in a byte during transmission
E.	None of the above
Answer» E. None of the above

Discussion

2938.	Which utility is an all-purpose tool for troubleshooting TCP/IP problems?
A.	NBTSTAT
B.	Netstat
C.	PING
D.	Hostname
E.	None of the above
Answer» D. Hostname

Discussion

2939.	In communication satellite, multiple repeaters are known as
A.	detector
B.	modulator
C.	stations
D.	transponders
E.	None of the above
Answer» E. None of the above

Discussion

2940.	A _____ DBMS distributes data processing tasks between the workstation and a network server.
A.	Network
B.	Relational
C.	Client Server
D.	Hierarchical
E.	None of the above.
Answer» D. Hierarchical

Discussion

2941.	There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
A.	Data storage system
B.	Database management system (DBMS)
C.	Batch processing system
D.	Data communication package
E.	None of the above
Answer» C. Batch processing system

Discussion

2942.	Information can be transferred between the DBMS and a
A.	spreadsheet program
B.	word processor program
C.	graphics program
D.	All of the above
E.	None of the above
Answer» E. None of the above

Discussion

2943.	Data integrity control
A.	is used to set upper and lower limits on numeric data
B.	requires the use of passwords to prohibit unauthorized access to the file
C.	has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
D.	All of the above
E.	None of the above
Answer» D. All of the above

Discussion

2944.	In SQL, which command is used to select data in rows and column from one or more tables?
A.	CHOOSE
B.	SELECT
C.	LIST
D.	BROWSE
E.	None of the above
Answer» C. LIST

Discussion

2945.	A scheme describes
A.	data elements
B.	records and files
C.	record relationships
D.	All of the above
E.	None of the above
Answer» E. None of the above

Discussion

2946.	A good query system
A.	can accept English language commands
B.	allows non-programmers to access information stored in a database
C.	can be accessed only by data processing professionals
D.	both (a) and (b)
E.	None of the above
Answer» C. can be accessed only by data processing professionals

Discussion

2947.	A computer file can be best described as
A.	a single data item
B.	a general collection of data items
C.	an orderly collection of data items
D.	a random collection of data items
E.	None of the above
Answer» D. a random collection of data items

Discussion

2948.	How many pins on a VGA?
A.	15.
B.	9
C.	25
D.	32
E.	None of the above
Answer» B. 9

Discussion

2949.	What is modified when changing the system start-up boot sequence?
A.	BIOS/CMOS
B.	CONFIG.SYS
C.	autoexec.bat
D.	COMMAND.COM
E.	None of the above
Answer» B. CONFIG.SYS

Discussion

2950.	A devices that links two homogeneous packet-broadcast local networks, is
A.	gateway
B.	repeater
C.	bridge
D.	hub
E.	None of the above
Answer» D. hub

Discussion

Explore topic-wise MCQs in Engineering.

Networks where end user workstations are tied to LAN servers to share resources and application processing.

In OSI network architecture, the dialogue control and token management are responsibilities of

The modify operation is likely to be done after

One data dictionary software package is called

One approach to standardizing storing of data

What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

In SQL, which command(s) is(are) used to change a table's storage characteristics?

In SQL, which of the following is not a data definition language commands?

Database management systems are intended to:

In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?

Goals for the design of the logical schema include

In order to use a DBMS, it is important to understand

In SQL, which command(s) is(are) used to recompile a stored function?

Report generators are used to

Administrate supervision of database activities is the responsibility of the

Which of the following connectivity devices is used to extend a network on a purely mechanical basis?

Which of the following transmission systems provides the highest data rate to an individual device

The IEEE 802 project of the 1980s involved further defining the lower two layers of the OSI model. A number of standards were agreed upon during that time. Which of the following is the standard for Ethernet?

If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

Which transmission mode is used for data communication along telephone lines?

Who invented the modem?

Which of the following communications modes support two-way traffic but in only one direction of a time?

Which of the following TCP/IP internet protocol a diskless machine uses to obtain its IP address from a server?

Eight stations are competing for the use of the shared channel using the modified Adaptive free walk protocol by Gallager. If the stations 7 and 8 are suddenly become ready at once, how many bit slots are needed to resolve the contention?

Communication circuits that transmit data in both directions but not at the same time are operating in

We can receive data either through our television aerial or down our telephone lines and display this data on our television screen. What is the general name given to this process?

ASK, PSK, FSK, and QAM are examples of _____ encoding.

What function does a serial interface perform in data communication?

You need to determine whether IP information has been assigned to your Windows NT. Which utility should you use?

In a synchronous modem, the digital-to-analog converter transmits signal to the

If the client receives an address from a DHCP server, what is the only information available in the Network Properties dialog box?

An internetworking protocol that provides virtual circuit service across multiple X.25 protocol, is

Which of the following TCP/IP protocol is used for transferring files from one machine to another?

IEEE project 802 divides the data link layer into an upper _____ sublayer and a lower _____ sublayer.

Two computers that communicate with each other use a simple parity check to detect errors for ASCII transmissions. Which of the following events will always lead to an undeleted error?

Which utility is an all-purpose tool for troubleshooting TCP/IP problems?

In communication satellite, multiple repeaters are known as

A _____ DBMS distributes data processing tasks between the workstation and a network server.

There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

Information can be transferred between the DBMS and a

Data integrity control

In SQL, which command is used to select data in rows and column from one or more tables?

A scheme describes

A good query system

A computer file can be best described as

How many pins on a VGA?

What is modified when changing the system start-up boot sequence?

A devices that links two homogeneous packet-broadcast local networks, is

IEEE project 802 divides the data link layer into an upper _ sublayer and a lower _ sublayer.