Questões de Concurso Para dataprev

Foram encontradas 2.610 questões

Resolva questões gratuitamente!

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

Q113025 Banco de Dados
Considere a seguinte consulta SQL:

select distinct nome_cliente
from devedor
where nome_cliente in (select nome_cliente
Fromdepositante);

Sobre ela, é correto afirmar que:
Alternativas
Q113024 Banco de Dados
As operações de string em SQL mais usadas são as checagens para verificação de coincidências de pares utilizando o operador LIKE. Acerca disso, é correto afirmar que:
Alternativas
Q113023 Banco de Dados
Um catálogo de informações contém estatísticas armazenadas para estimar o custo de um plano de execução de consulta. São informações relevantes sobre relações armazenadas no catálogo as abaixo transcritas, EXCETO:
Alternativas
Q113022 Banco de Dados
A otimização de consultas pode ser definida como:
Alternativas
Q113021 Banco de Dados
Sobre autorização de acesso a dados, é correto afirmar que a autorização:
Alternativas
Q113020 Banco de Dados
Ainda sobre a SQLe suas divisões, é correto afirmar que:
Alternativas
Q113019 Banco de Dados
A linguagem SQL, desenvolvida pela IBM no início dos anos 70, chamava-se originalmente SEQUEL (Structured EnglishQuery Language), sendo posteriormente chamada de Structured Query Language, ou SQL apenas. Sobre a SQL é correto afirmar que:
Alternativas
Q113018 Banco de Dados
Todo SGBD deve ser capaz de passar no teste ACID. Sobre este teste é correto afirmar que:
Alternativas
Q113017 Banco de Dados
Observe o diagrama abaixo.

Imagem 010.jpg

Com base no conceito de mapeamento de cardinalidade do modelo entidade-relacionamento, pode-se dizer que o diagrama acima apresenta a seguinte cardinalidade:
Alternativas
Q113016 Banco de Dados
Os tipos de atributo que fazem parte do modelo entidade- relacionamento são:
Alternativas
Q113015 Banco de Dados
Em relação ao diagrama entidade-relacionamento, pode- se dizer que:
Alternativas
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
Q113012 Raciocínio Lógico
Todo Almochicroftz é Belchemol. Todo Chicrowitz não é Belchemol, portanto:
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
Q112964 Inglês
Microsoft to Offer Free Virus Protection Software for
Windows

By ScottGilbertsonNovember 19, 2008

Microsoft plans to offer Windows users a new antivirus
package designed to protect the OS from viruses, spyware,
rootkits and trojans. The new software is tentatively code-
named Morro, and will be available for free to Windows XP,
Vista and 7 users sometime in the second half of 2009.
The new software will reportedly use very minimal resources,
which means it should work well with older PCs. If fact,
Microsoft says Morro has been specially designed for older
PCs and low-spec machines popular in developing nations. In
addition to its minimal processor demands, Morro has been
developed to use very little bandwidth,making it ideal for those
without broadband connections.
Morro will replace Microsoft's current, paid service, Windows
Live OneCare, which has been available on a subscription
basis for $50 per year.
While a free, antivirus solution that ships withWindows would
be a boon for the average user, it could also mean trouble for
third-party software solutions. Given that a bundled solution
could raise antitrust concerns -and would no doubt see
competitors likeMcAfee and Grisoft reaching for the lawyers-
Microsoftwill be offeringMorro as a separate download.
Assuming Morro can deliver decent security it should be a
welcome free addition to Windows, but we don't suggest
throwing away your third-party software just yet. Antivirus
software suites will likely continue to hold an edge over Morro
by offering additional handy tools - like passwordmanagers,
identity theft protection and browser-based phishing
protection.
Still, if you've been runningWindowswith no antivirus software
at all,Morrowill no doubt be better than nothing, and it's hard to
arguewith free.

If you don't read carfully this manual you ____ be able to learn how this gizmo works.
Alternativas
Q112963 Inglês
Microsoft to Offer Free Virus Protection Software for
Windows

By ScottGilbertsonNovember 19, 2008

Microsoft plans to offer Windows users a new antivirus
package designed to protect the OS from viruses, spyware,
rootkits and trojans. The new software is tentatively code-
named Morro, and will be available for free to Windows XP,
Vista and 7 users sometime in the second half of 2009.
The new software will reportedly use very minimal resources,
which means it should work well with older PCs. If fact,
Microsoft says Morro has been specially designed for older
PCs and low-spec machines popular in developing nations. In
addition to its minimal processor demands, Morro has been
developed to use very little bandwidth,making it ideal for those
without broadband connections.
Morro will replace Microsoft's current, paid service, Windows
Live OneCare, which has been available on a subscription
basis for $50 per year.
While a free, antivirus solution that ships withWindows would
be a boon for the average user, it could also mean trouble for
third-party software solutions. Given that a bundled solution
could raise antitrust concerns -and would no doubt see
competitors likeMcAfee and Grisoft reaching for the lawyers-
Microsoftwill be offeringMorro as a separate download.
Assuming Morro can deliver decent security it should be a
welcome free addition to Windows, but we don't suggest
throwing away your third-party software just yet. Antivirus
software suites will likely continue to hold an edge over Morro
by offering additional handy tools - like passwordmanagers,
identity theft protection and browser-based phishing
protection.
Still, if you've been runningWindowswith no antivirus software
at all,Morrowill no doubt be better than nothing, and it's hard to
arguewith free.

You ___ not believe that these possibilties are real, they're based ___ experiments that ___proved until now.
Alternativas
Q112962 Inglês
Microsoft to Offer Free Virus Protection Software for
Windows

By ScottGilbertsonNovember 19, 2008

Microsoft plans to offer Windows users a new antivirus
package designed to protect the OS from viruses, spyware,
rootkits and trojans. The new software is tentatively code-
named Morro, and will be available for free to Windows XP,
Vista and 7 users sometime in the second half of 2009.
The new software will reportedly use very minimal resources,
which means it should work well with older PCs. If fact,
Microsoft says Morro has been specially designed for older
PCs and low-spec machines popular in developing nations. In
addition to its minimal processor demands, Morro has been
developed to use very little bandwidth,making it ideal for those
without broadband connections.
Morro will replace Microsoft's current, paid service, Windows
Live OneCare, which has been available on a subscription
basis for $50 per year.
While a free, antivirus solution that ships withWindows would
be a boon for the average user, it could also mean trouble for
third-party software solutions. Given that a bundled solution
could raise antitrust concerns -and would no doubt see
competitors likeMcAfee and Grisoft reaching for the lawyers-
Microsoftwill be offeringMorro as a separate download.
Assuming Morro can deliver decent security it should be a
welcome free addition to Windows, but we don't suggest
throwing away your third-party software just yet. Antivirus
software suites will likely continue to hold an edge over Morro
by offering additional handy tools - like passwordmanagers,
identity theft protection and browser-based phishing
protection.
Still, if you've been runningWindowswith no antivirus software
at all,Morrowill no doubt be better than nothing, and it's hard to
arguewith free.

Choose the best option.

The lights went ___ twice when I was ___ the computer this morning, so I had to stop working ___ the project. Well, that'swhy I'mlate.
Alternativas
Q112957 Inglês
Microsoft to Offer Free Virus Protection Software for
Windows

By ScottGilbertsonNovember 19, 2008

Microsoft plans to offer Windows users a new antivirus
package designed to protect the OS from viruses, spyware,
rootkits and trojans. The new software is tentatively code-
named Morro, and will be available for free to Windows XP,
Vista and 7 users sometime in the second half of 2009.
The new software will reportedly use very minimal resources,
which means it should work well with older PCs. If fact,
Microsoft says Morro has been specially designed for older
PCs and low-spec machines popular in developing nations. In
addition to its minimal processor demands, Morro has been
developed to use very little bandwidth,making it ideal for those
without broadband connections.
Morro will replace Microsoft's current, paid service, Windows
Live OneCare, which has been available on a subscription
basis for $50 per year.
While a free, antivirus solution that ships withWindows would
be a boon for the average user, it could also mean trouble for
third-party software solutions. Given that a bundled solution
could raise antitrust concerns -and would no doubt see
competitors likeMcAfee and Grisoft reaching for the lawyers-
Microsoftwill be offeringMorro as a separate download.
Assuming Morro can deliver decent security it should be a
welcome free addition to Windows, but we don't suggest
throwing away your third-party software just yet. Antivirus
software suites will likely continue to hold an edge over Morro
by offering additional handy tools - like passwordmanagers,
identity theft protection and browser-based phishing
protection.
Still, if you've been runningWindowswith no antivirus software
at all,Morrowill no doubt be better than nothing, and it's hard to
arguewith free.

By being a free product, the new antivirus will certainly bring some trouble such as…
Alternativas
Respostas
2461: A
2462: C
2463: B
2464: D
2465: B
2466: C
2467: A
2468: A
2469: D
2470: E
2471: B
2472: C
2473: D
2474: B
2475: B
2476: E
2477: B
2478: C
2479: E
2480: C