Questões de Concurso Comentadas para auditor - tecnologia da informação

(sg-1) Intervalo de portas: 5432,Origem: sg-2

(sg-2) Intervalo de portas: 80, Origem: 0.0.0.0/0

(sg-3) Intervalo de portas: 80, Origem: sg-1

 (sg-1) Intervalo de portas: 80, Origem: sg-2

(sg-2) Indiferente

(sg-3) Intervalo de portas: 5432, Origem: sg-1

(sg-1) Indiferente

(sg-2) Intervalo de portas: 80, Origem: sg-1

(sg-3) Intervalo de portas: 5432, Origem: sg-1

(sg-1) Intervalo de portas: 5432, Origem: sg-3

(sg-2) Intervalo de portas: 80, Origem: 0.0.0.0/0

(sg-3) Indiferente

(sg-1) Indiferente

(sg-2) Intervalo de portas: 80, Origem: 0.0.0.0/0

(sg-3) Intervalo de portas: 5432, Origem: sg-1

select s1.name tabela, s2.name coluna,

          s3.name tipo, s2.iscomputed, s2.isnullable

from sysobjects s1, syscolumns s2, systypes s3

where s1.xtype='T'

    and s1.xid=s2.xid and s2.xtype=s3.xtype

    and s2.xusertype=s3.xusertype

order by s1.name, s2.name

select s1.name tabela, s2.name coluna,

        s3.name tipo, s2.iscomputed, s2.isnullable

from systables s1, syscolumns s2, systypes s3

where s1.xcode=s2.xcode and s2.xtype=s3.xtype

     and s2.xusertype=s3.xusertype

order by s1.name, s2.name

select s1.name tabela, s2.name coluna,

         s3.name tipo, s3.iscomputed, s3.isnullable 

from systables s1, syscolumns s2, systypes s3

where s1.tableid=s2.tableid and s2.xtype=s3.xtype

      and s2.xusertype=s3.xusertype

order by s1.name, s2.name

select s1.name tabela, s2.name coluna,

         s3.name tipo, s2.iscomputed, s2.isnullable

from sysobjects s1, syscolumns s2, systypes s3

where s1.xtype='U'

    and s1.id=s2.id and s2.xtype=s3.xtype

    and s2.xusertype=s3.xusertype

order by s1.name, s2.name

select s1.name tabela, s2.name coluna,

             s3.name tipo, s2.iscomputed, s2.isnullable

from systables s1, syscolumns s2, sysobjects s3

where s1.xid=s2.xid and s2.xtype=s3.xtype

     and s2.xusertype=s3.xusertype

order by s1.name, s2.name