Oracle Related Exams
1z0-909 Exam

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?
Examine these statements and output:
Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?
Examine this bar graph based on columns from the players table:
Which two statements would generate this bar graph?