Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a

Question:

Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint, the third column has a CHECK constraint, and the fourth column has a FOREIGN KEY constraint. Given this information, how many indexes does Oracle 11g create automatically when the table and constraints are created? 

a. 0 

b. 1 

c. 2 

d. 3 

e. 4

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 11G SQL

ISBN: 9781133947363

2nd Edition

Authors: Joan Casteel

Question Posted: