PL/SQL Object Types - PL/SQL (MCQ) questions and answers

1)   When implementing methods using PL/SQL, you cannot call a base or supertype object method with the super keyword or an equivalent method in a derived object.
- Published on 07 Jul 15

a. True
b. False
Answer  Explanation 

ANSWER: True

Explanation:
No explanation is available for this question!


2)   The comparison methods are used for comparing objects. How many ways are available for comparing objects?
- Published on 07 Jul 15

a. 4
b. 1
c. 2
d. 5
Answer  Explanation 

ANSWER: 2

Explanation:
There are 2 methods used for comparing objects they are
Map Method - It is a function implemented in such a way that its values depends depends upon the value of the attributes
Order Method - It implements some internal logic for comparing two objects.


3)   Which methods implement some internal logic for comparing two objects? For example, a rectangle is bigger than another rectangle if both its sides are bigger.
- Published on 07 Jul 15

a. Order method
b. Map method
c. Both A & B
d. None of the above
Answer  Explanation 

ANSWER: Order method

Explanation:
ORDER method is the member method to order variables of an object type. The values of two objects are compared based on the criteria that we specify.


4)   An object type can represent any real-world entity.
- Published on 03 Jul 15

a. Yes
b. No
Answer  Explanation 

ANSWER: Yes

Explanation:
No explanation is available for this question!


5)   Constructors are functions that return a new object as its value.
- Published on 03 Jul 15

a. True
b. False
Answer  Explanation 

ANSWER: True

Explanation:
A constructor has the same name as the object name. Constructor method defined by the system is applicable to each and every object.


1