Question

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?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Answer

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

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

Take the free 1Z0-909 practice test

Other 1Z0-909 practice questions