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.

301.

The relational model consists of:

A. data in the form of tables.
B. data redundancy.
C. operations using non-SQL languages.
D. unorganized data.
Answer» B. data redundancy.
302.

When mapping a regular 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» B. Two relations are created.
303.

When mapping a multivalued attribute 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.
304.

If no multivalued attributes 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» B. Second normal form
305.

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

A. Equi-join
B. Natural join
C. Outer join
D. Cartesian join
Answer» E.
306.

Which of the following statements is true concerning subqueries?

A. Involves the use of an inner and outer query.
B. Cannot return the same result as a query that is not a subquery.
C. Does not start with the word SELECT.
D. All of the above.
Answer» B. Cannot return the same result as a query that is not a subquery.
307.

Which of the following is a correlated subquery?

A. Uses the result of an inner query to determine the processing of an outer query.
B. Uses the result of an outer query to determine the processing of an inner query.
C. Uses the result of an inner query to determine the processing of an inner query.
D. Uses the result of an outer query to determine the processing of an outer query.
Answer» C. Uses the result of an inner query to determine the processing of an inner query.
308.

Embedded SQL is which of the following?

A. Hard-coded SQL statements in a program language such as Java.
B. The process of making an application capable of generating specific SQL code on the fly.
C. Hard-coded SQL statements in a procedure.
D. Hard-coded SQL statements in a trigger.
Answer» B. The process of making an application capable of generating specific SQL code on the fly.
309.

A UNION query is which of the following?

A. Combines the output from no more than two queries and must include the same number of columns.
B. Combines the output from no more than two queries and does not include the same number of columns.
C. Combines the output from multiple queries and must include the same number of columns.
D. Combines the output from multiple queries and does not include the same number of columns.
Answer» D. Combines the output from multiple queries and does not include the same number of columns.
310.

Which of the following is one of the basic approaches for joining tables?

A. Subqueries
B. Union Join
C. Natural join
D. All of the above
Answer» E.
311.

Which of the following is true concerning systems information in an RDBMS?

A. RDBMS store database definition information in system-created tables.
B. This information can be accessed using SQL.
C. This information often cannot be updated by a user.
D. All of the above.
Answer» E.
312.

When mapping a binary many-to-many 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» D. Four relations are created.
313.

A primary key is which of the following?

A. Any attribute
B. An attribute that uniquely identifies each row
C. An attribute that uniquely identifies each column
D. A derived attribute
Answer» C. An attribute that uniquely identifies each column
314.

Aggregation is which of the following?

A. Expresses a part-of relationship and is a stronger form of an association relationship.
B. Expresses a part-of relationship and is a weaker form of an association relationship.
C. Expresses an is-a relationship and is a stronger form of an association relationship.
D. Expresses an is-a relationship and is a weaker form of an association relationship.
Answer» B. Expresses a part-of relationship and is a weaker form of an association relationship.
315.

When the minimum and maximum number of instances of an entity is one, you know which of the following?

A. Mandatory one
B. Optional one
C. Mandatory many
D. Cannot tell
Answer» B. Optional one
316.

An attribute name should be which of the following?

A. Singular verb or verb phrase
B. Follow a standard format
C. Use a alias
D. All of the above.
Answer» C. Use a alias
317.

The benefits of object-oriented modeling are which of the following?

A. The ability to tackle more challenging problems
B. Reusability of analysis, design, and programming results
C. Improved communication between users, analysts, etc.
D. All of the above.
Answer» E.
318.

When the minimum number of instances of an entity is one, you know which of the following?

A. Mandatory one
B. Optional one
C. Mandatory many
D. Cannot tell
Answer» E.
319.

Which of the following is a technique for hiding the internal implementation details of an object?

A. Encapsulation
B. Polymorphism
C. Inheritance
D. All of the above.
Answer» B. Polymorphism
320.

A good business rule is which of the following?

A. Declarative
B. Imprecise
C. Redundant
D. Compound
Answer» B. Imprecise
321.

An 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.
322.

An oval represents which of the following in an ERD?

A. Attribute
B. Entity
C. Optional One
D. Relationship
Answer» B. Entity
323.

A binary relationship is which of the following?

A. A relationship between two attributes
B. A relationship between two entities
C. An attribute with two different relationships
D. An entity with two different relationships
Answer» C. An attribute with two different relationships
324.

A data warehouse uses:

A. partial operational data.
B. historical operational data.
C. future operational data.
D. health care data.
Answer» C. future operational data.
325.

A traditional data administrator performs which of the following roles?

A. Tune database performance
B. Establish backup and recovery procedures
C. Resolve data ownership issues
D. Protect the security of the database.
Answer» D. Protect the security of the database.
326.

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

A. Data modeling
B. Database design
C. Metadata
D. All of the above.
Answer» C. Metadata
327.

An intrusion detection system does not perform which of the following?

A. Tries to identify attempts to hack into a computer system.
B. May monitor packets passing over the network.
C. May transmit message packets to the correct destination.
D. Set up deception systems that attempt to trap hackers.
Answer» D. Set up deception systems that attempt to trap hackers.
328.

If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

A. Derived attribute
B. Optional one cardinality
C. Multi-valued attribute
D. Weak entity
Answer» E.
329.

Which of the following is true concerning a procedure?

A. You do not create them with SQL.
B. They do not need to have a unique name.
C. They include procedural and SQL statements.
D. They are the same thing as a function.
Answer» D. They are the same thing as a function.
330.

A CASE SQL statement is which of the following?

A. A way to establish an IF-THEN-ELSE in SQL.
B. A way to establish a loop in SQL.
C. A way to establish a data definition in SQL.
D. All of the above.
Answer» B. A way to establish a loop in SQL.
331.

Which of the following statements is true concerning routines and triggers?

A. Both consist of procedural code.
B. Both have to be called to operate.
C. Both run automatically.
D. Both are stored in the database.
Answer» B. Both have to be called to operate.
332.

An abstract class is which of the following?

A. A class that has direct instances, but whose descendants may have direct instances.
B. A class that has no direct instances, but whose descendants may have direct instances.
C. A class that has direct instances, but whose descendants may not have direct instances.
D. A class that has no direct instances, but whose descendants may not have direct instances
Answer» C. A class that has direct instances, but whose descendants may not have direct instances.
333.

A foreign key is which of the following?

A. Any attribute
B. The same thing as a primary key
C. An attribute that serves as the primary key of another relation
D. An attribute that serves no purpose
Answer» D. An attribute that serves no purpose
334.

A transitive dependency is which of the following?

A. A functional dependency between two or more key attributes.
B. A functional dependency between two or more nonkey attributes.
C. A relation that is in first normal form.
D. A relation that is in second normal form.
Answer» C. A relation that is in first normal form.
335.

Backward recovery is which of the following?

A. Where the before-images are applied to the database
B. Where the after-images are applied to the database
C. Where the after-images and before-images are applied to the database
D. Switching to an existing copy of the database
Answer» B. Where the after-images are applied to the database
336.

ODBC minimum SQL grammar contains which of the following?

A. INSERT, UPDATE, DELETE only
B. Stored Procedures only
C. Literals for date, time and timestamp only
D. CREATE VIEW, DROP VIEW only
Answer» B. Stored Procedures only
337.

A relationship is which of the following?

A. A person, place, or thing
B. Property or characteristic of an entity
C. Link between entities
D. Weak entity
Answer» D. Weak entity
338.

A good identifier is which of the following?

A. One that can change over time
B. Can be null
C. One that is unique
D. Be intelligent
Answer» D. Be intelligent
339.

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

A. Using the Oracle Database Configuration Assistant.
B. Using the Oracle-supplied database creation procedures.
C. Using the SQL CREATE DATABASE command.
D. None of the above is correct.
Answer» B. Using the Oracle-supplied database creation procedures.
340.

What Oracle backup and recover file contains user and system data?

A. Control file
B. Datafile
C. OnLine ReDo file
D. Offline ReDo file
Answer» C. OnLine ReDo file
341.

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

A. are case insensitive.
B. are case sensitive.
C. must always be in lower case.
D. must always be in upper case.
Answer» B. are case sensitive.
342.

Which of the following is not true of SQL views?

A. Oracle views cannot use the ORDER BY clause in view definitions.
B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
C. Oracle views can by queried.
D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Answer» B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
343.

SQL*Plus will finish the statement and execute it when the user types in this:

A. A left slash ( ) followed by [Enter].
B. A colon ( : ) followed by [Enter].
C. A semicolon ( ; ) followed by [Enter].
D. A period ( . ) followed by [Enter].
Answer» D. A period ( . ) followed by [Enter].
344.

In OLE DB, a service provider:

A. does not own data only.
B. transforms data through OLE DB interfaces only.
C. is both a consumer and a provider of data only.
D. All of the above are true of an OLE DB service provider.
Answer» E.
345.

Which of the following is NOT an Oracle-supported trigger?

A. BEFORE
B. DURING
C. AFTER
D. INSTEAD OF
Answer» C. AFTER
346.

In OLE DB, a tabular data provider:

A. does not own data.
B. transforms data through ODE DB interfaces.
C. is both a consumer and a provider of data.
D. exposes data via rowsets.
Answer» E.
347.

The ODBC Level 1 API contains which of the following functions?

A. Browse possible connections and data sources only
B. Connect to data sources with driver-specific information only
C. Process a scrollable cursor only
D. Both 1 and 3 above are in the OBDC Level 1 API.
Answer» C. Process a scrollable cursor only
348.

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

A. Data source
B. Driver
C. Driver manager
D. OLE DB
Answer» D. OLE DB
349.

An Oracle System Change Number (SCN):

A. is a value that is incremented whenever a dirty read occurs.
B. is incremented whenever a deadlock occurs.
C. is a value that keeps track of explicit locks.
D. is a value that is incremented whenever database changes are made.
Answer» E.
350.

Which SQL phrase is not supported by Oracle?

A. ON DELETE CASCADE
B. ON UPDATE CASCADE
C. CREATE SEQUENCE [SequenceName]
D. DROP SEQUENCE [SequenceName]
Answer» C. CREATE SEQUENCE [SequenceName]