Questão 209269

• Banca: CESPE / CEBRASPE
• Órgão: Banco da Amazônia
• Ano: 2010
• Provas: CESPE - 2010 - Banco da Amazônia - Técnico Científico - Tecnologia da Informação - Administração de Dados
• Disciplina: Banco de Dados
• Assuntos: Oracle

Com relação a Oracle, julgue os itens que se seguem.

O serviço OOG (Oracle open gateways) permite a integração entre bancos Oracle e bancos de outros fabricantes.

• C. Certo
• E. Errado

Gabarito: C

Comentários

• The Oracle Open Gateways (previously called SQL*Connect) is a product that can be used to access data from non-Oracle databases (eg. DB2, Sybase, Informix, etc), and even non-relational data sources like Adabas and file systems.

  Oracle Open Gateways can be divided into 4 categories: Transparent Gateways, Procedural Gateways, Access Managers and Oracle Replication Servers.
   

• Sim. Está correto.
  
  Um pouco mais sobre conexão com o SGBDs Oracle.
  
  Manipulações de dados podem ser feitas por:
  
  • JDBC
  • ODBC
  • OLE DB
  • SQLJ
  • XQuery
  • SQL/XML
  • WebDav
  • ODP.NET
• Oracle Database Gateways
  Oracle Database Gateways address the needs of disparate data access. In a heterogeneously distributed environment, Gateways make it possible to integrate with any number of non-Oracle systems from an Oracle application. They enable integration with data stores such as IBM DB2, Microsoft SQL Server and Excel, transaction managers like IBM CICS and message queuing systems like IBM WebSphere MQ.

• Gabarito Certo

  Oracle Database Gateways address the needs of disparate data access. In a heterogeneously distributed environment, Gateways make it possible to integrate with any number of non-Oracle systems from an Oracle application. They enable integration with data stores such as IBM DB2, Microsoft SQL Server and Excel, transaction managers like IBM CICS and message queuing systems like IBM WebSphere MQ.

   

   

  "Retroceder Nunca Render-se Jamais !"
  Força e Fé !
  Fortuna Audaces Sequitur !