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.)
A. CREATE TABLE employees (employee_id NUMBER, login_id NUMBER, employee_name VARCHAR2(100), hire_date DATE,
CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id));
B. CREATE TABLE employees (employee_id NUMBER, login_id NUMBER, employee_name VARCHAR2(25), hire_date DATE,
CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));
C. CREATE TABLE employees
(employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY, login_id NUMBER UNIQUE, employee_name VARCHAR2(25), hire_date DATE);
D. CREATE TABLE employees (employee_id NUMBER, login_id NUMBER, employee_name VARCHAR2(100), hire_date DATE,
CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id);
CONSTRAINT emp_id_nn NOT NULL (employee_id, login_id));
E. CREATE TABLE employees
(employee_id NUMBER CONSTRAINT emp_id_nn NOT NULL, login_id NUMBER CONSTRAINT login_id_nn NOT NULL, employee_name VARCHAR2(100), hire_date DATE,
CONSTRAINT emp_num_id_uk UNIQUE (employee_id, login_id));
B,E
is BE bc others are obvious rubbish
Can´t be B, because PRIMARY KEY (employee_id, login_id) allows insert employee_id or login_id duplicate
Can´t be E, because allows insert employee_id or login_id duplicate