Magna Concursos

Foram encontradas 70 questões.

3001514 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro
Em um Sistema Gerenciador de Banco de Dados (SGBD) relacional, a gerência de bloqueios é crucial para manter a consistência e a integridade dos dados durante o acesso concorrente por várias transações. Existem diversos níveis e tipos de bloqueio, e eles estão associados ao propósito do bloqueio.
A respeito desses diversos níveis e tipos de bloqueio, constata-se que o
 

Provas

Questão presente nas seguintes provas
3001513 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro
O princípio de independência de dados é um conceito fundamental no modelo relacional de bancos de dados. A aplicação prática deste princípio permite que os bancos de dados sejam gerenciados, otimizados e modificados eficientemente sem a necessidade de realizar modificações extensivas em cada aplicação ou consulta que utiliza o banco de dados, facilitando a manutenção e a evolução dos sistemas.
Na arquitetura de referência ANSI/SPARC, que é composta por três níveis de esquema — externo, conceitual (ou lógico) e interno —, o princípio de independência de dados é expresso por meio da
 

Provas

Questão presente nas seguintes provas
3001512 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro
Gatilhos (triggers) e procedimentos armazenados (stored procedures) são componentes fundamentais em sistemas de gerenciamento de banco de dados (SGBDs) relacionais. Tanto os gatilhos quanto os procedimentos armazenados desempenham papéis vitais e, muitas vezes, complementares em aplicações baseadas em banco de dados relacionais, sendo escolhidos de acordo com as necessidades específicas de uma aplicação ou de um sistema.
A respeito de gatilhos e de procedimentos armazenados, tem-se que
 

Provas

Questão presente nas seguintes provas
3001511 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro

Suponha que o esquema de um banco de dados relacional tenha sido obtido a partir de um modelo E-R em que duas entidades, A e B, estão relacionadas por meio de uma relação R. A regra aplicada para a transformação de R foi a fusão das tabelas correspondentes às entidades A e B, que deu origem à tabela TR. A chave primária da tabela TR é a mesma que foi originalmente definida para a tabela relativa à entidade A.

Qual diagrama define uma relação R compatível com a transformação descrita acima?

 

Provas

Questão presente nas seguintes provas
3001510 Ano: 2023
Disciplina: TI - Desenvolvimento de Sistemas
Banca: CESGRANRIO
Orgão: Transpetro
Estruturas de dados referem-se aos diferentes mecanismos de organização de dados para atender a diferentes requisitos de processamento.
Dentre as estruturas de dados, é eficiente para inserção e remoção de elementos em qualquer posição, incluindo início, meio e fim, além de oferecer acesso aos elementos em posições intermediárias, a seguinte estrutura de dados:
 

Provas

Questão presente nas seguintes provas
3001509 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro
Durante o desenvolvimento de um banco de dados, é possível construir uma representação gráfica de uma estrutura de dados, ilustrando as entidades, seus atributos e os relacionamentos entre elas.
Tal representação gráfica é a(o)
 

Provas

Questão presente nas seguintes provas
3001508 Ano: 2023
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Transpetro
É possível a um sistema de gerenciamento de banco de dados (SGBD) fornecer acesso contínuo aos dados, mesmo em face de falhas de hardware, de software ou de rede.
Essa capacidade é atingida ao implementar-se a seguinte estratégia:
 

Provas

Questão presente nas seguintes provas
How space technology is bringing
green wins for transport
1 Space technology is developing fast, and, with every advance, it is becoming more accessible to industry. Today, satellite communications (satcoms) and space-based data are underpinning new ways of operating that boost both sustainability and profitability. Some projects are still in the planning stages, offering great promise for the future. However, others are already delivering practical results.
2 The benefits of space technology broadly fall into two categories: connectivity that can reach into situations where terrestrial technologies struggle to deliver and the deep, unique insights delivered by Earth Observation (EO) data. Both depend on access to satellite networks, particularly medium earth orbit (MEO) and low earth orbit (LEO) satellites that offer low-latency connectivity and frequently updated data. Right now, the satellite supplier market is booming, driving down the cost of access to satellites. Suppliers are increasingly tailoring their services to emerging customer needs and the potential applications are incredible – as a look at the transportation sector shows.
3 Satellite technology is a critical part of revolutionizing connectivity on trains. The Satellites for Digitalization of Railways (SODOR) project will provide low latency, highly reliable connectivity that, combined with monitoring sensors, will mean near realtime data guides operational decisions. This insight will help trains run more efficiently with fewer delays for passengers. Launching this year, SODOR will help operators reduce emissions by using the network more efficiently, allowing preventative maintenance and extending the lifetime of some existing trains. It will also make rail travel more attractive and help shift more passengers from road to rail (that typically emits even less CO2 per passenger than electric cars do).
4 Satellite data and communications will also play a fundamental role in shaping a sustainable future for road vehicles. Right now, the transport sector contributes around 14% of the UK’s greenhouse gas emissions, of which 91% is from road vehicles – and this needs to change.
5 A future where Electric Vehicles (EV) dominate will need a smart infrastructure to monitor and control the electricity network, managing highly variable supply and demand, as well as a large network of EV charging points. EO data will be critical in future forecasting models for wind and solar production, to help manage a consistent flow of green energy.
6 Satellite communications will also be pivotal. As more wind and solar installations join the electricity network – often in remote locations – satcoms will step in to deliver highly reliable connectivity where 4G struggles to reach. It will underpin a growing network of EV charging points, connecting each point to the internet for operational management purposes, for billing and access app functionality and for the users’ comfort, they may access the system wherever they are.
7 Satellite technology will increasingly be a part of the vehicles themselves, particularly when automated driving becomes more mainstream. It will be essential for every vehicle to have continuous connectivity to support real-time software patches, map updates and inter-vehicle communications. Already, satellites provide regular software updates to vehicles and enhanced safety through an in-car emergency call service.
8 At our company, we have been deeply embedded in the space engineering for more than 40 years – and we continue to be involved with the state-of-the-art technologies and use cases. We have a strong track record of translating these advances into practical benefits for our customers that make sense on both a business and a sustainability level.
Available at: https://www.cgi.com/uk/en-gb/blog/space/how-space-technology-is-bringing-green-wins-to-transport. Retrieved on April 25, 2023. Adapted.
In the eighth paragraph of the text, the author states that, for the last 40 years, the company where he works has been
 

Provas

Questão presente nas seguintes provas
How space technology is bringing
green wins for transport
1 Space technology is developing fast, and, with every advance, it is becoming more accessible to industry. Today, satellite communications (satcoms) and space-based data are underpinning new ways of operating that boost both sustainability and profitability. Some projects are still in the planning stages, offering great promise for the future. However, others are already delivering practical results.
2 The benefits of space technology broadly fall into two categories: connectivity that can reach into situations where terrestrial technologies struggle to deliver and the deep, unique insights delivered by Earth Observation (EO) data. Both depend on access to satellite networks, particularly medium earth orbit (MEO) and low earth orbit (LEO) satellites that offer low-latency connectivity and frequently updated data. Right now, the satellite supplier market is booming, driving down the cost of access to satellites. Suppliers are increasingly tailoring their services to emerging customer needs and the potential applications are incredible – as a look at the transportation sector shows.
3 Satellite technology is a critical part of revolutionizing connectivity on trains. The Satellites for Digitalization of Railways (SODOR) project will provide low latency, highly reliable connectivity that, combined with monitoring sensors, will mean near realtime data guides operational decisions. This insight will help trains run more efficiently with fewer delays for passengers. Launching this year, SODOR will help operators reduce emissions by using the network more efficiently, allowing preventative maintenance and extending the lifetime of some existing trains. It will also make rail travel more attractive and help shift more passengers from road to rail (that typically emits even less CO2 per passenger than electric cars do).
4 Satellite data and communications will also play a fundamental role in shaping a sustainable future for road vehicles. Right now, the transport sector contributes around 14% of the UK’s greenhouse gas emissions, of which 91% is from road vehicles – and this needs to change.
5 A future where Electric Vehicles (EV) dominate will need a smart infrastructure to monitor and control the electricity network, managing highly variable supply and demand, as well as a large network of EV charging points. EO data will be critical in future forecasting models for wind and solar production, to help manage a consistent flow of green energy.
6 Satellite communications will also be pivotal. As more wind and solar installations join the electricity network – often in remote locations – satcoms will step in to deliver highly reliable connectivity where 4G struggles to reach. It will underpin a growing network of EV charging points, connecting each point to the internet for operational management purposes, for billing and access app functionality and for the users’ comfort, they may access the system wherever they are.
7 Satellite technology will increasingly be a part of the vehicles themselves, particularly when automated driving becomes more mainstream. It will be essential for every vehicle to have continuous connectivity to support real-time software patches, map updates and inter-vehicle communications. Already, satellites provide regular software updates to vehicles and enhanced safety through an in-car emergency call service.
8 At our company, we have been deeply embedded in the space engineering for more than 40 years – and we continue to be involved with the state-of-the-art technologies and use cases. We have a strong track record of translating these advances into practical benefits for our customers that make sense on both a business and a sustainability level.
Available at: https://www.cgi.com/uk/en-gb/blog/space/how-space-technology-is-bringing-green-wins-to-transport. Retrieved on April 25, 2023. Adapted.
From the seventh paragraph of the text, one can infer that automated driving will have the benefits of
 

Provas

Questão presente nas seguintes provas
How space technology is bringing
green wins for transport
1 Space technology is developing fast, and, with every advance, it is becoming more accessible to industry. Today, satellite communications (satcoms) and space-based data are underpinning new ways of operating that boost both sustainability and profitability. Some projects are still in the planning stages, offering great promise for the future. However, others are already delivering practical results.
2 The benefits of space technology broadly fall into two categories: connectivity that can reach into situations where terrestrial technologies struggle to deliver and the deep, unique insights delivered by Earth Observation (EO) data. Both depend on access to satellite networks, particularly medium earth orbit (MEO) and low earth orbit (LEO) satellites that offer low-latency connectivity and frequently updated data. Right now, the satellite supplier market is booming, driving down the cost of access to satellites. Suppliers are increasingly tailoring their services to emerging customer needs and the potential applications are incredible – as a look at the transportation sector shows.
3 Satellite technology is a critical part of revolutionizing connectivity on trains. The Satellites for Digitalization of Railways (SODOR) project will provide low latency, highly reliable connectivity that, combined with monitoring sensors, will mean near realtime data guides operational decisions. This insight will help trains run more efficiently with fewer delays for passengers. Launching this year, SODOR will help operators reduce emissions by using the network more efficiently, allowing preventative maintenance and extending the lifetime of some existing trains. It will also make rail travel more attractive and help shift more passengers from road to rail (that typically emits even less CO2 per passenger than electric cars do).
4 Satellite data and communications will also play a fundamental role in shaping a sustainable future for road vehicles. Right now, the transport sector contributes around 14% of the UK’s greenhouse gas emissions, of which 91% is from road vehicles – and this needs to change.
5 A future where Electric Vehicles (EV) dominate will need a smart infrastructure to monitor and control the electricity network, managing highly variable supply and demand, as well as a large network of EV charging points. EO data will be critical in future forecasting models for wind and solar production, to help manage a consistent flow of green energy.
6 Satellite communications will also be pivotal. As more wind and solar installations join the electricity network – often in remote locations – satcoms will step in to deliver highly reliable connectivity where 4G struggles to reach. It will underpin a growing network of EV charging points, connecting each point to the internet for operational management purposes, for billing and access app functionality and for the users’ comfort, they may access the system wherever they are.
7 Satellite technology will increasingly be a part of the vehicles themselves, particularly when automated driving becomes more mainstream. It will be essential for every vehicle to have continuous connectivity to support real-time software patches, map updates and inter-vehicle communications. Already, satellites provide regular software updates to vehicles and enhanced safety through an in-car emergency call service.
8 At our company, we have been deeply embedded in the space engineering for more than 40 years – and we continue to be involved with the state-of-the-art technologies and use cases. We have a strong track record of translating these advances into practical benefits for our customers that make sense on both a business and a sustainability level.
Available at: https://www.cgi.com/uk/en-gb/blog/space/how-space-technology-is-bringing-green-wins-to-transport. Retrieved on April 25, 2023. Adapted.
In the fragment in the sixth paragraph of the text “Satellite communications will also be pivotal”, the word pivotal can be replaced, with no change in meaning, by
 

Provas

Questão presente nas seguintes provas