View the Exhibit to examine the PL/SQL block.
Which two statements are true about the execution of the PL/SQL block? (Choose two.)
A.
It executes successfully and gives the desired output.
B.
It does not execute because the definition of type population is indexed by varchar2.
C.
It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
D.
It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
Choose two.
A and C
C is the best answer
“Choose two” !
I agree with…OldBoyOdeSu
Yeah… Answer is A and C
A and C
A and C are correct.
Howdy, i read your blog from time to time and i own a similar one and i was just wondering if you get a lot of spam feedback? If so how do you stop it, any plugin or anything you can suggest? I get so much lately it’s driving me mad so any help is very much appreciated.
A and C are correct..
Go for A & C
If asked For Best ans then C
A,C
After reading your blog post I browsed your website a bit and noticed you arenot ranking nearly as well in Google as you could be. I possess a handful of blogs myself and I think you should take a look here: http://seoreportingtools.com You will find its a very nice tool that can bring you a lot more visitors. Keep up the quality posts.
Go away idiot
A and C are correct
Associate array is stored in sorted order of indexes
Some possible testing points
(1) nested table: sparse collection, nestedTable.delete(onePosition) is allowed
(2) varrary: dense collection. vArray.delete(onePosition) is not allowed, only vArray.delete and vArray.trim are allowed
(3) associative array is stored with the sorted key order, the fashion to sort is determined by initialization parameter NLS_SORT/COMP
D,C
https://docs.oracle.com/cloud/latest/db112/LNPLS/composites.htm#LNPLS99969
first of all we can’t chose two answers.
A is wrong because when you test the code it gives just three cities.. it doesn’t repeat the same name of ‘Smallville’..if you change one of them it gives four cities.
so this code is right but doesn’t gives the desired out put.
A is correct. As per the link you provided and the definition of Associative Array…
An associative array (also called an index-by table) is a set of key-value pairs. Each key is unique, and is used to locate the corresponding value. The key can be either an integer or a string.
Using a key-value pair for the first time adds that pair to the associative array. Using the same key with a different value changes the value.
— so in the sample above, you just change the value of ‘Smallville’ but it will still display 3 cities. Therefore, the desired output was achieved.
look at Example 5-1 Declaring and Using an Associative Array
in
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/collections.htm#CHDEIDIC
{
I believe what you posted was actually very logical. However, what about this? what if you were to create a awesome post title? I mean, I don’t wish to tell you how to run your website, but suppose you added a post title that grabbed a person’s attention? I mean %BLOG_TITLE% is kinda vanilla. You ought to look at Yahoo’s home page and see how they create post titles to grab people interested. You might add a related video or a pic or two to get people excited about what you’ve written. In my opinion, it would make your posts a little bit more interesting.|