Questões de Concurso Público MC 2022 para Técnico em Complexidade Gerencial - Cargo 1

Foram encontradas 120 questões

Q1961466 Comunicação Social
À luz da Portaria MCOM n.º 3.525/2021, julgue o item que se segue, referentes ao Ministério das Comunicações.

Em caso de afastamento, o chefe da Assessoria Especial de Assuntos Parlamentares será substituído por servidor previamente indicado por ele e designado na forma da legislação pertinente.
Alternativas
Q1961467 Comunicação Social
À luz da Portaria MCOM n.º 3.525/2021, julgue o item que se segue, referentes ao Ministério das Comunicações.

A Subsecretaria de Orçamento e Administração e a Subsecretaria de Planejamento e Tecnologia da Informação fazem parte da Secretaria-Executiva.
Alternativas
Q1961468 Comunicação Social
À luz da Portaria MCOM n.º 3.525/2021, julgue o item que se segue, referentes ao Ministério das Comunicações. 

Acompanhar e controlar a execução do orçamento é uma competência do secretário-executivo do Ministério das Comunicações.
Alternativas
Q1961642 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below.

According to the text, deepfakes are still far from posing serious concerns in the context of all the advancements in media technology. 
Alternativas
Q1961643 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below.

The expression “pressing challenge” (in the second sentence of the third paragraph) conveys the idea of an insistent demand.  
Alternativas
Q1961644 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below.

It can be concluded from the text that the technology of deepfakes is a problem that must be addressed by different sectors of society. 
Alternativas
Q1961645 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below



In the second paragraph, the word “stakeholders” could be replaced by shareholders without any harm to the comprehension of the sentence. 

Alternativas
Q1961646 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below.

The excerpt “So-called ‘deepfakes’ often present” (in the second sentence of the first paragraph) could be correctly replaced by Known as “deepfakes”, they often present, without changing the meaning of the text.
Alternativas
Q1961647 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below. 

According to the text, one of the outcomes of the spread of deepfakes is a weakened confidence in public institutions.  
Alternativas
Q1961648 Inglês
      Synthetic media technologies are rapidly advancing, making it easier to generate nonveridical media that look and sound increasingly realistic. So-called “deepfakes” often present a person saying or doing something they have not said or done. The proliferation of deepfakes has already created negative consequences such as nonconsensual pornography, political disinformation, and financial fraud. Deepfakes can harm viewers by deceiving or intimidating, harm subjects by causing reputational damage, and harm society by undermining societal values such as trust in institutions.
      It will take the efforts of many different stakeholders including platforms, journalists, and policymakers to counteract the negative effects of deepfakes. Technical experts must marshal their expertise and direct their efforts to find solutions that allow the beneficial uses of synthetic media technologies and mitigate the negative effects. 
      There is no doubt that synthetic media can be used for beneficial purposes, such as in entertainment, historical reenactment, education, and training. The pressing challenge is to reap the positive uses of synthetic media while preventing or at least minimizing the harms. There are numerous opportunities to direct effort in buttressing against some of the worst outcomes. 


Deborah G. Johnson and Nicholas Diakopoulos. Internet: <cacm.acm.org> (adapted). 

Considering the information and the aspects of grammar in the text above, judge the item below. 

The text states that deepfakes could be used to realistically perform past events. 
Alternativas
Q1961649 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte.

Dados estruturados são aqueles representados em um formato estrito como, por exemplo, a informação armazenada nos bancos de dados. 
Alternativas
Q1961650 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte.

A principal característica dos dados não estruturados é que eles não possuem metadados. 
Alternativas
Q1961651 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte.

No banco de dados relacional, é permitido criar uma chave primária utilizando-se dois ou mais campos definidos como chaves estrangeiras.
Alternativas
Q1961652 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte. 

No banco de dados relacional, é permitido criar uma chave primária utilizando-se dois ou mais campos definidos como chaves estrangeiras.  
Alternativas
Q1961653 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte.

A modelagem preditiva é um processo matemático executado automaticamente pelo computador, entretanto ela não cria um modelo inteiro sozinha, pois necessita da intervenção do analista na fase inicial do processo de modelagem. 
Alternativas
Q1961654 Banco de Dados
No que diz respeito aos dados estruturados e não estruturados, aos bancos de dados relacionais, ao modelo de referência CRISP-DM e à modelagem preditiva, julgue o item seguinte.  

No início de um processo de descoberta de conhecimento em bases de dados (KDD), o CRISP-DM recomenda, em relação ao levantamento do hardware existente, que o processo de KDD seja realizado em plataforma com arquitetura não expansível, que forneça suporte e acesso somente à base de dados homogênea. 
Alternativas
Q1961655 Banco de Dados
Julgue o item seguinte, quanto à SQL, às variáveis quantitativas e ao diagrama boxplot. 

Em um diagrama de boxplot, cada caixa representa diversas variáveis a serem analisadas por meio do resumo de quatro números de um conjunto de dados que é composto pelo primeiro quartil, pelo segundo quartil, pelo terceiro quartil e pela mediana. 
Alternativas
Q1961656 Banco de Dados
Julgue o item seguinte, quanto à SQL, às variáveis quantitativas e ao diagrama boxplot. 

O comando a seguir, além de conceder o privilégio de leitura na tabela outorga para o usuário mcom, permite também que o mcom possa conceder esse privilégio para outros usuários.
GRANT SELECT ON outorga TO mcom WITH GRANT OPTION;
Alternativas
Q1961657 Banco de Dados
Julgue o item seguinte, quanto à SQL, às variáveis quantitativas e ao diagrama boxplot.

O comando CREATE TABLE pode ser usado para realizar o backup de uma única tabela, copiando seus dados e suas definições (chaves primárias, estrangeiras, índices, entre outros); por exemplo, o comando a seguir cria o backup da tabela radcom.
CREATE TABLE radcom_bkp AS SELECT * FROM radcom;
Alternativas
Q1961658 Estatística
Julgue o item seguinte, quanto à SQL, às variáveis quantitativas e ao diagrama boxplot.

0 As variáveis quantitativas discretas são aquelas que assumem valores no conjunto dos números naturais, como o número de municípios brasileiros que recebem atualmente a programação de TV em sinal analógico, por exemplo.
Alternativas
Respostas
41: C
42: C
43: E
44: E
45: E
46: C
47: E
48: C
49: C
50: C
51: C
52: E
53: C
54: C
55: E
56: E
57: E
58: C
59: E
60: C