Oracle Exam 1Z0-497 Topic 1 Question 93 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 93
Topic #: 1

[All 1Z0-497 Questions]

Which statement about the Queryable Patch inventory feature is false?

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 to the access drivers.

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. Therefore, it works in ASM instances and DG instances.

Show Suggested Answer

Suggested Answer: D

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

by Kanisha at May 23, 2024, 05:35 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Suzi

1 days ago

Option C looks good to me. DBMS_QOPATCH sounds like the way to go for viewing installed patches. At least it's not as cryptic as some of the other database packages.

upvoted 0 times

...

Louis

5 days ago

Haha, this question is so tricky! I bet the developers of this feature had a field day coming up with all these misleading options.

upvoted 0 times

...

27 days ago

I think the false statement is A) It is used to retrieve installed patch information from a SQL prompt.

upvoted 0 times

...