Oracle
1Z0-071 · Question #157
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table? (Choose two.)
The correct answer is B. CREATE TABLE employees E. CREATE TABLE employees. See the full explanation below for the reasoning.
Question
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table? (Choose two.)
Options
- ACREATE TABLE employees
- BCREATE TABLE employees
- CCREATE TABLE employees
- DCREATE TABLE employees
- ECREATE TABLE employees
How the community answered
(55 responses)- A4% (2)
- B80% (44)
- C7% (4)
- D9% (5)
Community Discussion
No community discussion yet for this question.