Online Access Free 1z1-909 Practice Test

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 and allows the use of the index by the optimizer.
• B.An error is generated because the index prevents changes to the column.
• C.An error is generated because srid o is an invalid identifier value.
• D.Execution succeeds with a warning.

Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

• A.SELECT 'Car' RLIKE 'Ca?' INTO @r;
• B.SELECT 'Car' LIKE 'Ca?' INTO @r;
• C.SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;
• D.SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

Examine this event's metadata:

Now examine this command:
DROP USER 'userl'e'localhost';
Which effect will the command have on the event?

• A.The event is scheduled and executed but fails. The system will log an error.
• B.The event is not scheduled and will no longer execute. The system will log an error.
• C.The event will be dropped without an error or warning.
• D.The event is scheduled but will no longer execute. The system will log an error.

Which statement is true about the show errors command?

• A.It cannot display information for more than max_errot_count server system variable setting.
• B.It displays similar diagnostics results as get diagnostics.
• C.It displays the total number of errors, warnings, and notes since the server last restarted.
• D.It displays the total number of errors, warnings, and notes since the beginning of the current session.
• E.It displays errors messages only, since the server last restarted.
• F.It displays errors messages only, since the start time of the current session.

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?

• A.The json_extract() function requires a length value that matches the field length in the schema.
• B.The select requires json_unquoteo in the where clause.
• C.The JSON datatype cannot be used in virtual columns.
• D.The virtual values in the name column must be accessed using functions.
• E.Table statistics must be updated to generate values for the name column.