Oracle
1Z0-909 · Question #16
1Z0-909 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-909 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock 1Z0-909 to see the answer
You've previewed enough free 1Z0-909 questions. Unlock 1Z0-909 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.