Questões de Concurso
Comentadas para analista de banco de dados
Foram encontradas 1.633 questões
Resolva questões gratuitamente!
Junte-se a mais de 4 milhões de concurseiros!
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461190
Banco de Dados
O atributo de uma relação pode armazenar um valor denominado de NULL. Essa palavra reservada, NULL, representa um valor:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461189
Banco de Dados
Seja a relação R constituída de n atributos denominados de A1 , A2, A3 , ..., An. O domínio de um atributo A qualquer uma dessa relação defini-se por dom(A). A indicação do número total de valores, ou cardinalidade, em um domínio de um atributo A qualquer é |dom(A)|, considerando que todos os domínios são finitos. O produto de cardinalidades de todos os domínios, definido da seguinte forma |dom(A1 )| x |dom(A2 )| x |dom(A3 )| ... |dom(An )|, representa:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461188
Banco de Dados
O objetivo principal de um banco de dados é armazenar informações, com segurança, e disponibilizá-las quando houver uma solicitação qualquer. A relação é um objeto criado no banco de dados que mantém as informações armazenadas e possui o conceito que é:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461187
Banco de Dados
O Sistema de banco de dados (SBD) possui várias palavras reservadas com diversas finalidades. A palavra reservada check de um SBD é uma cláusula que significa:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461186
Banco de Dados
Uma transação é uma unidade de execução de programa que acessa e, possivelmente, atualiza vários itens. Há uma propriedade das transações que garante que a execução simultânea de transações resulte em uma situação no sistema equivalente ao estado obtido caso as transações tivessem sido executadas uma de cada vez, independente da ordem em que são executadas. Essa propriedade denomina-se:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461185
Redes de Computadores
Uma empresa vai montar um esquema de uso de IPs privados emsua rede de computadores, como uso de NAT, para convertê-los em IPs válidos para acesso à internet. Um endereço possível para a rede interna, que utilize um endereço privado do TCP/IP e que tambémpode ser usado comomecanismo deNAT, é:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461184
Redes de Computadores
A tecnologia que implementa o padrão IEEE 802.16, utilizada para operação em redes metropolitanas com alcance de até 50 km, com micro-ondas, trabalhando como comunicaçãomultiponto, comtaxa de transferência até 70 Mbps e cujo uso mais comum é o acesso à internet, inclusive com acesso VoIP, é denominada de:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461183
Segurança da Informação
O ataque em que um hacker envia um certificado alterado para um computador cliente, de modo que essa máquina cliente seja induzida a tratar o computador do hacker como o servidor alvo e assim este consegue receber a chave pública acoplada ao certificado, capturando e traduzindo os dados criptografados sem que o cliente perceba, já que o hacker reenvia os dados para o servidor alvo depois de interceptá-los, é denominado de:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461182
Banco de Dados
Um administrador de banco de dados (BD) do MS SQL Server 7.0 precisa utilizar uma ferramenta para enviar, manualmente, comandos Transact-SQL e stored procedures para o mecanismo de BD do servidor e obter uma exibição visual do plano de execução do MS SQL Server. Para isso, ele vai usar o:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461181
Banco de Dados
O comando do SQL ANSI-99 para eliminar a tabela XYde umbanco de dados KZ é o:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461179
Segurança da Informação
Em uma empresa, ao serem efetuados vários testes de penetração a fim de compor um índice para precisar o quanto da rede está aberta a invasões, está sendo analisado um aspecto da análise de risco associado à:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461178
Programação
Uma característica importante da arquitetura do ApacheTomcat 7 é que:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461177
Redes de Computadores
Uma empresa instalou um firewall para controlar o acesso aos serviços HTTP, TFTP e POP3. Nesse caso, esse firewall vai ser configurado para controlar o acesso, respectivamente, às portas tcp/udp de número:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461175
Redes de Computadores
Em uma empresa, necessita-se montar uma estrutura de rede cujas características envolvam técnica de comutação de quadros efetuada de maneira confiável, com um serviço orientado à conexão que operem na Camada Nível 2 do modelo OSI/ISO, com baixo retardo e sem controle de erro nos nós. Essa estrutura que será implementada segundo os critérios do/a:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461173
Engenharia de Software
No domínio da orientação a objetos, a ideia de existência de dados e funcionalidades acessados somente pelos objetos de uma classe, de forma interna, e de que deva existir alguma forma protegida de acesso a esses dados e funcionalidades, demodo que objetos de classes externas os enxerguem, está associada aos conceitos, respectivamente, de:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461171
Sistemas Operacionais
Um sistema operacional, em uma máquina qualquer, faz sua gerência de memória baseada em uma política de substituição de páginas, na qual é selecionada para se carregar na memória a página menos referenciada, como quadromenos usado.
Essa política é identificada pelo acrônimo:
Essa política é identificada pelo acrônimo:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461170
Inglês
Texto associado
Read the text below and answer the questions that follow.
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
According to the text, if the new color TV set does not operate properly, you should:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461169
Inglês
Texto associado
Read the text below and answer the questions that follow.
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
Read these sentences:
1. Please __________ the TV. I want to watch the news.
2. Don’t forget to __________ the TV before you leave the room.
3. __________ the radio, please! It’s too low. I can’t hear the news.
The verbs that complete the sentences correctly are, respectively:
1. Please __________ the TV. I want to watch the news.
2. Don’t forget to __________ the TV before you leave the room.
3. __________ the radio, please! It’s too low. I can’t hear the news.
The verbs that complete the sentences correctly are, respectively:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461168
Inglês
Texto associado
Read the text below and answer the questions that follow.
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
The word HAZARDS in “This can expose you to very high voltage and other hazards”means:
Ano: 2014
Banca:
FUNCAB
Órgão:
PRODAM-AM
Prova:
FUNCAB - 2014 - PRODAM-AM - Analista de Banco de Dados |
Q461167
Inglês
Texto associado
Read the text below and answer the questions that follow.
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
Text:
How to get the most enjoyment from your
color TV set
Your new color TV incorporates a host of features designed to give you excellent performance. Besides, this model utilizes a highly sophisticated control microprocessor that can give you unprecedented convenience and control in the areas of picture adjustment, channel tuning, monitor operation, on-screen information, and remote control.
We therefore strongly urge that you read all of these instructions before using yourTV for the first time.
Installation
Antenna
Unless your TV is connected to a cable TV system, or to a centralized antenna system, a good outdoor color TV antenna is recommended for the best performance. However, if you are located in a strong signal area that is free from interference and ghost conditions (multipath), an indoor antenna may be sufficient. The two pole antenna packedwith this set is for your convenience only. It is not capable of providing you with the sharp detail and rich color that this televisionwas designed to display.
Location
Select an area where sunlight or bright indoor illumination will not fall directly on the picture screen. Also, be sure that the location selected allows a free flow of air to and fromthe perforated back cover of the set.
Note
Never remove the back cover of the set. This can expose you to very high voltage and other hazards.
If the set does not operate properly, unplug it and call your dealer or service shop.
(Fonte: Color Television – Operating Instructions.)
According to the text, the new color TV set should be placed:
Conheça nossos planos