Oracle Exam 1Z0-909 Topic 6 Question 20 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 20
Topic #: 6

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?

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

BExecution succeeds with a warning.

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

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

Show Suggested Answer

Suggested Answer: C

by Quentin at May 24, 2023, 09:34 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!