Questões de Concurso Público MF 2024 para Auditor Federal de Finanças e Controle - Área de Tecnologia da Informação (Operação e Infraestrutura) - manhã

select name, type_desc, modify_date

from model.information

where type = 'SYSTEM'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from sys.information

where modify_date

     between '01/01/2024' and '31/01/2024'

select name, type_desc, modify_date

from view.tables

where type = 'USER'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from sys.tables

where type = 'U'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from DICTIONARY

where type = 'SYSTEM'

     and modify_date

         between '01/01/2024' and '31/01/24'