Oracle Exam 1Z0-497 Topic 9 Question 103 Discussion

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

Question #: 103
Topic #: 9

[All 1Z0-497 Questions]

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

Aselect patch from vSoption where opatch_data=' 333333' ;

Bselect xmltransform(dbms_qopatch.get_opatch_data(3333333), dbms_qopatch.GET_OPATCH_XSLT()) from dual

Cselect opatch from vSpatchsets where opatch_number = '333333';

Dopatchlsinventory -xml

Show Suggested Answer

Suggested Answer: B, D

http://www.oracle.com/technetwork/pt/articles/sql/queryable-patch-inventory-12c-2098576-ptb.html

by Gerry at Sep 18, 2024, 01:00 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Isabelle

2 months ago

This is a tough one, but I think I've got it figured out. Options B and D are the way to go. I'm just hoping the exam doesn't ask me to explain the difference between a patch and a patchset. That's where I'd really start sweating!

upvoted 0 times

...

Deandrea

2 months ago

Wow, this question is really testing our Oracle database knowledge! I'm going to go with options B and D, but I'm secretly hoping the answer is 'all of the above' so I can show off my skills.

upvoted 0 times

Tiffiny

14 days ago

Let's hope it's 'all of the above' so we can impress everyone with our Oracle skills!

upvoted 0 times

...

Lizette

17 days ago

I'm not so sure, I think option C might also be a valid answer.

upvoted 0 times

...

Ellsworth

18 days ago

I agree, those seem like the most logical choices.

upvoted 0 times

...

Terrilyn

1 months ago

I think options B and D are the correct ones.

upvoted 0 times

...

Veronique

2 months ago

I'm going with options B and D. The other options seem a bit convoluted, and I don't think they'd be the best way to list the patches.

upvoted 0 times

Gerald

1 months ago

Yeah, I wouldn't go with A either. B and D seem like the way to go.

upvoted 0 times

...

Darell

1 months ago

I think option C could work too, but B and D are probably easier.

upvoted 0 times

...

Ezekiel

1 months ago

I agree, options B and D are the most straightforward.

upvoted 0 times

...

Abraham

2 months ago

Option D looks good to me. It's a simple command to list the patches, and it's the only one that doesn't require any specific package or data transformation.

upvoted 0 times

Ivory

1 months ago

User 3: I agree, it doesn't require any specific package or data transformation.

upvoted 0 times

...

Elfriede

2 months ago

Yeah, it's a simple command to list the patches.

upvoted 0 times

...

Osvaldo

2 months ago

I think option D is the way to go.

upvoted 0 times

...

Latrice

2 months ago

I'm not sure, but I think option A and C could also be used for listing patches.

upvoted 0 times

...

Azalee

2 months ago

I agree with Oretha, option B and D make sense for listing Oracle Database 12c patches.

upvoted 0 times

...

Mabel

2 months ago

I think options B and D are correct. The first one uses the dbms_qopatch package to get the patch data, and the second one uses the opatchlsinventory command to list the patches.

upvoted 0 times