Which two options can you use to list Oracle Database 12c patches by using Queryable Patch
Inventory?
A.
select patch from vSoption where opatch_data=’ 333333′ ;
B.
select xmltransform(dbms_qopatch.get_opatch_data(3333333),
dbms_qopatch.GET_OPATCH_XSLT()) from dual
C.
select opatch from vSpatchsets where opatch_number = ‘333333’;
D.
opatchlsinventory -xml
Explanation:
Reference:http://www.oracle.com/technetwork/pt/articles/sql/queryable-patch-inventory-12c-2098576-ptb.html
BD
Answer : BD
Explanation :
https://www.oracle.com/technetwork/pt/articles/sql/queryable-patch-inventory-12c-2098576-ptb.html
$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.