Which two SQL statements would create the required table?

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));

Download Printable PDF. VALID exam to help you PASS.

3 thoughts on “Which two SQL statements would create the required table?

  1. 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

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.