Tag: teamwork

True

False

SUM(start_date)

AVG(start_date)

COUNT(start_date)

AVG(start_date, end_date)

MIN(start_date)

MAXIMUM(start_date)

SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

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;

Kiev

Sofia

Amharic

Dutche

Serbian