Considere o bloco de transação abaixo
BEGIN;
INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date)
VALUES ('Dept 1000', 1000, '987987987', '2025-01-01');
SAVEPOINT savepoint_;
INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date)
VALUES ('Dept 2000', 2000, '987987987', '2025-01-01'),
('Dept 3000', 3000, '333445555', '2025-01-01');
ROLLBACK TO SAVEPOINT savepoint_;
DELETE FROM department
WHERE dnumber ALL (SELECT dnumber
FROM department);
SAVEPOINT savepoint_;
INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date)
VALUES ('Dept 4000', 4000, '123456789', '2025-01-01');
RELEASE SAVEPOINT savepoint_;
COMMIT;
Após a execução, qual(is) tuplas serão inseridas na tabela department ?

Question

Considere o bloco de transação abaixo  
 BEGIN; 
 INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date) 
   VALUES ('Dept 1000', 1000, '987987987', '2025-01-01'); 
 SAVEPOINT savepoint_; 
 INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date) 
   VALUES ('Dept 2000', 2000, '987987987', '2025-01-01'), 
          ('Dept 3000', 3000, '333445555', '2025-01-01'); 
 ROLLBACK TO SAVEPOINT savepoint_; 
 DELETE FROM department 
 WHERE dnumber >ALL (SELECT dnumber 
                     FROM department); 
 SAVEPOINT savepoint_; 
 INSERT INTO department (dname, dnumber, mgr_ssn, mgr_start_date) 
   VALUES ('Dept 4000', 4000, '123456789', '2025-01-01'); 
 RELEASE SAVEPOINT savepoint_; 
 COMMIT; 
 Após a execução, qual(is) tuplas serão inseridas na tabela  department ?

Answer

('Dept 2000', 2000, '987987987', '2025-01-01'); 
 ('Dept 4000', 4000, '123456789', '2025-01-01');

Answer

('Dept 1000', 1000, '987987987', '2025-01-01'); 
 ('Dept 4000', 4000, '123456789', '2025-01-01');

Answer

('Dept 2000', 2000, '987987987', '2025-01-01'); 
 ('Dept 3000', 3000, '333445555', '2025-01-01');

Answer

('Dept 1000', 1000, '987987987', '2025-01-01'); 
 ('Dept 2000', 2000, '987987987', '2025-01-01');

Answer

('Dept 3000', 3000, '333445555', '2025-01-01'); 
 ('Dept 4000', 4000, '123456789', '2025-01-01');

Crowdly

Considere o bloco de transação abaixo BEGIN; INSERT INTO department (dname,...

Want instant access to all verified answers on moodle.utfpr.edu.br?