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

Raul

2 months ago

Wait, so we can use the Queryable Patch feature to check for patches while the database is down? That's like being able to check your refrigerator while you're on vacation. Sounds a bit far-fetched to me.

upvoted 0 times

Elza

26 days ago

C) DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

upvoted 0 times

...

Walker

27 days ago

C) DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

upvoted 0 times

...

Katie

1 months ago

B) It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

upvoted 0 times

...

Emmett

1 months ago

A) It is used to retrieve installed patch information from a SQL prompt.

upvoted 0 times

...

Ezekiel

1 months ago

B) It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

upvoted 0 times

...

Basilia

2 months ago

A) It is used to retrieve installed patch information from a SQL prompt.

upvoted 0 times

...

Suzi

2 months 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

2 months 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

...

Rolland

2 months ago

I'm not sure about the details of the Queryable Patch feature, but option D sounds a bit fishy. I thought it only worked with the database instance in OPEN mode, not just mounted.

upvoted 0 times