Oracle Exam 1Z0-909 Topic 8 Question 48 Discussion

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

Question #: 48
Topic #: 8

Examine this statement which executes successfully:

CREATE TABLE 'fshop' ('product' JSON DEFAULT NULL ) ENGINE=InnoDB;

Now, examine a json value contained in the table:

{"name" : "orange", "varieties" : [{"VarietyName":"Clementine", "Origin" : ["PA", "BU"] }, {"VarietyName": "tangerine", "Origin" : ["CH","JP"]>]>

Which will cause documents to be indexed over the 'name' key?

AALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product-
>* S .varieties. VarietyName ' ) VIRTUAL, ADD KEY idx_name (name.) ;

BALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->' S - varieties' ) VIRTUAL, ADD KEY idx_name (name) ;

CALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->' S - name' ) VIRTUAL, ADD KEY idx_name (name) ;

DALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;

EALTER TABLE fshop ADD name VARCHAR(20) AS (JSON_ONQUOTE (product->'S.varieties.VarietyName')), ADD INDEX (name);

Show Suggested Answer

Suggested Answer: B

by Dyan at Sep 19, 2024, 12:32 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Hoa

9 months ago

Okay, let me think this through step-by-step. We need to create a virtual column that extracts the 'name' field from the JSON data, and then add an index on that column. I'm going with option C.

upvoted 0 times

...

9 months ago

Wait, what? This question is making my head spin. JSON in a database? I thought we were supposed to be learning about SQL, not JSON wrangling.

upvoted 0 times

Iesha

9 months ago

D) ALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;

upvoted 0 times

...

Nickolas

9 months ago

C) ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->' S - name' ) VIRTUAL, ADD KEY idx_name (name) ;

upvoted 0 times

...

Winfred

9 months ago

B) ALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->' S - varieties' ) VIRTUAL, ADD KEY idx_name (name) ;

upvoted 0 times

...

Natalie

9 months ago

A) ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->' S - varieties' ) VIRTUAL, ADD KEY idx_name (name) ;

upvoted 0 times

...

Cyril

9 months ago

Hmm, I think option C is the right one. It looks like we need to extract the 'name' field from the JSON data using the correct JSON path syntax.

upvoted 0 times

Naomi

9 months ago

Yeah, we need to use the correct JSON path syntax to extract the 'name' field.

upvoted 0 times

...

Wilburn

9 months ago

I agree, option C seems to be the correct one.

upvoted 0 times

...