Which statement about the Queryable Patch inventory feature is false?

Which statement about the Queryable Patch inventory feature is false?

Which statement about the Queryable Patch inventory feature is false?

A.
It is used to retrieve installed patch information from a SQL prompt.

B.
It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is
sent to the access drivers.

C.
DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D.
It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances
and DG instances.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Siegfried

Siegfried

D.

Oracle Database 12.1 : FAQ on Queryable Patch Inventory (Doc ID 1530108.1)

It’s a new feature in 12c which can be used to retrieve inventory information from SQL prompt. It has been implemented by using external table with prerprocessor and pl/sql package functions, procedures. It uses PREPROCESSOR feature which allows users to preprocess input data before it is sent to the access drivers.
Queryable Patch Inventory requies Oracle database instance to be open in read/write mode. This would mean that it will not work when the db is mounted (example ASM instance) and db is open in read only mode (a DG instance)

Reply