Which two SQL statements would create the required table?

You want to create a table employees in which the values of columns EMPLOYEES_ID and
LOGIN_ID must be unique and not null. Which two SQL statements would create the
required table?

You want to create a table employees in which the values of columns EMPLOYEES_ID and
LOGIN_ID must be unique and not null. Which two SQL statements would create the
required table?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

E.
Option E

F.
Option F

Show Hint

Leave a Reply 6

Your email address will not be published. Required fields are marked *

shape

shape

Option A is definitely correct!
So as answer E.

Reply

donald

donald

Sorry Shape, Option A is NOT correct. Try inserting Employee_id, Login_id as follows:
1, 10, ‘Michelle’, ’23-Feb-16′
1, 11, ‘Donald’, ’14-Feb-16′
It will accept both inserts. Leaving Employee_id non-unique. I suppose one could interpret the question as: Where “together” Employee_id and Login_id are unique. But, I don’t think that is the question. All in all the question is Wrong!

Reply