Examine this statement and output:CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ;...

Oracle 1z0-909 Question 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?

An error is generated because srid o is an invalid identifier value.

Execution succeeds with a warning.

An error is generated because the index prevents changes to the column.

Execution succeeds and allows the use of the index by the optimizer.

1z0-909 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"