Tag: softskills

CASCADE

UNIQUE

NONUNIQUE

CHECK

PRIMARY KEY

NOT NULL

DROP emp_dept_vu;

DELETE emp_dept_vu;

REMOVE emp_dept_vu;

DROP VIEW emp_dept_vu;

DELETE VIEW emp_dept_vu;

REMOVE VIEW emp_dept_vu;

INSERT

UPDATE

SELECT

DESCRIBE

DELETE

RENAME

COMMIT

MERGE

UPDATE

DELETE

CREATE

DROP

ALTER TABLE students ADD PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY

ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY

DELETE employees;

DESCRIBE employees;

ROLLBACK TO SAVEPOINT C;

GRANT SELECT ON employees TO SCOTT;

ALTER TABLE employeesSET UNUSED COLUMN sal;

SELECT MAX(sal) FROM employees WHERE department_id = 20;

101

73

75

85

• *

• +

• *

• +

g

a

k

h

True

False