Imagem de fundo

Considerando que o parâmetro "undo_retention" do ORACLE permite leitura consistente de ...

Considerando que o parâmetro "undo_retention" do ORACLE permite leitura consistente de até 4 horas, qual sintaxe correta para ler os dados históricos de uma tabela chamada "saques" há 10 minutos atrás?


A

SELECT * FROM saques AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' minute).


B

SELECT * FROM saques AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1/6' hour).


C

SELECT * FROM saques AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '600' seconds).


D

SELECT * FROM saques AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' minutes).


E

SELECT * FROM saques AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '0.1666' hour).