Question 1

1CREATE TABLE STUDENTS (SID CHAR(20),
2                       NAME CHAR(30),
3                       LOGIN CHAR(30),
4                       AGE INTEGER,
5                       GPA Numeric(2,1),
6                       UNIQUE (NAME,AGE),
7                       PRIMARY KEY (SID))

Consider the definition of table **STUDENTS**. CREATE TABLE STUDENTS (SID CHAR(20), NAME CHAR(30), LOGIN CHAR(30), AGE INTEGER, GPA Numeric(2,1), UNIQUE (NAME,AGE), PRIMARY KEY (SID)) The sequence of queries is executed on this table. 1. `INSERT INTO STUDENTS VALUES (30000, 'Jones', 'jones@cs', 18, 3.4)` 2. `INSERT INTO STUDENTS VALUES (35670, 'Smith', 'Smith@ee', 18, 7.2)` 3. `INSERT INTO STUDENTS VALUES (56780, 'Jones', 'jones@ece', 28, 10)` Which of the following results in an invalid operation to the table STUDENTS? Figure from the original question paper Figure from the original question paper