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.

151.

The data model that is produced from reverse engineering is:
A. a conceptual model.
B. an internal model.
C. a logical model.
D. None of the above is correct.
Answer» E.
Discussion
152.

The object definition language (ODL) is which of the following?
A. Used to develop logical schemas
B. A data definition language for OODB
C. A method to implement a logical schema
D. All of the above.
Answer» E.
Discussion
153.

Which of the following is true concerning an ODBMS?
A. They have the ability to store complex data types on the Web.
B. They are overtaking RDBMS for all applications.
C. They are most useful for traditional, two-dimensional database table applications.
D. All of the above.
Answer» B. They are overtaking RDBMS for all applications.
Discussion
154.

SQL data definition commands make up a(n) ________ .
A. DDL
B. DML
C. HTML
D. XML
Answer» B. DML
Discussion
155.

How can you find rows that do not match some specified condition?
A. EXISTS
B. Double use of NOT EXISTS
C. NOT EXISTS
D. None of the above is correct.
Answer» C. NOT EXISTS
Discussion
156.

A regular subquery can be processed:
A. from the top down.
B. from the bottom up.
C. by nesting.
D. None of the above is correct.
Answer» C. by nesting.
Discussion
157.

To drop a column that is used as a foreign key, first:
A. drop the primary key.
B. drop the table containing the foreign key..
C. drop the foreign key constraint.
D. All of the above must be done.
Answer» D. All of the above must be done.
Discussion
158.

Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
A. Null status
B. Data type
C. Default value
D. Data constraints
Answer» D. Data constraints
Discussion
159.

Which of the following modifications may not succeed?
A. Changing a column data type from char to date
B. Changing a column data type from numeric to char
C. Both of the above actions should succeed.
D. Neither of the above actions will succeed.
Answer» B. Changing a column data type from numeric to char
Discussion
160.

The identifier of an entity will become the ________ of the new table.
A. foreign key
B. main attribute
C. primary key
D. identity key
Answer» D. identity key
Discussion
161.

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
A. primary key.
B. foreign key.
C. composite key.
D. surrogate key.
Answer» E.
Discussion
162.

Which of the following statements is true about symmetric multiprocessing?
A. A single copy of the operating system resides in each processor.
B. Useful for situations where data must remain in memory to process.
C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
D. The problems of memory contention are unlikely.
Answer» C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
Discussion
163.

Which of the following SQL statements are helpful in database redesign?
A. Correlated subqueries only
B. EXISTS/NOT EXISTS expressions only
C. Both of the above are helpful
D. None of the above are helpful.
Answer» D. None of the above are helpful.
Discussion
164.

Which of the following items are not necessary for client/server?
A. Assure that tools will connect with middleware.
B. Understand the requirements.
C. Determine network bandwidth capabilities.
D. Include the use of a file server.
Answer» E.
Discussion
165.

A characteristic of a file server is which of the following?
A. Manages file operations and is shared on a network.
B. Manages file operations and is limited to one PC.
C. Acts as a fat client and is shared on a network.
D. Acts as a fat client and is limited to one PC.
Answer» B. Manages file operations and is limited to one PC.
Discussion
166.

Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
A. advantage
B. disadvantage
C. either an advantage or disadvantage
D. neither an advantage nor disadvantage
Answer» C. either an advantage or disadvantage
Discussion
167.

Eliminating modification anomalies is a(n) ________ of normalization.
A. advantage
B. disadvantage
C. either an advantage or disadvantage
D. neither an advantage nor disadvantage
Answer» B. disadvantage
Discussion
168.

When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
A. first step.
B. second step.
C. third step.
D. fourth step.
Answer» D. fourth step.
Discussion
169.

You can add a row using SQL in a database with which of the following?
A. ADD
B. CREATE
C. INSERT
D. MAKE
Answer» D. MAKE
Discussion
170.

The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER ...
B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
Answer» D. UPDATE FROM CUSTOMER ...
Discussion
171.

The SQL WHERE clause:
A. limits the column data that are returned.
B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.
Answer» C. Both A and B are correct.
Discussion
172.

The wildcard in a WHERE clause is useful when?
A. An exact match is necessary in a SELECT statement.
B. An exact match is not possible in a SELECT statement.
C. An exact match is necessary in a CREATE statement.
D. An exact match is not possible in a CREATE statement.
Answer» C. An exact match is necessary in a CREATE statement.
Discussion
173.

Identify the class name for the following code: ABC123 course();
A. ABC123
B. course
C. course()
D. All of the above.
Answer» B. course
Discussion
174.

Using ODL, you can define which of the following?
A. Attribute
B. Structure
C. Operation
D. All of the above.
Answer» E.
Discussion
175.

The keyword "inverse" is used in which of the following?
A. Class
B. Attribute
C. Relationship
D. All of the above.
Answer» D. All of the above.
Discussion
176.

ODL supports which of the following types of association relationships?
A. Unary
B. Unary and Binary
C. Unary and Binary and Ternary
D. Unary and Binary and Ternary and higher
Answer» C. Unary and Binary and Ternary
Discussion
177.

An extent is which of the following?
A. A keyword that indicates that the subclass inherits from a superclass
B. A keyword that indicates that the superclass inherits from a subclass
C. The set of all instances of a class within a database
D. Only one instance of a class within a database
Answer» D. Only one instance of a class within a database
Discussion
178.

Which SQL-92 standard SQL command can be used to change a table name?
A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. None of the above is correct.
Answer» E.
Discussion
179.

The process of reading a database schema and producing a data model from that schema is known as:
A. data modeling.
B. database design.
C. reverse engineering.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
180.

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
A. Null status
B. Data type
C. Default value
D. Data constraints
Answer» C. Default value
Discussion
181.

A distributed database has which of the following advantages over a centralized database?
A. Software cost
B. Software complexity
C. Slow Response
D. Modular growth
Answer» E.
Discussion
182.

An autonomous homogenous environment is which of the following?
A. The same DBMS is at each node and each DBMS works independently.
B. The same DBMS is at each node and a central DBMS coordinates database access.
C. A different DBMS is at each node and each DBMS works independently.
D. A different DBMS is at each node and a central DBMS coordinates database access.
Answer» B. The same DBMS is at each node and a central DBMS coordinates database access.
Discussion
183.

When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
A. Disjoint with total specialization
B. Disjoint with partial specialization
C. Overlap with total specialization
D. Overlap with partial specialization
Answer» D. Overlap with partial specialization
Discussion
184.

A subtype entity name should be which of the following?
A. A singular noun
B. Specific to the organization
C. Concise
D. All of the above
Answer» E.
Discussion
185.

Use of a supertype/subtype relationship is necessary when which of the following exists?
A. An instance of a subtype participates in a relationship that is unique to that subtype.
B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
C. Attributes apply to all of the instances of an entity type.
D. No attributes apply to any of the instances of an entity type.
Answer» B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
Discussion
186.

Specialization is which of the following processes?
A. Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
C. Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
D. Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
Answer» B. Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
Discussion
187.

A secondary key is which of the following?
A. Nonunique key
B. Primary key
C. Useful for denormalization decisions
D. Determines the tablespace required
Answer» B. Primary key
Discussion
188.

The fastest read/write time and most efficient data storage of any disk array type is:
A. RAID-0.
B. RAID-1.
C. RAID-2.
D. RAID-3.
Answer» B. RAID-1.
Discussion
189.

A rule of thumb for choosing indexes for a relational database includes which of the following?
A. Indexes are more useful on smaller tables.
B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
C. Do not specify a unique index for the primary key of each table.
D. Be careful indexing attributes that have null values.
Answer» E.
Discussion
190.

A multidimensional database model is used most often in which of the following models?
A. Data warehouse
B. Relational
C. Hierarchical
D. Network
Answer» B. Relational
Discussion
191.

The load and index 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» C. A process to upgrade the quality of data after it is moved into a data warehouse
Discussion
192.

The blocking factor is:
A. a group of fields stored in adjacent memory.
B. the number of physical records per page.
C. attributes grouped together by the same primary key.
D. attributes grouped together by the same secondary key.
Answer» C. attributes grouped together by the same primary key.
Discussion
193.

Which of the following improves a query's processing time?
A. Write complex queries.
B. Combine a table with itself.
C. Query one query within another.
D. Use compatible data types.
Answer» E.
Discussion
194.

Which of the following is not one of the three ways to classify an action assertion?
A. Condition
B. Integrity Control
C. Authorization
D. Enabler
Answer» E.
Discussion
195.

Sequential retrieval on a primary key for sequential file storage has which of the following features?
A. Very fast
B. Moderately fast
C. Slow
D. Impractical
Answer» B. Moderately fast
Discussion
196.

Which of the following is an ordered collection of elements of the same type?
A. Set
B. Bag
C. List
D. Dictionary
Answer» D. Dictionary
Discussion
197.

A relationship should be specified how in the ODL?
A. One direction starting with the first class
B. One direction starting with the second class
C. Neither direction.
D. Both directions.
Answer» E.
Discussion
198.

The generic two-level 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» C. Near real-time updates
Discussion
199.

Using OQL, you may do which of the following?
A. Return an entire collection of elements including duplicates.
B. Return a collection of elements without duplicates.
C. Return a specific subset of elements using a given criteria.
D. All of the above.
Answer» E.
Discussion
200.

The SQL keyword BETWEEN is used:
A. for ranges.
B. to limit the columns displayed.
C. as a wildcard.
D. None of the above is correct.
Answer» B. to limit the columns displayed.
Discussion