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.

If you know all the possible values that an attribute can have, you can enumerate those values in ODL.

A. 1
B.
Answer» B.
Discussion
2.

An ordered collection of elements of the same type are called sets.

A. 1
B.
Answer» C.
Discussion
3.

In ODL, you specify an operation using parentheses after its name.

A. 1
B.
Answer» B.
Discussion
4.

An attribute's value is always literal.

A. 1
B.
Answer» B.
Discussion
5.

You may specify an object identifier with only one unique tag name.

A. 1
B.
Answer» C.
Discussion
6.

A collection of literals or object types is called a bag.

A. 1
B.
Answer» C.
Discussion
7.

Database objects are almost always transient.

A. 1
B.
Answer» C.
Discussion
8.

An attribute's value is either a literal or an object identifier.

A. 1
B.
Answer» B.
Discussion
9.

Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).

A. 1
B.
C. 1
D.
Answer» B.
Discussion
10.

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

The reserved word enum is used for which of the following?

A. To define a range for an attribute.
B. To define a range for a class.
C. To define a range for a relationship.
D. All of the above.
Answer» B. To define a range for a class.
Discussion
12.

Literals do not have identifiers, and, therefore, cannot be individually referenced like objects.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
13.

The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.

A. 1
B.
Answer» C.
Discussion
14.

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

The ODMG Object Model requires that a relationship be specified in both directions.

A. 1
B.
Answer» B.
Discussion
16.

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

The Object Query Language is which of the following"?

A. Similar to SQL and uses a select-from-where structure
B. Similar to SQL and uses a select-where structure
C. Similar to SQL and uses a from-where structure
D. Not similar to SQL
Answer» B. Similar to SQL and uses a select-where structure
Discussion
18.

The ODMG Object Model supports only unary and binary relationships.

A. 1
B.
Answer» B.
Discussion
19.

An atomic literal is which of the following?

A. Strings
B. Boolean
C. Long
D. All of the above.
Answer» E.
Discussion
20.

Which of the following is an unordered collection of elements that may contain duplicates?

A. Set
B. Bag
C. List
D. Dictionary
Answer» C. List
Discussion
21.

Before specifying a key for a class, you must specify its extent.

A. 1
B.
Answer» B.
Discussion
22.

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

Which of the following is true concerning the following statement: class Manager extends Employee

A. Manager is a concrete class and a superclass.
B. Manager is a concrete class and a subclass.
C. Manager is an abstract class and a superclass.
D. Manager is an abstract class and a subclass.
Answer» C. Manager is an abstract class and a superclass.
Discussion
24.

Using ODL, you can define which of the following?

A. Attribute
B. Structure
C. Operation
D. All of the above.
Answer» E.
Discussion
25.

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

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

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

ODL supports the abstract keyword for classes and operations.

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

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

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