Foram encontradas 1.899 questões.
Script I
CREATE TABLE tbCliente (
CodCliente int(11) NOT NULL,
NomCliente varchar(70) NOT NULL,
DataNascimento date NULL,
TelCliente varchar(40) NULL,
TipCliente smallint(6) NOT NULL,
PRIMARY KEY (CodCliente) );
Script II
INSERT INTO tbCliente (CodCliente, NomCliente,
DataNascimento, TelCliente, TipCliente) VALUES
(1, ‘Ana Paula’, ‘1982-10-01’, ‘1234-5678’, 2),
(2, ‘Cristiane’, ‘1976-11-29’, ‘2233-4545’, 1);
Script III
CREATE VIEW vwCliente AS
SELECT NomCliente, CodCliente FROM tbCliente
WHERE TipCliente = 1;
Tendo como referência os scripts SQL para MySqL acima demonstrados, julgue o item a seguir, acerca de banco de dados e SQL.
A execução do script abaixo retornará apenas um registro.
SELECT * FROM vwcliente WHERE NomCliente LIKE ‘%a%’;
Provas
Questão presente nas seguintes provas
Script I
CREATE TABLE tbCliente (
CodCliente int(11) NOT NULL,
NomCliente varchar(70) NOT NULL,
DataNascimento date NULL,
TelCliente varchar(40) NULL,
TipCliente smallint(6) NOT NULL,
PRIMARY KEY (CodCliente) );
Script II
INSERT INTO tbCliente (CodCliente, NomCliente,
DataNascimento, TelCliente, TipCliente) VALUES
(1, ‘Ana Paula’, ‘1982-10-01’, ‘1234-5678’, 2),
(2, ‘Cristiane’, ‘1976-11-29’, ‘2233-4545’, 1);
Script III
CREATE VIEW vwCliente AS
SELECT NomCliente, CodCliente FROM tbCliente
WHERE TipCliente = 1;
Tendo como referência os scripts SQL para MySqL acima demonstrados, julgue o item a seguir, acerca de banco de dados e SQL.
Os scripts I, II e III são, respectivamente, do tipo DDL, DML e DVL.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
In accordance with the Law (May, 2009), government agencies are supposed to provide information about their income from taxes and expenditure.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
In Brazil, information technology-based public services are increasing steadily.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
Information technology assures economic growth.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
The expression “these needs” refers to “improving theservices provided to citizens and streamlining internal procedures”.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
In the text, “over the years” is synonymous with “through decades”.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
The Brazilian tax return system is entirely Internet-based.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
The number of people casting their votes in 2008 election added up to less than twice over 50 millions.
Provas
Questão presente nas seguintes provas
This text refer to item.
Information technology plays a major part in all productive sectors in Brazil, and there is an increasing awareness of its essential role in helping the country achieve economic growth for the economy. Brazil can justifiably claim to be a global strategic player in the IT-BPO industry.
Brazilian companies in the sector have created a very thriving industry over the years. They have acquired know-how through decades of experience, they have innovated and, as result, excelled in various business and government areas, and they have grown in step with increased domestic demand.
Information technology-based public services are on the rise in Brazil. Best practices are being promoted throughout the most diverse areas — health, education, public safety, and finance, amongst others and in the three spheres of the government, namely, the federal, state and municipal ones. Communications within society are increasingly done via computers. A law enacted in May 2009, for example, requires that government agencies report all their revenues and spending on the Internet, consolidating a practice that had already been adopted by some agencies.
At the end of 2007, IDC carried out a survey among 156 companies in the government sector to identify IT investment trends for the following years. The main challenges for all spheres are the extension and improvement of their existing infrastructure. The government’s priorities also include improving the services provided to citizens and streamlining internal procedures. The implementation of ERP systems can answer these needs directly, offering more integration, efficiency in processes, cost reduction and increased transparency in operations. In response to this demand, several IT-BPO companies operating in Brazil are offering ERPs with management modules developed for the public sector.
Some Brazilian e-government case studies have proven to be remarkable international successes. Electronic ballot boxes were first used in the municipal elections of 1996. In the most recent municipal elections, held in 2008, in which mayors and city councilors were elected, electronic ballot boxes were available to the entire electorate. The numbers involved are impressive and show how complex the operation was in terms of information technology: 5,563 cities, 371,874 electoral sections, and over 110 million voters. Almost all the votes were counted before midnight on the same day of the election.
Another example that adds to Brazil’s credibility in this area is its tax return system, which is almost exclusively Internet-based.
It is also worth highlighting the Brazilian Federal Government’s Electronic Procurement System (Compras Net), regarded by the Inter American Development Bank (IADB) as a source for reference in the procurement of goods and standard services for public administration, as it provides secure information.
Internet: <www.brasscom.org.br> (adapted).
Taking into consideration the text, judge the following item.
Electronic voting began to be used in the late 1990’s.
Provas
Questão presente nas seguintes provas
Cadernos
Caderno Container