Oracle Exam 1Z0-909 Topic 4 Question 31 Discussion

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

Question #: 31
Topic #: 4

[All 1Z0-909 Questions]

Examine the statement which executes successfully:

SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;

You try to create a table with a storage engine that is not available. What will happen?

AAn error occurs and the create table statement fails.

BThe server will create the table but it will be unusable until the specified storage engine is available.

CThe server will create the table but report an error when the first attempt to insert a row is performed.

DThe server will create the table using the default storage engine.

Show Suggested Answer

Suggested Answer: A

by Kenneth at Feb 12, 2024, 10:16 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Shelba

5 months ago

I think it makes sense for the server to create the table but report an error when the first attempt to insert a row is performed. So, maybe the answer is C).

upvoted 0 times

...

Edmond

6 months ago

I'm unsure about this one. Maybe the answer is B) The server will create the table but it will be unusable until the specified storage engine is available.

upvoted 0 times

...