1z0-909 Exam Dumps : MySQL 8.0 Database Developer

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?

Your session has sqi_mode set to default.

Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?

• std_id = 10301

• firstname = Mary

• lastname = O'Hagen

• birthdate = November 26, 1997

• reg_date = the current date

Examine these statements which execute successfully:

The statements executed without exception. Which two are true?