1Z0-497 practice question 1 of 25

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

Answer options

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 Correct answer

C: select opatch from vSpatchsets where opatch_number = '333333';

D: opatchlsinventory -xml Correct answer

Correct Answer:

B. select xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual; D. opatchlsinventory -xml

Explanation

Keep practicing

Take the free 1Z0-497 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.