Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?

A)

B)

C)

D)

Show Answer Hide Answer

Which two are true about MySQL connectors?

Show Answer Hide Answer

Examine these statements which execute successfully:

Which two changes will improve this query performance?

Show Answer Hide Answer

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?

Show Answer Hide Answer

You must write a statement that combines the first_name and last_name columns from the

employees table as "last_name, first_name."

Which two statements will do this?

Show Answer Hide Answer