FUNDAO GETULIO VARGAS

ESCOLA DE ADMINISTRAO DE EMPRESAS DE SO PAULO

CONCURSO PBLICO
PRODAM - PROC. DE DADOS DO MUNIC. DE SAO PAULO
17-FEV-02

CARGO: 01 AN PROG PL (COBOL-DB2)

ESTE CADERNO CONTM 40 QUESTES

NO VIRE ESTA PGINA AT O FISCAL AUTORIZAR

ASSINE A LISTA DE PRESENA DURANTE ESTE EXAME

TERMINADO ESTE EXAME, ENTREGUE AO FISCAL

O SEU CARTO DE RESPOSTAS
E A SUA FOLHA DE REDAO (SE HOUVER)

VOC PODER LEVAR CONSIGO ESTE CADERNO DE QUESTES,

DESDE QUE VOC TERMINE ESTE EXAME FALTANDO UMA HORA
(OU MENOS) PARA O TRMINO DESTE EXAME

www.pciconcursos.com.br

17-fev-02 PRODAM - Proc. de Dados do Munic. de Sao Paulo Cargo 1: An Prog PL (Cobol-DB2)
Cod. 28 - COBOL II - 12 questes
COBOL II

D. 100000
.10. Qual das sentenas abaixo esta sintaticamente correta?
A. MULTIPLY QTY ROUNDED BY PRICE
B. MULTIPLY ROUNDING QTY TIMES PRICE
C. MULTIPLY QTY BY PRICE ROUNDED
D. ROUND (MULTIPLY) QTY BY PRICE

.01. Qual o significado da sigla COBOL?

A. Computer Business Oriented Language
B. Commom Business Oriented Language
C. Converse Business Oriented Language
D. Computer Basic Oriented Language
.02. Quantas divises tm um programa em COBOL II?
A. Duas
B. Quatro
C. Cinco
D. Seis
.03. Qual dos comandos abaixo NO mais suportado no
COBOL II?
A. Open
B. Read
C. Ready Trace
D. Write
.04. Qual a funo da clusula INITIALIZE?
A. Inicializar Arquivos
B. Inicializar Comandos
C. Inicializar Report
D. Inicializar Variveis

.11. Na gravao de um arquivo VSAM KSDS, ocorreu um erro

de estouro de rea do arquivo; qual dos file status abaixo
representa o erro?
A. 10
B. 22
C. 23
D. 34
.12. Na leitura de um arquivo VSAM KSDS, ocorreu um erro de
registro no encontrado; qual dos file status abaixo representa
o erro?
A. 10
B. 22
C. 23
D. 34
Cod. 29 - IMS (DLI) - 8 questes
IMS (DL I)
.13. Como se recupera Dados em um Banco de Dados IMS?
A. Randomicamente
B. Caminho de acesso definido
C. Seqencialmente
D. A partir do primeiro registro

.05. O que LENGTH em COBOL II?

A. Define um campo compactado
B. Define a chave de pesquisa
C. Define o file status
D. Define o tamanho de um item elementar

.14. Quais so os softwares que compem o IMS?

A. IMS DB
B. IMS DC
C. IMS AD
D. IMS DB/DC

.06. Qual o tamanho da tabela abaixo em bytes?

01 DEPT-TABLE.
05 EACH-ENTRY OCCURS 100 TIMES.
10 EACH-DEPT-NO
PIC X(5).
10 EACH-DEPT-NAME PIC X(25).
A. 30 bytes
B. 3000 bytes
C. 500 bytes
D. 5000 bytes

.15. Qual a funo do IMS DC?

A. Gerenciar o sistema operacional
B. Gerenciar o banco de dados
C. Gerenciar a rede interna
D. Gerenciar os registros

.07. De acordo com a definio da tabela abaixo, qual ser o

contedo do comando DISPLAY?
01 DEPT-TABLE VALUE
'AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQRRSSTTUU'.
05 EACH-ENTRY OCCURS 21 TIMES.
10 EACH-ITEM-CODE PIC X(2).
DISPLAY EACH-ITEM-CODE (10).
A. JJ
B. E
C. IJ
D. Low-values

.16. Qual a funo do IMS DB?

A. Gerenciar o sistema operacional
B. Gerenciar o banco de dados
C. Gerenciar a rede interna
D. Gerenciar os registros
.17. Quando o cdigo de retorno GU vem em branco, o que
ocorreu?
A. Segmento foi encontrado
B. Segmento no foi encontrado
C. Acesso feito com sucesso
D. Acesso no foi realizado

.08. De acordo com a definio da tabela abaixo, qual ser o

contedo do comando DISPLAY?
01 DEPT-TABLE VALUE
'AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQRRSSTTUU'.
05 EACH-ENTRY OCCURS 21 TIMES.
10 EACH-ITEM-CODE PIC X(2).
DISPLAY DEPT-TABLE (6:1).
A. FF
B. C
C. AABBCC
D. FFAA
.09. De acordo com a definio da varivel abaixo, qual ser o
contedo do comando DISPLAY aps a execuo do
comando SUBTRACT?
77 SALARY-ACCUMULATOR PIC 9(7)V99 PACKED-DECIMAL
VALUE 0.
SUBTRACT 100000 FROM SALARY-ACCUMULATOR
DISPLAY SALARY-ACCUMULATOR.
A. Spaces
B. Zeros
C. 100000

.18. Quando o cdigo de acesso REPL retorna em branco

significa que:
A. Alterao foi feita com sucesso
B. Alterao no foi feita com sucesso
C. Registro no foi encontrado
D. Registro foi encontrado
.19. Qual o nome do mdulo do IMS que serve como interface
entre o programa de aplicao e o banco de dados?
A. IMS DB
B. IMS DC
C. PCB
D. DLI
.20. Quando o cdigo de erro for igual a LE, significa que:
A. Alterao foi feita com sucesso
B. Alterao no foi feita com sucesso
C. Registro no foi encontrado
D. Os segmentos no esto na mesma seqncia da DBD
Cod. 30 - CSP - 3 questes

www.pciconcursos.com.br

17-fev-02 PRODAM - Proc. de Dados do Munic. de Sao Paulo Cargo 1: An Prog PL (Cobol-DB2)
CSP

C. 1
D. '2001-09-09'

.21. O que significa a sigla CSP?

A. Crossing System Product
B. Crossing System Process
C. Cross System Product
D. Cross System Procedures

Cod. 32 - Ingls para Analista Programador Pleno

(COBOL/DB2) - 10 questes
INGLS PARA ANALISTA PROGRAMADOR PLENO
(COBOL/DB2)

.22. Como se divide a Estrutura do CSP

A. CSP/A, CSP/DA, CSP/EA
B. CSP/Q, CSP/AD, CSP/AE
C. CSP/Q, CSP/XA, CSP/XB
D. CSP/Q, CSP/AX, CSP/AY
.23. Qual a funo do comando CONVERSE ?
A. Gravar um registro em um arquivo
B. Ler um registro em hold
C. Exibir um mapa e obter uma resposta
D. Adicionar um registro em uma tabela
Cod. 31 - Bco Dados DB2 - 7 questes
BANCO DE DADOS DB2
.24. Qual a Query, dentre as abaixo, que est correta?
A. SELECT * FROM Q.STAFF
FOR CURSOR ONLY
ORDER BY JOB
WHERE SALARY > 15,000
B. SELECT * FROM Q.STAFF
WHERE SALARY < 15000
ORDER BY JOB
FOR FETCH ONLY
C. SELECT * FROM Q.STAFF
WHERE SALARY > 15000
ORDER BY JOB
FOR ACCESS ONLY
D. SELECT * FROM Q.STAFF
WHERE SALARY > 15000
ORDER BY JOB
AS READ ONLY
.25. Qual o comando com a clusula WHERE, dentre os abaixo,
que est correto?
A. WHERE COMM = 'NULL'
B. WHERE COMM LIKE 'NULL
C. WHERE COMM IS NULL
D. WHERE COMM NULL
.26. Qual o comando com a clusula WHERE abaixo que est
correto?
A. WHERE SALARY BETWEEN (14000 AND 10000)
B. WHERE SALARY BETWEEN 14000 AND 10000
C. WHERE SALARY BETWEEN 10000 AND 14000
D. WHERE SALARY BETWEEN 10000,14000
.27. Qual o comando com a clusula SELECT, dentre os abaixo,
que est correto?
A. SELECT JOB | DEPT FROM Q.STAFF
B. SELECT JOB, CONCAT (DEPT) FROM Q.STAFF
C. SELECT JOB, CONCAT (DEPT) FROM Q.STAFF
D. SELECT (JOB, DEPT) FROM Q.STAFF
.28. Aps o comando SELECT ABS (SALARY - COMM), qual o
resultado obtido?
A. 14.32
B. 14.32
C. $14.32
D. 14:32
.29. Aps o comando SELECT DAYOFWEEK (HIREDATE), qual
o resultado obtido?
A. SUNDAY
B. 327545
C. 1
D. '2001-09-09'
.30. Qual o formato de um campo DATE?
A. SUNDAY
B. 327545

.31. COBOL II is IBM's newest COBOL compiler that runs on IBM

mainframes. It is based upon the VS COBOL programming
language that has been used for years. It provides virtual
storage constraint relief by allowing COBOL II programs,
program data, the COBOL II compiler, and COBOL II library
routines to run both above and below the 16 megabytes in
line.
According to the text, which is the correct answer?
A. COBOL II is IBM's newest COBOL pre-compiler that runs on
IBM mainframes;
B. COBOL II is IBM's newest COBOL compiler that runs on IBM
mainframes;
C. COBOL II is the newest COBOL compiler that runs on IBM
mainframes;
D. COBOL II is a compiler that runs on IBM mainframes;
.32. In VS COBOL, as well as in COBOL II, the period is an
implicit scope terminator that ends the scope of any
statements that have not yet terminated. For example, the
scope of an AT END, ON OVERFLOW or ON SIZE ERROR
clause in a VS COBOL program remains in effect until a period
is reached. According to the text, which is the correct answer?
A. For AT END, ON OVERFLOW or ON SIZE ERROR clauses,
you don't need to use the period;
B. For AT END, ON OVERFLOW or ON SIZE ERROR clauses,
you need to use the period;
C. For AT END, ON OVERFLOW or ON SIZE ERROR clauses,
you have not to use the period;
D. For AT END, ON OVERFLOW or ON SIZE ERROR clauses,
you shouldnt use the period;
.33. Floating-point exponentiation under COBOL II can yield more
accurate results than fixed-point exponentiation. In addition,
both VS COBOL and COBOL II do computations of fixed-point
data items with large exponents faster in floating-point. The
floating-point computations should even be more accurate
than fixed-point computations. According to the text, which is
the correct answer?
A. Floating-point computations should be even more accurate
than fixed-point computations.
B. Floating-point computations are more accurate than fixed-point
computations.
C. Floating-point computations are less accurate than fixed-point
computations.
D. Floating-point computations aren't more accurate than fixedpoint computations.
.34. An online application program always has exclusive use of
the SHSAM or HSAM databases, which are referenced by
PCBs in its PSB. No other application programs will be
concurrently scheduled to access those same SHSAM or
HSAM databases in an online environment. According to the
text, which is the correct answer?
A. Other online applications can access those same SHSAM or
HSAM databases in an online environment.
B. Other online applications can rewrite those same SHSAM or
HSAM databases in an online environment.
C. Other online applications can write those same SHSAM or
HSAM databases in an online environment.
D. Other online applications cannot access those same SHSAM
or HSAM databases in an online environment.
.35. PROCSEQ specifies the name of a secondary index that is
used to process the database named in the DBNAME operand
through a secondary processing sequence. The operand is
optional. It is valid only if a secondary index exists for this
database. According to the text, which is the correct answer?
A. PROCSEQ doesn't specify the name of a secondary index that
is used to process the database named in the DBNAME.
B. PROCSEQ specifies the name of a secondary index that is
used to process the database named in the DBNAME.

www.pciconcursos.com.br

17-fev-02 PRODAM - Proc. de Dados do Munic. de Sao Paulo Cargo 1: An Prog PL (Cobol-DB2)
C. PROCSEQ specifies the name of a primary index that is used
to process the database named in the DBNAME.
D. PROCSEQ specifies the name of a first index that is used to
process the database named in the DBNAME.
.36. Applications are defined as a top-down structure of
processing logic blocks called processes and statement
groups. The top level in the structure is a sequence of one or
more processes called main processes. Each process and
statement group contains CSP/AD language processing
statements. According to the text, which is the correct answer?
A. Applications isn't defined as a Top-down structure structure.
B. Applications has not defined as a Top-down structure.
C. Applications are defined as a Top-down structure.
D. Applications have not as define as a Top-down structure.
.37. A process represents the input or output of a record or map.
It consists of processing statements before and after a process
option (type of I/O operation), and a process object (name of
the defined record structure or map that the process option
uses). A process is divided logically into the processing
statements that are to be run before and after the process
option is performed. Processes can be defined as main
processes of the application or invoked from other processes
or statement groups. According to the text, which is the correct
answer?
A. A process only has records and a map
B. A process has a name
C. A process represents the input and output of a record or map
D. A process doesn't have a Top-down structure
.38. A Package is a single, bound DBRM with optimized access
paths. Prior to DB2, the only option available for binding was
at the plan level. By using packages, the table access logic is
"packaged" at a lower level of granularity, at the Package or
program level. According to the text, what is the correct
definition of a Package?
A. A Package is a single, bound DBRM with an optimized access
path.
B. A Package is not a single, bound DBRM with an optimized
access path.
C. A Package is a record and bound DBRM with an optimized
access path
D. A Package is a table and bound DBRM with an optimized
access path
.39. A DBRM is nothing more than a module containing SQL
statements extracted from a source program by the DB2
precompiler. It is stored as a member of a partitioned dataset.
According to the text, what is the correct definition of a DBRM?
A. A DBRM is not a module containing SQL statements extracted
from a source program by the DB2 precompiler.
B. A DBRM is nothing more than a module containing SQL
statements extracted from a source program by the DB2
precompiler.
C. A DBRM is a module containing SQL statements extracted
from a source program by the DB2 precompiler.
D. A DBRM is more than a module containing SQL statements
extracted from a source program by the DB2 precompiler.
.40. A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRM and Packages. According to the text,
which statement best defines a Plan?
A. A Plan can be composed of one DBRM.
B. A Plan is an executable module that contains the access path
logic.
C. A Plan does not contain access path logic.
D. A Plan can be composed of one or more DBRM.

CARGO: 01 ANALISTA PROGRAMADOR PLENO (COBOL / DB2)

QUESTO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

GABARITO GABARITO
DECISO
PROVISRIO DEFINITIVO
B
B
B
B
C
C
D
D
D
D
B
B
A
A
C
C
C
C
C
C
D
D
C
C
B
B
D
D
A
A
B
B
C
C
A
A
D
D
D
D
C
C
B
B
C
C
B
B
INDEFERIDO
A
A
INDEFERIDO
C
C
D
D
B
B
A
A
D
D
B
B
B
B
A
A
D
D
B
B
C
C
C
C
A
A
B
B
B
B

FIM DO CADERNO

www.pciconcursos.com.br

17-fev-02 PRODAM - Proc. de Dados do Munic. de Sao Paulo Cargo 1: An Prog PL (Cobol-DB2)

ENUNCIADO DAS QUESTES DISSERTATIVAS

Resolva estas questes em folha dupla de papel almao.

Use uma folha dupla para cada questo.
Coloque em cada folha dupla seu nome completo, seu CPF, nome do cargo e cdigo do cargo.

Analista Programador Pleno (Cobol/DB2)

QUESTO 01 - Uma empresa possui um banco de dados com 3 mil funcionrios. Por ocasio do dissdio
coletivo da categoria, decide dar um aumento escalonado por faixa de salrio aos seus funcionrios. Para
quem ganha at R$ 5.000,00 (inclusive) o aumento ser de 10,00%; para os funcionrios com salrios
superiores a R$ 5.000,00 e inferiores a R$ 10.000,00 o aumento ser de 7,00%; aos salrios a partir de R$
10.000,00 ser concedido um aumento de 3,30%. Escreva um algoritmo (fluxograma, pseudocdigo) para
calcular e guardar no banco de dados o valor do salrio reajustado de cada funcionrio.

QUESTO 02 - Faa um algoritmo (fluxograma e pseudocdigo) para gerar os 50 primeiros termos da

seqncia de Fibonacci. O clculo de um termo da seqncia de Fibonacci encontrado somando-se os
dois termos anteriores. Os dois primeiros so invariavelmente 1 e 1. Ex.: 1, 1, 2, 3, 5, 8, ...

QUESTO 03 - Um motorista deseja saber o consumo mdio de seu caminho. Para isso ele anota a
quantidade (litros) de diesel, o valor (em R$) que ele paga e a quantidade de quilmetros percorridos desde
a ltima vez que abasteceu o caminho. Escreva um algoritmo para solicitar o total de litros, a
quilometragem rodada e o valor pago em cada abastecimento e calcule o preo mdio pago por litro e o
consumo mdio do caminho nos ltimos 12 abastecimentos.

QUESTO 04 - Uma fbrica deseja aplicar um aumento para seus produtos. Escreva um algoritmo para:
1- receber um percentual de reajuste
2 - reajustar todos os preos dos produtos com o percentual fornecido no item 1
3 - Imprimir uma planilha demonstrando o preo antigo, o valor do reajuste, e o preo novo.
Admita que os produtos encontram-se em um banco de dados da empresa.

www.pciconcursos.com.br