Oracle - Object-Oriented Aspects of PL/SQL MCQ

Oracle – Object-Oriented Aspects of PL/SQL

1 / 25

1. What is the primary purpose of Oracle’s object features in PL/SQL?

Storing binary data

Object-oriented programming

Data encryption

Object-relational mapping

2 / 25

2. What is an Object Type in Oracle?

A user-defined datatype

A database function

A synonym for a table

A collection of tables

3 / 25

3. In Oracle, what is a subtype of an object type?

A specialized version of an object type

An object table

A new table created from an existing table

A synonym for an object type

4 / 25

4. What are methods in Oracle object types primarily used for?

Invoking object type constructors

Defining triggers

Performing operations on objects

Storing data

5 / 25

5. In Oracle Database 11g and later, how can you invoke supertype methods in a subtype?

By using SUPER keyword

By using OVERRIDE keyword

By using INHERIT keyword

By using CALL keyword

6 / 25

6. How do you store and retrieve persistent objects in Oracle?

Using object views

Using PL/SQL collections

Using XML data types

Using external files

7 / 25

7. What is the purpose of an INSTEAD OF trigger in Oracle object views?

To specify default values

To override supertype methods

To enforce referential integrity

To handle exceptions

8 / 25

8. What is the primary difference between object views and object tables in Oracle?

Object views cannot have INSTEAD OF triggers.

Object views store data physically, while object tables store data logically.

Object views cannot be queried.

Object views support methods, while object tables do not.

9 / 25

9. What is used to maintain Oracle object types and object views in the data dictionary?

System tables

Data dictionary views

SQL statements

PL/SQL packages

10 / 25

10. In Oracle, what do privileges control when working with object types and object views?

Query optimization

Data encryption settings

Object creation and modification

Database administration tasks

11 / 25

11. What is the primary benefit of using object types in PL/SQL?

Better code organization

Improved query performance

Enhanced data security

Support for distributed transactions

12 / 25

12. In Oracle, what is the main role of a subtype in relation to a base type?

To create a new table

To define methods

To inherit attributes

To override methods

13 / 25

13. What is the keyword used to override a method from a supertype in a subtype in Oracle?

OVERRIDE_SUPER

INHERIT

SUPER

OVERRIDE

14 / 25

14. What does PL/SQL use to handle object-relational mapping in Oracle?

Object types

Triggers

Views

Object tables

15 / 25

15. In Oracle Database 11g and later, what keyword is used to invoke a method from a supertype in a subtype?

METHOD

SUPER

CALL

INVOKE

16 / 25

16. In Oracle, what are object views primarily used for?

Querying and updating data

Defining triggers

Creating indexes

Storing binary data

17 / 25

17. What is the primary purpose of INHERIT keyword in Oracle object types?

To define attributes

To override methods

To invoke supertype methods

To create subtypes

18 / 25

18. In Oracle, what is the main difference between a base type and a subtype?

Subtypes are used for data encryption.

Base types cannot have methods.

Subtypes inherit attributes and methods from supertypes.

Base types are used for query optimization.

19 / 25

19. What is the primary role of an INSTEAD OF trigger in Oracle object views?

To handle exceptions

To specify default values

To define new methods

To enforce primary key constraints

20 / 25

20. In Oracle, how do you create a new subtype based on an existing object type?

Using the INHERIT keyword

Using the SUPER keyword

Using the CREATE TYPE statement

Using the OVERRIDE keyword

21 / 25

21. What is the primary benefit of using object types in PL/SQL?

Improved query performance

Enhanced data security

Better code organization

Support for distributed transactions

22 / 25

22. In Oracle, what do object views represent?

Collections

Logical views

Physical tables

Procedures

23 / 25

23. What is the primary role of an INSTEAD OF trigger in Oracle object views?

To specify default values

To override methods

To handle exceptions

To enforce referential integrity

24 / 25

24. In Oracle, what is the primary benefit of using object views?

Enhanced data organization

Better query performance

Improved data security

Support for distributed transactions

25 / 25

25. What is the primary role of the SUPER keyword in Oracle object types?

To override methods

To invoke methods from a supertype

To create subtypes

To define attributes

Your score is

0%

Oracle – Object-Oriented Aspects of PL/SQL MCQ