Questões de Tecnologia da Informação · Cebraspe

Tecnologia da InformaçãoOutros temasCebraspe 2018

MP/PI

Questão de Tecnologia da Informação

CREATE TABLE prova (codprocesso integer, descricao varchar(10), codprocessopai integer); INSERT INTO prova VALUES (1, "A", 3); INSERT INTO prova VALUES (2, "B", 1); INSERT INTO prova VALUES (3, "C", null); INSERT INTO prova VALUES (4, "D", 3); SELECT p.descricao, pp.descricao as descricaopai FROM prova p INNER JOIN prova pp on p.codprocesso=pp.codprocessopai WHERE pp.codprocessopai =3; Assertiva: Nessa situação, o resultado da consulta será o que se segue.

Figura da questão (imagem do caderno de prova)

Text 5A7-I 1 When reflecting on the Fourth Industrial Revolution I cannot help but think I’m in one of Isaac Asimov’s novels. In his Foundation series he starts off with a mathematician who 4 develops a branch of mathematics that can predict the future, but only on a large scale. He foresees the imminent fall of the Galactic Empire, which will result in untold suffering and 7 human misery, which could be averted. When talking about the Fourth Industrial Revolution as personified through artificial intelligence, we generally are 10 referring to machine learning, deep learning, robotics, the internet of things. It is the symbiotic relationship between man and machine. 13 First, technology and the advancement of smart technologies are purported to equate to modernity. If the population of a certain country is not using smart technologies 16 then it is left behind. Smartphones, smart freezers, smart cars and so much more. Then there are the labour implications of the 19 revolution. It’s all too easy to say we must prepare for the eventuality of job losses and retrain ourselves to be employable in the digital age. But this is easier said than done. A closer 22 examination of the issue suggests that the only real jobs protected from complete overhaul by machines are creative ones — not only the arts, but also high-level jobs such as CEOs 25 and managers in the financial and corporate worlds. Meaning, to state the obvious, the current elite will have job security while blue-collar workers will be threatened by huge job losses 28 due to machines. Critical questions that must be answered are that one undisputed need for this revolution is a constant supply 31 of electricity, without which we cannot have satellite communication to keep smart devices working, fibre connectivity and so on. Many countries will then be left out of 34 the Fourth Industrial Revolution. Oscar Van Heerden. The rise of the machines: Are we ready to participate in the Fourth Industrial Revolution? In: Daily Maverick News. Internet: <www.dailymaverick.co.za> (adapted). According to text 5A7-I, judge the following items.

The word “undisputed” (R.30) may be replaced by unquestioned, without altering the meaning of the sentence.

Sua resposta

Mais questões de Outros temas

Questão de prova oficial, com o gabarito definitivo publicado pela banca. Reproduzida para fins de estudo.