Oracle Exam 1Z0-149 Topic 5 Question 42 Discussion

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

Question #: 42
Topic #: 5

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

Aa record declared in an anonymous block

Ba record declared in a procedure

Can associative array indexed by PLS_INTEGER

Da record declared in a package specification

Ea predefined PL/SQL-only data type like BOOLEAN

Fan associative array indexed by VARCHAR2

Show Suggested Answer

Suggested Answer: C, D, F

by Avery at Nov 14, 2024, 05:36 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Artie

4 months ago

But records declared in a package specification can't be used in native dynamic SQL, so I don't think D is correct.

upvoted 0 times

...

Shawn

4 months ago

C, E, and D. Definitely the way to go. Anything else would be a real 'record-scratch' moment.

upvoted 0 times

...

Felicidad

4 months ago

A, B, and E. Easy peasy, lemon squeezy! Or should I say, 'SQL-y'?

upvoted 0 times

...

5 months ago

C, E, and D for sure! Can't go wrong with those options.

upvoted 0 times

Eleonora

3 months ago

Great choices! Those options will definitely work for queries and native dynamic SQL in the server.

upvoted 0 times

...

Tomas

4 months ago

I agree, those are the PL/SQL-only data types that can be used in queries and native dynamic SQL.

upvoted 0 times

...

Stefany

4 months ago

I think C, E, and D are the correct options.

upvoted 0 times

...

Stevie

5 months ago

I disagree, I believe it's B, D, and F.

upvoted 0 times

...

Artie

5 months ago

I think the correct answers are A, C, and E.

upvoted 0 times

...