Explore topic-wise MCQs in Database.

This section includes 25 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 Object Query Language is which of the following?

A. imilar to SQL and uses a select-from-where structure
B. imilar to SQL and uses a select-where structure
C. imilar to SQL and uses a from-where structure
D. ot similar to SQL
Answer» B. imilar to SQL and uses a select-where structure
Discussion
2.

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

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

An attribute's value is always literal.%!

A. True
B. False
Answer» B. False
Discussion
4.

The ODMG Object Model supports only unary and binary relationships.%!

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

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

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

Database objects are almost always transient.%!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ODL supports the abstract keyword for classes and operations.%!

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

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

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

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

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

_ Using ODL, you can define which of the following?$?

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

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

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