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

24 hours 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

6 days ago

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

upvoted 0 times

...

Felicidad

7 days ago

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

upvoted 0 times

...

Kris

8 days ago

Hmm, I'm thinking C, E, and F. Gotta cover all the bases, you know?

upvoted 0 times

...

Frederick

15 days ago

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

upvoted 0 times

...

Stevie

16 days ago

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

upvoted 0 times

...

Artie

22 days ago

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

upvoted 0 times

...