1Z0-909 Exam Question 1
Examine this statement and output:

You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?

You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?
1Z0-909 Exam Question 2
Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?
1Z0-909 Exam Question 3
Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?
1Z0-909 Exam Question 4
Examine these lines of Python code:

You must add a line of code to complete the code to return data to the variable d. Which line will do this?

You must add a line of code to complete the code to return data to the variable d. Which line will do this?
1Z0-909 Exam Question 5
Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

Now, examine this desired output:

Which two queries will produce the out?