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?
  • 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?
  • 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?
  • 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?
  • 1Z0-909 Exam Question 5

    Examine these statement which execute successfully:

    Now, examine this desired output:

    Which two queries will produce the out?