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.
Explanation:
* New in Oracle 12c is queryable Opatch. Oracle offers a set of tables and a PL/SQL packages to query the
Oracle Inventory.Prior to Oracle 12c, it was not easy to List Oracle patches. Now from Oracle 12c and beyond,
you can use the DBMS_QOPATCH package to list all patches.
* Using DBMS_QOPATCH feature, users can do:
Query what patches are installed from SQL*Plus.
Write wrapper programs to create reports and do validation checks across multiple environments.
Check patches installed on Oracle RAC nodes from a single location instead of having to log onto each one in
turn.