Examine this statement which executes successfully:CREATE TABLE 'fshop’ ('product' JSON DEFAULT NULL ) ENGINE=InnoDB;Now, examine...

Oracle 1z0-909 Question Answer

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?

ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product-

>* S .varieties. VarietyName ' ) VIRTUAL, ADD KEY idx_name (name.) ;

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

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

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

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

Oracle 1z0-909 Summary

Price: $52.5 ~~$149.99~~