Which statement about the Queryable Patch inventory feature is false?

Question

Exhibit

Options

• AIt is used to retrieve installed patch information from a SQL prompt.
• BIt uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent
• CDBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.
• DIt works in an Oracle database instance that is mounted.

• A
  13% (6)
• B
  4% (2)
• C
  6% (3)
• D
  77% (36)

Explanation

What is Queryable Patch Inventory? 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. More information of PREPROCESSOR can be found at proc11g_1009.pdf What package(s) are provided for Queryable Patch Inventory ? DBMS_QOPATCH provides a PLSQL/SQL interface to view the database patches installed. The interface provides all the patch information available as part of the 'opatch lsinventory -xml' command. The package accesses the OUI patch inventory in real time to provide patch and patch meta information. Known Issues/Limitations 1. Queryable Patch inventory does not work with datavault-Customer needs to apply the patch 17446849 - For more information on patch refer to Note 17446849.8 2. 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) Queryable Patch Inventory Examples 1. SQL> select xmltransform( dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual; ----------------------------------------------------------------------- Patch Information: 3333333: applied on 2013-01-07T08:53:45+05:30 Created on : 20 Aug 2012, 23:38:02 hrs PST8PDT 2. SQL> select xmltransform( dbms_qopatch.get_opatch_files(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual; ----------------------------------------------------------------------- Patch Id : 3333333 3. SQL>set long 20000 SQL>select dbms_qopatch.get_opatch_files(3333333) from dual; ----------------------------------------------------------------------- instance">3333333</patchID><files instance"><file>prvtstas.plb</file></files></patchFiles>

No community discussion yet for this question.