Questões de Concurso Comentadas para analista de banco de dados

Foram encontradas 1.632 questões

Resolva questões gratuitamente!

Junte-se a mais de 4 milhões de concurseiros!

Q113014 Banco de Dados
Analise a seguinte SQL:

GRANT REFERENCES “ID_CIDADE” ON “CIDADES” TO “SCOTT”;

O objetivo dela é conceder ao usuário SCOTT sobre o campo ID_CIDADE da tabelaCIDADES a permissão de:
Alternativas
Q113013 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.



Robots ____ have the brains to "intelligently and autonomously search ____ objects" _____ their own.
Alternativas
Q113008 Conhecimentos Gerais
Exemplos de materiais semicondutores inorgânicos responsáveis pelo grande desenvolvimento tecnológico atual na área da microeletrônica e na fabricação de microchips são:
Alternativas
Q113006 Conhecimentos Gerais
“Oexecutivo americano KenMusgrave, coloca o pequeno retângulo de acrílico vermelho, um PC de mesa, ao lado de um PC normal, uma trivial caixa de alumínio cinza-chumbo. "Ambos têm as mesmas funcionalidades e capacidade de processamento", afirma diante das duas máquinas. "A diferença é que o modelo novo tem quase um quinto do tamanho do antigo e, portanto, precisa de muito menos material para ser fabricado. Fora isso, consome quase 70% menos energia”.
O computador apresentado por Musgrave é considerado o que há de mais inovador do ponto de vista ambiental. "É o equipamento que melhor traduz o conceito de green IT  (tecnologia da informação verde)", (...) o produto é diferenciado por reduzir o impacto ambiental de variadas formas - namenor quantidade de energia que será consumida durante sua vida útil, na redução demateriais que o compõem e até na embalagem, que é 95%reciclável”.

(Adaptado de http://info.abril.com.br/professional/ti-verde/quero-ser- verde.shtml)

A sustentabilidade é um importante aspecto da relação do homem moderno com o seu ambiente, que, no caso acima, envolve diretamente:

a utilização dematéria prima “verde” emsua fabricação;
Alternativas
Q112905 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

He was very precise about the proper procedure and the material to be used, he said he didn't want anything especial, only the regular, _____ one.
Alternativas
Q112904 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

If this scientific breakthrough is reliable, after years testing it, it _____ lead to the cure of this type of cancer in the future.
Alternativas
Q112902 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

Boeing ____ this week that it ____ successfully ____ a manned airplane powered _____ hydrogen fuel cells.
Alternativas
Q112901 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

Choose the best option.

Dumping your entire music collection _____ your iPod is a simple, one click process. But what about getting your music _____ your iPod?
Alternativas
Q112900 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

The expression in the last line of the first paragraph could be changed by ____ and its meaning would not altered.
Alternativas
Q112899 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

According to the text industrial designers' jobs have becomemore difficult because they…
Alternativas
Q112898 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

The reason given in the third paragraph of the text for the problemwith smaller gadgets is that…
Alternativas
Q112897 Inglês
GadgetDesigners Push the Limits of Size, Safety
By Brian X. Chen, August 28, 2008

Just as small, fast-moving mammals replaced lumbering
dinosaurs, pocketable gadgets are evolving to fill niches that
larger, deskbound computers can't reach. But as they shrink,
these gadgets are faced with problems mammals face, too,
such as efficiently dissipating heat.

The recent example of Apple's first-generation iPod nanos
causing fires in Japan raises the question of whether
increasingly innovative product designs are impinging on
safety. The nano incident illustrates how risk can increase as
devices decrease in size, says Roger Kay, an analyst at
EndpointTechnologies.

"As [gadgets] get smaller, the tradeoffs become more difficult,
the balance becomes more critical and there's less room for
error," Kay said. "I'm not surprised it's happening to the nano
because that's the small one. You're asking it to do a lot in a
very, very small package and that's pushing the envelope.”

There's no question that industrial designers' jobs have
become much more difficult as the industry demands ever
more powerful and smaller gadgets. With paper-thin
subnotebooks, ultrasmall MP3 players, and pinkie finger-
sized Bluetooth headsets becoming increasingly popular, it's
questionable where exactly designers draw the line between
innovation and safety.

The title of the text let us know that there must be a close relation between…
Alternativas
Q112890 Conhecimentos Gerais
O Programa Piloto para a Proteção das Florestas Tropicais do Brasil (PPG7) é uma iniciativa do governo e da sociedade brasileira, em parceria com a comunidade internacional. Tem como finalidade o desenvolvimento de estratégias inovadoras para a proteção e o uso sustentável da Floresta Amazônica e da Mata Atlântica, associadas a melhorias na qualidade de vida das populações locais. (...) Para tanto, foram definidos os seguintes objetivos específicos:

I. demonstrar a viabilidade da harmonização dos objetivos ambientais e econômicos nas florestas tropicais;

II. ajudar a preservar os enormes recursos genéticos de que estas dispõem;

III. reduzir a contribuição das florestas brasileiras na emissão de gás carbônico;

IV. fornecer um exemplo de cooperação entre os países desenvolvidos e em desenvolvimento nas questões ambientais globais.

(Disponível em: http://www.mct.gov.br/index.php/content/view/ 43656.html)

Dentre os objetivos específicos do PPG7, aquele(s) que diretamente favorece(m) a preservação da biodiversidade local é(são) o(s):
Alternativas
Q112889 Conhecimentos Gerais
Veja o gráfico a seguir:

Imagem 005.jpg

Sobre amatriz energética brasileira pode-se afirmar que:
Alternativas
Q58302 Banco de Dados
Na otimização de consultas em sistemas gerenciadores de bancos de dados, podem ser identificadas quatro etapas, listadas a seguir:

I. escolher procedimentos candidatos;

II. gerar planos de consulta e escolher o mais "econômico";

III. converter a consulta para a forma canônica;

IV. converter a consulta para algum formato interno.

A ordem correta para a execução dessas quatro etapas é

Alternativas
Q58301 Banco de Dados
Considere o seguinte comando do MySQL versão 6:

SELECT LOCATE ('mas', 'armazem')

O resultado obtido com esse comando é
Alternativas
Q58300 Banco de Dados
Considerando o MySQL versão 6, assinale a alternativa que contém uma lista de precedência crescente (da precedência mais baixa para a mais alta).
Alternativas
Q58299 Banco de Dados
Considere os seguintes comandos do Microsoft SQL Server 2008:

I. SELECT CAST (8.7627 AS INT)

II. SELECT CONVERT (INT, 8.7627)

O resultado dos comandos I e II são, respectivamente,
Alternativas
Q58298 Banco de Dados
Considere o seguinte comando do Microsoft SQL Server 2000:

EXEC sp_helpdb First

Esse comando tem como resultado a
Alternativas
Q58297 Banco de Dados
Considere o seguinte comando SQL:

INSERT INTO T1
SELECT * FROM T2

Esse comando tem como resultado a inserção
Alternativas
Respostas
1421: C
1422: D
1423: B
1424: E
1425: B
1426: C
1427: C
1428: D
1429: B
1430: B
1431: A
1432: D
1433: C
1434: C
1435: E
1436: A
1437: C
1438: B
1439: D
1440: A