Questões de Concurso Público Câmara Legislativa do Distrito Federal 2018 para Analista de Sistemas - Área 1
Foram encontradas 60 questões
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010288
Legislação Estadual
A Lei Complementar nº 13, de 3 de setembro de 1996, que disciplina a redação, alteração e consolidação das leis no Distrito Federal, dispõe, a respeito da estruturação das leis, que
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010289
Legislação Estadual
Nos termos da Lei Orgânica do Distrito Federal, constitui matéria que pode ser objeto de lei ordinária
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010290
Regimento Interno
O Regimento Interno da Câmara Legislativa do Distrito Federal dispõe, a respeito das proposições no processo legislativo, que:
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010291
História e Geografia de Estados e Municípios
Na crise hídrica enfrentada pelo Distrito Federal em 2017, Planaltina e Sobradinho sofreram interrupção no fornecimento de
água por alguns dias. A área foi considerada a mais crítica nos períodos de estiagem, pelo presidente da Companhia de
Saneamento do Distrito Federal, porque
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010292
História e Geografia de Estados e Municípios
O bioma Cerrado, característico da região do Distrito Federal, ocupa, em relação à área total do Brasil, cerca de
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010293
Inglês
Texto associado
Legislative Management and Information System
In May 2001, the Sangguniang Panlalawigan (SP − Provincial Council in English) under the leadership of Vice-Governor
Loreto Leo S. Ocampos embarked on the computerization of its legislative function through the acquisition of the “Legislative
Management and Tracking System”. The “Legislative Management and Tracking System” or “Legtrack” as it is commonly called,
is a software program developed as a tool to track, monitor and store communications, requests, proposed resolutions and ordinances,
communications, Sangguniang Bayan Resolutions and ordinances from different municipalities and cities to be acted upon.
The Provincial Government only spent sixty-six thousand pesos (P 66,000.00) for the cost of installation, airfare and accommodation of two Philippine Business for Social Progress (PBSP) consultants and the training of five SP personnel on its operation and application. Now, over a million worth of software program was given to the Sangguniang Panlalawigan for free.
The SP’s “Legtrack” can be considered as one of the most updated versions of the Tracking System used by different Local Government Units in the country. It also holds the distinction of being the first “Legtrack” to be synced to a Paperless Legislation Program.
The actual performance of the Sangguniang Panlalawigan and its individual members can also be gauged through statistics on session attendance; committee meeting attendance; committee reports made, number of resolutions and ordinances authored, sponsored and passed.
Furthermore, the System upgrade(s) enhances not only the intellectual capability of the Secretariat but also its technical competence in support to the Sanggunian’s Office vows to be responsive, active and sensitive to the needs of the people. It has undergone a total of seven upgrades over the years.
(Adapted from http://sp.misocc.gov.ph/legislative-management-and-information-system)
Segundo o texto, o Legtrack
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010294
Inglês
Texto associado
Legislative Management and Information System
In May 2001, the Sangguniang Panlalawigan (SP − Provincial Council in English) under the leadership of Vice-Governor
Loreto Leo S. Ocampos embarked on the computerization of its legislative function through the acquisition of the “Legislative
Management and Tracking System”. The “Legislative Management and Tracking System” or “Legtrack” as it is commonly called,
is a software program developed as a tool to track, monitor and store communications, requests, proposed resolutions and ordinances,
communications, Sangguniang Bayan Resolutions and ordinances from different municipalities and cities to be acted upon.
The Provincial Government only spent sixty-six thousand pesos (P 66,000.00) for the cost of installation, airfare and accommodation of two Philippine Business for Social Progress (PBSP) consultants and the training of five SP personnel on its operation and application. Now, over a million worth of software program was given to the Sangguniang Panlalawigan for free.
The SP’s “Legtrack” can be considered as one of the most updated versions of the Tracking System used by different Local Government Units in the country. It also holds the distinction of being the first “Legtrack” to be synced to a Paperless Legislation Program.
The actual performance of the Sangguniang Panlalawigan and its individual members can also be gauged through statistics on session attendance; committee meeting attendance; committee reports made, number of resolutions and ordinances authored, sponsored and passed.
Furthermore, the System upgrade(s) enhances not only the intellectual capability of the Secretariat but also its technical competence in support to the Sanggunian’s Office vows to be responsive, active and sensitive to the needs of the people. It has undergone a total of seven upgrades over the years.
(Adapted from http://sp.misocc.gov.ph/legislative-management-and-information-system)
De acordo com o texto, o Legtrack
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010295
Inglês
Texto associado
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
Reno, Nevada, Improves Efficiency while Complying with Stringent Open Meeting Law Requirements
ADAMANT ABOUT TRANSPARENCY
The Reno City Council meets regularly to set priorities, approve the budget and address issues facing the community. These meetings
are guided by incredibly stringent open meeting law requirements. Staff must post the agenda, along with all supporting materials, on
their website at least three days prior to a meeting. Additionally, if any documents are presented during a Council meeting to help make
a decision, it must be uploaded within 24 hours after the meeting.
As a Senior Management Analyst, Jaime Schroeder has been responsible for all staff reports, supporting materials and the agendas for
the Reno City Council and the Reno Redevelopment Agency Board since early 2012. Back then, the agency was using a government
shareware product. “We realized we had quickly outgrown that system,” recalls Jaime.
The City’s communications and technology departments conducted a thorough search of alternatives and narrowed the list down to
three contenders. “We looked at Accela Legislative Management and realized it was the full package,” says Jaime. “It was something
we felt we could implement and get comfortable with quickly.”
HOW ACCELA EMPOWERS RENO
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
City Council meetings are on average four to six hours long. In the past, citizens had to fast forward and rewind through an entire
meeting online in order to find what they were looking for. “The great thing about this product and why we chose it is that the video of
each meeting is integrated with the meeting documents and it also has time-stamp features, making it easy for staff and citizens to
quickly find what they’re interested in. I love that transparency.”
THE BOTTOM LINE
Once a document is posted online, staff and citizens alike can access it through a meeting portal 24/7. When citizens request a Council
or staff report, employees can simply direct them to the portal, where they can click on the meeting date, see the agenda and then click
on the item that interests them. When the media requests information, the Communications department can send links to staff reports
online, saving time, paper and money and helping to ensure accurate media coverage.
In the future, the City of Reno is looking forward to using the electronic voting feature available within Accela Digital Boardroom that
shows meeting participants’ votes on a screen during the meeting in real time.
(Adapted from https://www.accela.com/company/customers/sucess-stories/reno)
De acordo com o texto
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010296
Inglês
Texto associado
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
Reno, Nevada, Improves Efficiency while Complying with Stringent Open Meeting Law Requirements
ADAMANT ABOUT TRANSPARENCY
The Reno City Council meets regularly to set priorities, approve the budget and address issues facing the community. These meetings
are guided by incredibly stringent open meeting law requirements. Staff must post the agenda, along with all supporting materials, on
their website at least three days prior to a meeting. Additionally, if any documents are presented during a Council meeting to help make
a decision, it must be uploaded within 24 hours after the meeting.
As a Senior Management Analyst, Jaime Schroeder has been responsible for all staff reports, supporting materials and the agendas for
the Reno City Council and the Reno Redevelopment Agency Board since early 2012. Back then, the agency was using a government
shareware product. “We realized we had quickly outgrown that system,” recalls Jaime.
The City’s communications and technology departments conducted a thorough search of alternatives and narrowed the list down to
three contenders. “We looked at Accela Legislative Management and realized it was the full package,” says Jaime. “It was something
we felt we could implement and get comfortable with quickly.”
HOW ACCELA EMPOWERS RENO
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
City Council meetings are on average four to six hours long. In the past, citizens had to fast forward and rewind through an entire
meeting online in order to find what they were looking for. “The great thing about this product and why we chose it is that the video of
each meeting is integrated with the meeting documents and it also has time-stamp features, making it easy for staff and citizens to
quickly find what they’re interested in. I love that transparency.”
THE BOTTOM LINE
Once a document is posted online, staff and citizens alike can access it through a meeting portal 24/7. When citizens request a Council
or staff report, employees can simply direct them to the portal, where they can click on the meeting date, see the agenda and then click
on the item that interests them. When the media requests information, the Communications department can send links to staff reports
online, saving time, paper and money and helping to ensure accurate media coverage.
In the future, the City of Reno is looking forward to using the electronic voting feature available within Accela Digital Boardroom that
shows meeting participants’ votes on a screen during the meeting in real time.
(Adapted from https://www.accela.com/company/customers/sucess-stories/reno)
Segundo o texto,
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010297
Inglês
Texto associado
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
Reno, Nevada, Improves Efficiency while Complying with Stringent Open Meeting Law Requirements
ADAMANT ABOUT TRANSPARENCY
The Reno City Council meets regularly to set priorities, approve the budget and address issues facing the community. These meetings
are guided by incredibly stringent open meeting law requirements. Staff must post the agenda, along with all supporting materials, on
their website at least three days prior to a meeting. Additionally, if any documents are presented during a Council meeting to help make
a decision, it must be uploaded within 24 hours after the meeting.
As a Senior Management Analyst, Jaime Schroeder has been responsible for all staff reports, supporting materials and the agendas for
the Reno City Council and the Reno Redevelopment Agency Board since early 2012. Back then, the agency was using a government
shareware product. “We realized we had quickly outgrown that system,” recalls Jaime.
The City’s communications and technology departments conducted a thorough search of alternatives and narrowed the list down to
three contenders. “We looked at Accela Legislative Management and realized it was the full package,” says Jaime. “It was something
we felt we could implement and get comfortable with quickly.”
HOW ACCELA EMPOWERS RENO
One of the things Jaime appreciates about Accela is that “they believe in their product so much, you don’t have to sign on for a year. With Accela, we didn’t feel they were trying to get the most money they could from the agency. We felt they truly were a company that wanted to work with us and were understanding of all the different requirements we had.”
City Council meetings are on average four to six hours long. In the past, citizens had to fast forward and rewind through an entire
meeting online in order to find what they were looking for. “The great thing about this product and why we chose it is that the video of
each meeting is integrated with the meeting documents and it also has time-stamp features, making it easy for staff and citizens to
quickly find what they’re interested in. I love that transparency.”
THE BOTTOM LINE
Once a document is posted online, staff and citizens alike can access it through a meeting portal 24/7. When citizens request a Council
or staff report, employees can simply direct them to the portal, where they can click on the meeting date, see the agenda and then click
on the item that interests them. When the media requests information, the Communications department can send links to staff reports
online, saving time, paper and money and helping to ensure accurate media coverage.
In the future, the City of Reno is looking forward to using the electronic voting feature available within Accela Digital Boardroom that
shows meeting participants’ votes on a screen during the meeting in real time.
(Adapted from https://www.accela.com/company/customers/sucess-stories/reno)
De acordo com o texto
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010298
Arquitetura de Software
Considere que um Analista de Sistemas da Câmara Legislativa do Distrito Federal está iniciando a criação de um diagrama com base no Zachman Framework for Enterprise Architecture, buscando estruturar a arquitetura corporativa da Câmara. A figura abaixo mostra o diagrama parcial criado.
Na figura,
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010299
Modelagem de Processos de Negócio (BPM)
Considere que uma Analista de Sistemas está trabalhando na Modelagem de Processos de Negócio relativos à Câmara
Legislativa. Inicialmente a Analista estudou o funcionamento da técnica I, que refere-se aos esforços cíclicos e repetitivos de
improvements, geralmente incrementais, visando garantir que os processos de negócio da Câmara sejam realizados da maneira
mais eficiente possível. Em seguida elaborou o II, ou seja, o modelo futuro de processos de negócio. Para cada processo da
modelagem sendo realizado, buscou identificar os III, que são pontos do processo onde o trabalho ou a informação passa de
uma função para outra e pode resultar em desconexões de processos. Além disso, buscou também identificar os IV, que são
restrições de capacidade que criam uma fila e cujos fatores que podem contribuir para sua formação incluem pessoas, sistemas,
infraestrutura e fatores organizacionais.
Na descrição da modelagem realizada pela Analista, I, II, III e IV são, correta e respectivamente,
Na descrição da modelagem realizada pela Analista, I, II, III e IV são, correta e respectivamente,
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010300
Banco de Dados
Texto associado
Atenção: Considere as informações abaixo para responder as questões de números 33 e 34.
A Mesa Diretora da Câmara Legislativa é responsável pela direção dos trabalhos legislativos e dos serviços administrativos da
Casa. Compõe-se de presidente, vice-presidente, primeiro secretário, segundo secretário e terceiro secretário, bem como de três
suplentes de secretário.
(Disponível: http://www.cl.df.gov.br/en/web/guest/mesa-diretora)
Considere que na Câmara Legislativa exista um banco de dados funcionando em condições ideais. Considere que exista uma
tabela neste banco denominada TabCamara que possua os campos CodDepDistr (inteiro), NomeDepDistr (caracteres), Partido
(caracteres), CargoMesaDiretora (caracteres). Caso um deputado distrital não tenha cargo na mesa diretora da câmara o campo
fica com NULL
Uma Analista de Sistemas foi solicitada a fazer uma consulta SQL que resulte na lista de Deputados que possuem cargo na mesa
diretora, em ordem alfabética dos nomes dos partidos e, dentro de cada partido, ordenados por nomes. A instrução SQL que
realiza esta consulta é:
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010301
Banco de Dados
Texto associado
Atenção: Considere as informações abaixo para responder as questões de números 33 e 34.
A Mesa Diretora da Câmara Legislativa é responsável pela direção dos trabalhos legislativos e dos serviços administrativos da
Casa. Compõe-se de presidente, vice-presidente, primeiro secretário, segundo secretário e terceiro secretário, bem como de três
suplentes de secretário.
(Disponível: http://www.cl.df.gov.br/en/web/guest/mesa-diretora)
Considere que na Câmara Legislativa exista um banco de dados funcionando em condições ideais. Considere que exista uma
tabela neste banco denominada TabCamara que possua os campos CodDepDistr (inteiro), NomeDepDistr (caracteres), Partido
(caracteres), CargoMesaDiretora (caracteres). Caso um deputado distrital não tenha cargo na mesa diretora da câmara o campo
fica com NULL
A Analista de Sistemas realizou outra consulta utilizando o comando SQL: SELECT DISTINCT Partido, CargoMesaDiretora, NomeDepDistr FROM TabCamara WHERE CargoMesaDiretora LIKE '%secr%';
Esta consulta apresentou
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010302
Engenharia de Software
Considere, por hipótese, que um Analista de Sistemas da Câmara Legislativa, ao observar o fluxo da criação ao arquivamento
de documentos institucionais por Deputados Distritais, criou o diagrama UML abaixo. 
Este diagrama
Este diagrama
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010303
Governança de TI
Considere, por hipótese, que alguns Deputados Distritais apresentaram projetos na Câmera Legislativa e solicitaram à um
Analista de Sistemas que avaliasse se cada projeto respeita os pressupostos da ecologia da informação. O Analista concluiu,
corretamente, que o trecho de um projeto que o coloca de acordo com a ecologia da informação é
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010304
Algoritmos e Estrutura de Dados
Considere, por hipótese, que uma Analista de Sistemas da Câmara Legislativa está participando de um processo de avaliaçãode quatro softwares concorrentes para suporte a algumas atividades da Câmara. A Analista solicitou que cada empresafornecesse a função de complexidade do principal algoritmo do software. As funções de complexidade estão listadas abaixo.
I. f(n) = n² II.f(n) = nlog₂n III. f(n) = 2n IV. f(n) = 3log₂n
Ao fazer a análise dos algoritmos, a Analista conclui corretamente que
I. f(n) = n² II.f(n) = nlog₂n III. f(n) = 2n IV. f(n) = 3log₂n
Ao fazer a análise dos algoritmos, a Analista conclui corretamente que
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010305
Administração Geral
Em todos os tipos de abordagem para a realização do planejamento estratégico há a necessidade da realização de uma análise
da situação atual. Para realizar a análise, muitas vezes é utilizada a ferramenta denominada Análise SWOT que compreende o
levantamento apenas de fatores internos e externos denominados
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010306
Administração Geral
O diagrama de Ishikawa visa auxiliar a encontrar e eliminar possíveis deficiências na qualidade de serviços e produtos para
garantir melhores resultados. O diagrama de Ishikawa tem como característica
Ano: 2018
Banca:
FCC
Órgão:
Câmara Legislativa do Distrito Federal
Prova:
FCC - 2018 - Câmara Legislativa do Distrito Federal - Analista de Sistemas - Área 1 |
Q2010307
Administração Pública
A nova era da comunicação por meio da internet possibilitou o estabelecimento da democracia digital uma vez que esta forma de
comunicação permite e facilita a maior participação da população. Nesse cenário, no Brasil existe o Portal da Transparência,
cuja finalidade principal de uso é
Conheça nossos planos