Explore topic-wise MCQs in Engineering.

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

251.

Replication should be used when which of the following exist?
A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
B. When using many nodes with different operating systems and DBMSs and database designs.
C. The application's data can be somewhat out-of-date.
D. All of the above.
Answer» D. All of the above.
Discussion
252.

What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
A. VARCHAR2
B. CHAR
C. LONG
D. NUMBER
Answer» C. LONG
Discussion
253.

Which of the following statements concerning business rules is true?
A. It should be complex.
B. It should not be convertible to computer code.
C. It may include restrictions.
D. All of the above.
Answer» D. All of the above.
Discussion
254.

A supertype/subtype hierarchy has which of the following features?
A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
B. Attributes are assigned at the highest logical level.
C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
D. Attributes are assigned at the lowest logical level.
Answer» C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
Discussion
255.

A star schema has what type of relationship between a dimension and fact table?
A. Many-to-many
B. One-to-one
C. One-to-many
D. All of the above.
Answer» D. All of the above.
Discussion
256.

Transient data is which of the following?
A. Data in which changes to existing records cause the previous version of the records to be eliminated
B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
C. Data that are never altered or deleted once they have been added
D. Data that are never deleted once they have been added
Answer» B. Data in which changes to existing records do not cause the previous version of the records to be eliminated
Discussion
257.

A multifield transformation does which of the following?
A. Converts data from one field into multiple fields
B. Converts data from multiple fields into one field
C. Converts data from multiple fields into multiple fields
D. All of the above
Answer» E.
Discussion
258.

Which of the following are integrity controls that a DBMS may support?
A. Assume a default value in a field unless a user enters a value for that field.
B. Limit the set of permissible values that a field may assume.
C. Limit the use of null values in some fields.
D. All of the above.
Answer» E.
Discussion
259.

Which of the following is not a factor to consider when switching from small to large block size?
A. The length of all of the fields in a table row.
B. The number of columns
C. Block contention
D. Random row access speed
Answer» C. Block contention
Discussion
260.

A transaction manager is which of the following?
A. Maintains a log of transactions
B. Maintains before and after database images
C. Maintains appropriate concurrency control
D. All of the above.
Answer» E.
Discussion
261.

Location transparency allows for which of the following?
A. Users to treat the data as if it is at one location
B. Programmers to treat the data as if it is at one location
C. Managers to treat the data as if it is at one location
D. All of the above.
Answer» E.
Discussion
262.

A heterogeneous distributed database is which of the following?
A. The same DBMS is used at each location and data are not distributed across all nodes.
B. The same DBMS is used at each location and data are distributed across all nodes.
C. A different DBMS is used at each location and data are not distributed across all nodes.
D. A different DBMS is used at each location and data are distributed across all nodes.
Answer» E.
Discussion
263.

Data scrubbing is which of the following?
A. A process to reject data from the data warehouse and to create the necessary indexes
B. A process to load the data in the data warehouse and to create the necessary indexes
C. A process to upgrade the quality of data after it is moved into a data warehouse
D. A process to upgrade the quality of data before it is moved into a data warehouse
Answer» E.
Discussion
264.

The @active data warehouse architecture includes which of the following?
A. At least one data mart
B. Data that can extracted from numerous internal and external sources
C. Near real-time updates
D. All of the above.
Answer» E.
Discussion
265.

A goal of data mining includes which of the following?
A. To explain some observed event or condition
B. To confirm that data exists
C. To analyze data for expected relationships
D. To create a new data warehouse
Answer» B. To confirm that data exists
Discussion
266.

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
A. The multivalue, multicolumn problem
B. The inconsistent values problem
C. The missing values problem
D. The general-purpose remarks column problem
Answer» C. The missing values problem
Discussion
267.

If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Answer» B. All fields are stored in two relations.
Discussion
268.

Which of the following is an advantage of partitioning?
A. Complexity
B. Inconsistent access speed
C. Extra space
D. Security
Answer» E.
Discussion
269.

Selecting a data type involves which of the following?
A. Maximize storage space
B. Represent most values
C. Improve data integrity
D. All of the above.
Answer» D. All of the above.
Discussion
270.

What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
A. VARCHAR2
B. CHAR
C. LONG
D. NUMBER
Answer» B. CHAR
Discussion
271.

If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Answer» C. All fields are stored in three relations.
Discussion
272.

An action assertion must include which of the following?
A. Anchor object
B. Action
C. Corresponding object
D. All of the above.
Answer» E.
Discussion
273.

An oval represents which of the following in an EER?
A. Attribute
B. Entity
C. Optional One
D. Relationship
Answer» B. Entity
Discussion
274.

Inheritance is which of the following?
A. When a supertype entity inherits values of the subtype attribute
B. When a subtype entity inherits values of the supertype attribute
C. When a supertype entity inherits values of another supertype attribute
D. When a subtype entity inherits values of another subtype attribute
Answer» C. When a supertype entity inherits values of another supertype attribute
Discussion
275.

An operational system is which of the following?
A. A system that is used to run the business in real time and is based on historical data.
B. A system that is used to run the business in real time and is based on current data.
C. A system that is used to support decision making and is based on current data.
D. A system that is used to support decision making and is based on historical data.
Answer» C. A system that is used to support decision making and is based on current data.
Discussion
276.

A data warehouse is which of the following?
A. Can be updated by end users.
B. Contains numerous naming conventions and formats.
C. Organized around important subject areas.
D. Contains only current data.
Answer» D. Contains only current data.
Discussion
277.

Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
A. A domain constraint
B. A range constraint
C. An intrarelation constraint
D. An interrelation constraint
Answer» B. A range constraint
Discussion
278.

In a 1:N relationship, the foreign key is placed in:
A. either table without specifying parent and child tables.
B. the parent table.
C. the child table.
D. either the parent table or the child table.
Answer» D. either the parent table or the child table.
Discussion
279.

Which of the following column properties specifies whether or not cells in a column must contain a data value?
A. Null status
B. Data type
C. Default value
D. Data constraints
Answer» B. Data type
Discussion
280.

A primary key should be defined as:
A. NULL.
B. NOT NULL.
C. Either of the above can be used.
D. None of the above are correct.
Answer» C. Either of the above can be used.
Discussion
281.

Database redesign is not terribly difficult if the:
A. database is structured.
B. database is well-designed.
C. database has no data.
D. database is relatively small.
Answer» D. database is relatively small.
Discussion
282.

What type of join is needed when you wish to include rows that do not have matching values?
A. Equi-join
B. Natural join
C. Outer join
D. All of the above.
Answer» D. All of the above.
Discussion
283.

What type of join is needed when you wish to return rows that do have matching values?
A. Equi-join
B. Natural join
C. Outer join
D. All of the above.
Answer» E.
Discussion
284.

When mapping a many-to-many unary relationship into a relation which of the following is true?
A. One relation is created.
B. Two relations are created.
C. Three relations are created.
D. Four relations are created.
Answer» C. Three relations are created.
Discussion
285.

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
Answer» C. Third normal form
Discussion
286.

The fact that the same operation may apply to two or more classes is called what?
A. Inheritance
B. Polymorphism
C. Encapsulation
D. Multiple classification
Answer» C. Encapsulation
Discussion
287.

The object-oriented development life cycle is which of the following?
A. Analysis, design, and implementation steps in the given order and using multiple iterations.
B. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
C. Analysis, design, and implementation steps in any order and using multiple iterations.
D. Analysis, design, and implementation steps in any order and going through the steps no more than one time.
Answer» B. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
Discussion
288.

Multiplicity is the same as what concept for an ERD?
A. Relationship
B. Attribute
C. Entity
D. Cardinality
Answer» E.
Discussion
289.

Poor data administration can lead to which of the following?
A. A single definition of the same data entity
B. Familiarity with existing data
C. Missing data elements
D. All of the above.
Answer» D. All of the above.
Discussion
290.

A binary relationship cannot be which of the following?
A. One-to-One
B. One-to-Many
C. Many-to-Many
D. Zero-to-Zero
Answer» E.
Discussion
291.

A ternary relationship involves how many entities?
A. 3 or less
B. 3
C. More than 3
D. 3 or more
Answer» C. More than 3
Discussion
292.

A rectangle represents which of the following in an ERD?
A. Attribute
B. Entity
C. Optional One
D. Relationship
Answer» C. Optional One
Discussion
293.

The term Complete for a UML has the same meaning as which of the following for an EER diagram?
A. Overlapping rule
B. Disjoint rule
C. Total specialization rule
D. Partial specialization rule
Answer» D. Partial specialization rule
Discussion
294.

A UML diagram includes which of the following?
A. Class name
B. List of attributes
C. List of operations
D. All of the above.
Answer» E.
Discussion
295.

An object can have which of the following multiplicities?
A. Zero
B. One
C. More than one
D. All of the above.
Answer» E.
Discussion
296.

A composite attribute is which of the following?
A. An attribute that can be broken into components
B. An attribute that cannot be broken into components
C. Multiple attributes
D. An identifier
Answer» B. An attribute that cannot be broken into components
Discussion
297.

A relation has which of the following properties?
A. Each row is not unique.
B. Attributes can have the same name within a given table.
C. Each relation has a unique name.
D. The order of the columns is significant.
Answer» D. The order of the columns is significant.
Discussion
298.

Which of the following applies to a class rather than an object?
A. Query
B. Update
C. Scope
D. Constructor
Answer» D. Constructor
Discussion
299.

Relations are:
A. two-dimensional tables.
B. three-dimensional tables.
C. four-dimensional tables.
D. five-dimensional tables.
Answer» B. three-dimensional tables.
Discussion
300.

When mapping a ternary relationship with an associative entity into a relation which of the following is true?
A. One relation is created.
B. Two relations are created.
C. Three relations are created.
D. Four relations are created.
Answer» E.
Discussion