Which two options can you use to list Oracle Database 12c patches by using Queryable Patch Inventory?

The correct answer is B. select xmltransform(dbms_qopatch.get_opatch_data(3333333), D. opatchlsinventory -xml. $ORACLE_HOME/OPatch/opatch lsinventory -xml SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_LSINVENTORY, DBMS_QOPATCH.GET_OPATCH_XSLT) from dual; SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_BUGS, DBMS_QOPATCH.GET_OPATCH_XSLT) from dual; DBMS_QOPATCH.GET_OPATCH_DATA…

Installation and Configuration

Question

Options

Aselect patch from vSoption where opatch_data=' 333333' ;
Bselect xmltransform(dbms_qopatch.get_opatch_data(3333333),
Cselect opatch from vSpatchsets where opatch_number = '333333';
Dopatchlsinventory -xml

How the community answered

(47 responses)

A
11% (5)
B
85% (40)
C
4% (2)

Explanation

$ORACLE_HOME/OPatch/opatch lsinventory -xml SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_LSINVENTORY, DBMS_QOPATCH.GET_OPATCH_XSLT) from dual; SQL> select xmltransform(DBMS_QOPATCH.GET_OPATCH_BUGS, DBMS_QOPATCH.GET_OPATCH_XSLT) from dual; DBMS_QOPATCH.GET_OPATCH_DATA (patchnum IN VARCHAR2); RETURN XMLTYPE; This function provides top level patch information for the patch (such as Patch ID, patch creation time) in the XML element.

Topics

#OPatch#Queryable Patch Inventory#DBMS_QOPATCH#patch management

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice