Online Access Free 1Z0-909 Practice Test

Examine these statements which execute successfully:

Now, examine this query:

What is the result?

• A.It inserts a row with no error or warning.
• B.It inserts a row with a warning.
• C.It fails with a warning.
• D.It fails with an error.
• E.It inserts a row with an error.

Examine this statement and output:

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

• A.''$.varieties[4]. origin[1]''
• B.product->''$.varieties [4]. origin[1];;
• C.''$.varieties [3]. origin[0]''
• D.product->varieties[3]. origin[0]''

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?

• A.Execution succeeds with a warning.
• B.Execution succeeds and allows the use of the index by the optimizer.
• C.An error is generated because srid o is an invalid identifier value.
• D.An error is generated because the index prevents changes to the column.

Examine these statements which execute successfully:

Which two changes will improve this query performance?

• A.CREATE INDEX 1X7 ON users (user_name) USING HASH;
• B.CREATE INDEX 1X6 ON users (user_name);
• C.CREATE INDEX 1X3 ON locations <loc_site_id) ;
• D.CREATE INDEX IX1 ON locations (loc_shareci) ;
• E.CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH
• F.CREATE INDEX 1X5 ON users (loc_id);
• G.CREATE INDEX 1X4 ON Locations (site_id, loc_shared);

You must reclaim memory used by a prepared statement named prep. Which two achieve this?

• A.SET @prep = NULL;
• B.DROP PROCEDURE prep;
• C.PREPARE prep FROM '';
• D.SET @a = ''; EXECUTE prep USING @a;
• E.DROP PREPARE prep;
• F.DEALLOCATE PREPARE prep?