Explore topic-wise MCQs in Database.

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

1.

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

A. True
B. False
Answer» B. False
2.

Each association has two or more roles.%!

A. True
B. False
Answer» B. False
3.

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. True
B. False
Answer» B. False
4.

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

A. True
B. False
Answer» B. False
5.

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

A. True
B. False
Answer» C.
6.

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

A. True
B. False
Answer» B. False
7.

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

A. True
B. False
Answer» B. False
8.

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

A. True
B. False
Answer» B. False
9.

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

A. True
B. False
Answer» C.
10.

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

A. True
B. False
Answer» B. False
11.

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

A. True
B. False
Answer» B. False
12.

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

A. True
B. False
Answer» B. False
13.

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

A. True
B. False
Answer» C.
14.

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

A. True
B. False
Answer» B. False
15.

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

A. True
B. False
Answer» C.
16.

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

*/*_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.
18.

*/*_Which of the following applies to a class rather than an object??

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

*/*_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.
20.

_ 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
21.

_ 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.
22.

_ Composition is a stronger form of which of the following?$?

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

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

An object can have which of the following multiplicities?$?

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

Multiplicity is the same as what concept for an ERD?$?

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

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.