Oracle Exam 1Z0-909 Topic 10 Question 26 Discussion

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

Question #: 26
Topic #: 10

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 Joni at Oct 20, 2023, 09:09 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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