Explore topic-wise MCQs in Database.

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

1.

The UML notation is useful for graphically depicting an object-oriented analysis or design model.

A. 1
B.
Answer» B.
2.

Each association has two or more roles.

A. 1
B.
Answer» B.
3.

Multiple inheritance allows a class to inherit features from more than one superclass.

A. 1
B.
Answer» B.
4.

An operation that alters the state of an object is known as a constructor operation.

A. 1
B.
Answer» C.
5.

The reasons for overriding include extension, restriction, and optimization.

A. 1
B.
Answer» B.
6.

Composition does not allow an object to be part of more than one aggregate object.

A. 1
B.
Answer» B.
7.

An object's state is determined by its attribute values and links to other objects.

A. 1
B.
Answer» B.
8.

In an object diagram, an object is represented as a rectangle with two compartments.

A. 1
B.
Answer» B.
9.

Which of the following statement is true concerning objects and/or classes?

A. An object is an instance of a class.
B. A class is an instance of an object.
C. An object includes encapsulates only data.
D. A class includes encapsulates only data.
Answer» B. A class is an instance of an object.
10.

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.
11.

Which of the following applies to a class rather than an object?

A. Query
B. Update
C. Scope
D. Constructor
Answer» D. Constructor
12.

An object can have which of the following multiplicities?

A. Zero
B. One
C. More than one
D. All of the above.
Answer» E.
13.

In UML, a class is represented by a rectangle with three compartments separated by vertical lines.

A. 1
B.
Answer» C.
14.

An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.

A. 1
B.
C. 1
D.
Answer» C. 1
15.

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
16.

A constructor operation does which of the following?

A. Creates a new instance of a class
B. Updates an existing instance of a class
C. Deletes and existing instance of a class
D. All of the above.
Answer» B. Updates an existing instance of a class
17.

The term Incomplete 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» E.
18.

A derived element is typically shown by placing either a slash (/) or a stereotype of <> before the name of the element.

A. 1
B.
C. 1
D.
Answer» B.
19.

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.
20.

A solid diamond represents a stronger form of aggregation, known as composition.

A. 1
B.
Answer» B.
21.

A class is a concept, abstraction, or thing that makes sense in an application context.

A. 1
B.
Answer» B.
22.

When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.

A. 1
B.
Answer» B.
23.

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
24.

Multiplicity is the same as what concept for an ERD?

A. Relationship
B. Attribute
C. Entity
D. Cardinality
Answer» E.
25.

Composition is a stronger form of which of the following?

A. Aggregation
B. Encapsulation
C. Inheritance
D. All of the above.
Answer» B. Encapsulation
26.

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.
27.

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.
28.

A method defines the form or protocol of the operation, but not its implementation.

A. 1
B.
C. 1
D.
Answer» C. 1
29.

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.
30.

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