SQL Quiz!

[zengatsu]

---

eÂ* would also work. in this case, first_name and last_name would be null.

as for c, simoncpu is right. it would depend on what you are using..

c, e, f

[BadDudes]

for me c and e ...

[maldito_guapito]

a, c, and f? It depends on what you're using, really. Employee_ID has not been declared as NOT NULL. Some database systems allows you to skip entering a value for the primary key as long as it's set to auto-increment or if you've specified a default value (i.e., b). Heck, some even allow you to enclose your values with quotes even if the data type is integer (i.e., c).

:mrgreen:

[ simon.cpu ]

hi simon.cpu, yes ur right your answer is considered. to clarify PRIMARY KEY is by default NOT NULL because it is a required field. in the absence of auto-increment, default value & etc a value is needed to be inserted.

[maldito_guapito]

e would also work. in this case, first_name and last_name would be null.

as for c, simoncpu is right. it would depend on what you are using..

c, e, f

in the absence of other functionalities, c, e &f are correct you got it right.

[maldito_guapito]

for me c and e ...

c & e are correct , you forgot f

[BadDudes]

for me c and e ...

yup hehhehe forgot F also ...

c & e are correct , you forgot f