Explore topic-wise MCQs in Engineering.

This section includes 4320 Mcqs, each offering curated multiple-choice questions to sharpen your Engineering knowledge and support exam preparation. Choose a topic below to get started.

1951.

Which of the following is separated by a subnet mask?

A. DHCP scopes
B. Network ID and host ID
C. Domains
D. Subnets
Answer» C. Domains
Discussion
1952.

The signal to noise ratio for a voice grade line is 30.1 dB (decibels) or a power ratio of 1023:1. The maximum achievable data rate on this line whose spectrum ranges from 300 Hz to 4300 Hz is

A. 6200 bps
B. 9600 bps
C. 34000 bps
D. 31000 bps
E. None of the above
Answer» E. None of the above
Discussion
1953.

Many data communication networks have been established which provide a wealth of on-demand information services to people at home. What is the name of the system which provides an interactive, graphics-rich service that permits user to select what they want?

A. Teletex system
B. Fax system
C. Videotex system
D. Microwave system
E. None of the above
Answer» D. Microwave system
Discussion
1954.

What is the number of separate protocol layers at the serial interface gateway specified by the X.25 standard?

A. 4
B. 2
C. 6
D. 3
E. None of the above
Answer» E. None of the above
Discussion
1955.

The slowest transmission speeds are those of

A. twisted-pair wire
B. coaxial cable
C. fiber-optic cable
D. microwaves
E. None of the above
Answer» B. coaxial cable
Discussion
1956.

Distributed Queue Dual Bus is a standard for

A. LAN
B. MAN
C. WAN
D. Wireless LAN.
E. LAN and MAN
Answer» F.
Discussion
1957.

The way a particular application views the data from the data base that the application uses is a :

A. module
B. relational model
C. schema
D. subschema
E. None of the above
Answer» E. None of the above
Discussion
1958.

A compound key

A. is made up a several pieces of information
B. uniquely identifies an item in a list
C. both (a) and (b)
D. is a combination of each unique key
E. None of the above
Answer» D. is a combination of each unique key
Discussion
1959.

The distinguishable parts of a record are called

A. files
B. data
C. fields
D. database
E. None of the above
Answer» D. database
Discussion
1960.

Large collections of files are called

A. fields
B. records
C. databases
D. file system
E. None of the above
Answer» D. file system
Discussion
1961.

The index consists of

A. a list of keys
B. pointers to the master list
C. both (a) and (b)
D. All of the above
E. None of the above
Answer» D. All of the above
Discussion
1962.

The designer of a form includes

A. filed designators
B. prompts
C. data
D. both (a) and (b)
E. None of the above
Answer» E. None of the above
Discussion
1963.

Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

A. report writer
B. query language
C. data manipulation language
D. transaction log
E. None of the above
Answer» E. None of the above
Discussion
1964.

Two files may be joined into a third file if

A. they have a row in common
B. they have a field in common
C. they have no records with the same value in the common field
D. both (b) and (c)
E. None of the above
Answer» C. they have no records with the same value in the common field
Discussion
1965.

Characteristic(s) of a distributed MIS structure is

A. interactive sharing of the workload
B. a multiprocessing environment
C. computers supporting local DP operations
D. All of the above
E. None of the above
Answer» E. None of the above
Discussion
1966.

The data-base environment has all of the following components except:

A. users
B. separate files
C. data base
D. data-base administrator
E. None of the above
Answer» C. data base
Discussion
1967.

A set of programs that handle a firm's data base responsibilities is called a

A. Data Base Management System (DBMS)
B. Data Base Processing System (DBPS)
C. Data Management System (DMS)
D. All of the above
E. None of the above
Answer» E. None of the above
Discussion
1968.

In any hierarchy of data organization, the smallest entity to be processed as a single unit is called

A. data field
B. data record
C. data file
D. database
E. None of the above
Answer» B. data record
Discussion
1969.

The model for a record management system might be

A. handwritten list
B. a Rolodex card file
C. a business form
D. All of the above
E. None of the above
Answer» E. None of the above
Discussion
1970.

Long-range planning report produced in an MIS are primarily designed for

A. top management
B. middle management
C. lower management
D. All of the above
E. None of the above
Answer» B. middle management
Discussion
1971.

In SQL, the CREATE VIEW command is used

A. to recompile view
B. to define a view of one or more tables or views
C. to recompile a table
D. to create a trigger
E. None of the above
Answer» C. to recompile a table
Discussion
1972.

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

A. File structure
B. Records
C. Fields
D. Database
E. None of the above
Answer» D. Database
Discussion
1973.

In SQL, which command is used to create a database user?

A. ADD USER TO DATABASE
B. MK USER
C. CREATE USER
D. All of the above
E. None of the above
Answer» D. All of the above
Discussion
1974.

When performing a look-up operation using a form

A. you enter the search value into the form
B. you look at each form sequentially until you see the one you want
C. you type the key in an entry line, and the correct form is displayed
D. All of the above
E. None of the above
Answer» B. you look at each form sequentially until you see the one you want
Discussion
1975.

A _____ means that one record in a particular record type is related to only one record of another record type.

A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to-many relationship
E. None of the above
Answer» B. One-to-many relationship
Discussion
1976.

A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

A. Network
B. Hierarchical
C. Relational
D. Object-Oriented
E. None of the above
Answer» D. Object-Oriented
Discussion
1977.

If you want your database to include methods, you should use a _____ database.

A. Network
B. Distributed
C. Hierarchical
D. Object-Oriented
E. None of the above
Answer» E. None of the above
Discussion
1978.

In SQL, which command(s) is(are) used to create a synonym for a schema object?

A. CREATE SCHEMA
B. CREATE SYNONYM
C. CREATE SAME
D. All of the above
E. None of the above
Answer» C. CREATE SAME
Discussion
1979.

In SQL, which of the following is not a data Manipulation Language Commands?

A. DELETE
B. SELECT
C. UPDATE
D. CREATE
E. None of the above
Answer» E. None of the above
Discussion
1980.

Which of the following is not characteristic of a relational database model?

A. tables
B. treelike structure
C. complex logical relationships
D. records
E. None of the above
Answer» C. complex logical relationships
Discussion
1981.

A computer file contains several records. What does each record contain?

A. Bytes
B. Words
C. Fields
D. Database
E. None of the above
Answer» D. Database
Discussion
1982.

Which address is the loopback address?

A. 0.0.0.1
B. 127.0.0.0
C. 127.0.0.1
D. 255.255.255.255
E. None of the above
Answer» D. 255.255.255.255
Discussion
1983.

Error rate is

A. an error-detecting code based on a summation operation performed on the bits to be checked.
B. a check bit appended to an array of binary digits to make the sum of all the binary digits.
C. a code in which each expression conforms to specific rules of construction, so that if certain errors occur in an expression, the resulting expression will not conform to the rules of construction and thus the presence of the errors is detected.
D. the ratio of the number of data units in error to the total number of data units
E. None of the above
Answer» E. None of the above
Discussion
1984.

Intranets and extranets can use their network fire walls and other security features to establish secure Internet links within an enterprise or with its trading partners. Select the best fit for answer:

A. Network Server
B. Virtual Private Network
C. Network operating system
D. OSI
Answer» C. Network operating system
Discussion
1985.

A race condition occurs when

A. Two concurrent activities interact to cause a processing error
B. two users of the DBMS are interacting with different files at the same time
C. both (a) and (b)
D. All of the above
E. None of the above
Answer» B. two users of the DBMS are interacting with different files at the same time
Discussion
1986.

In SQL, which command is used to changes data in a table?

A. UPDATE
B. INSERT
C. BROWSE
D. APPEND
E. None of the above
Answer» B. INSERT
Discussion
1987.

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 subschema contains every field in the logical schema
D. All of the above
E. None of the above
Answer» B. each user can access every sub schema
Discussion
1988.

Which network topology is considered passive?

A. Cross
B. Ring
C. Star
D. Mesh
E. Bus
Answer» F.
Discussion
1989.

If a firm wanted to transmit data from 1,000 punched cards to a remote computer, they would use a(n)

A. POS terminal
B. data collection terminal
C. batch processing terminal
D. intelligent terminal
E. None of the above
Answer» D. intelligent terminal
Discussion
1990.

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

A. COMPILE PROCEDURE
B. ALTER PROCEDURE
C. MODIFY PROCEDURE id) All of the above
D. None of the above
Answer» C. MODIFY PROCEDURE id) All of the above
Discussion
1991.

The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

A. forecasting report
B. exception report
C. regularly scheduled report
D. on demand report
E. None of the above
Answer» E. None of the above
Discussion
1992.

The language used in application programs to request data from the DBMS is referred to as the

A. DML
B. DDL
C. query language
D. All of the above
E. None of the above
Answer» B. DDL
Discussion
1993.

An indexing operation

A. sorts a file using a single key
B. sorts file using two keys
C. establishes an index for a file
D. both (b) and (c)
E. None of the above
Answer» D. both (b) and (c)
Discussion
1994.

A _____ means that one record in a particular record type may be related to more than one record of another record type.

A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to many relationship
E. None of the above
Answer» C. Many-to-one relationship
Discussion
1995.

Which command(s) is(are) used to redefine a column of the table in SQL ?

A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above
E. None of the above
Answer» B. DEFINE TABLE
Discussion
1996.

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. All of the above
E. None of the above
Answer» D. All of the above
Discussion
1997.

In SQL, the ALTER TABLESPACE command is used

A. to add/rename data files
B. to change storage characteristics
C. to take a tablespace online/offline
D. to begin/end a backup
E. All of the above
Answer» F.
Discussion
1998.

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

A. ALTER INDEX
B. REDEFINE INDEX
C. MODIFY INDEX
D. DO INDEX
E. None of the above
Answer» B. REDEFINE INDEX
Discussion
1999.

Which of the following is a serious problem of file management systems?

A. difficult to update
B. lack of data independence
C. data redundancy
D. program dependence
E. All of the above
Answer» F.
Discussion
2000.

With respect to data input, the most accurate description of batch control is

A. dividing documents to be entered into batches
B. controlling the input of each input clerk
C. comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
D. All of the above
E. None of the above
Answer» D. All of the above
Discussion