Tabulka copyemployees má sloupce: employeeid NUMBER(6) NOT NULL, firstname VARCHAR2(20) NOT NULL, lastname VARCHAR2(20) NOT NULL, email VARCHAR2(30) NOT NULL, phonenumber VARCHAR2(20) NULL, hiredate DATE NOT NULL, jobid VARCHAR2(10) NOT NULL, salary NUMBER(8,2) NOT NULL. Který INSERT správně vloží nového zaměstnance s nevyplněným telefonem?

Question

Answer

INSERT INTO copyemployees VALUES (502, 'Petr', 'Svoboda', 'psvoboda', '123456789', SYSDATE, 'ITPROG', 4200);

Answer

INSERT INTO copyemployees (employeeid, firstname, lastname, phonenumber, hiredate, jobid, salary) VALUES (501, 'Jan', 'Novák', '123456789', SYSDATE, 'ITPROG', 4000);

Answer

INSERT INTO copyemployees (employeeid, firstname, lastname, email, hiredate, jobid, salary) VALUES (503, 'Eva', 'Malá', 'emala', SYSDATE, 'STCLERK', 2500);

Answer

INSERT INTO copyemployees (employeeid, firstname, lastname, email, phonenumber) VALUES (504, 'Karel', 'Velký', 'kvelky', '987654321');

Crowdly

Tabulka copyemployees má sloupce: employeeid NUMBER(6) NOT NULL, firstname VARCH...

Want instant access to all verified answers on student.delta-studenti.cz?