What does the cursor attribute ‘%rowcount’ do?

The data type returned by a ‘%FOUND’ cursor attribute is

True of False :A package specification can exist without a body

In which property does a NUMBER datatype differs from a PLS_INTEGER datatype

How many types of triggers are there?

A database storage is stored in the database as

What are the modes of parameters that can be passes to a procedure?

The default mode of parameters that can be passes to a procedure?

What are the types of cursors available in plsql?

Which of the following statements about PL/I arrays is TRUE ?

Which of the following statements about PL/I programs are TRUE?

A PL/I programmer wants to display a number in his/her program. Which of the following variables is suited for doing this ? +123.45 (we assume the decimal sign is ‘.’)

A PL/I programmer wants to repeat an instruction 5 times. How can he/she code this ?

Take a look at the following PL/I program. Assume A, B, C, ... being PL/I instructions. In which order will they be executed? MYPROG : PROCEDURE OPTIONS (MAIN); CALL INIT; Z; CALL TERM; Z; END MYPROG; INIT : PROCEDURE; A; B; CALL READ-X; LOOP : PROCEDURE; E; F; TERM : PROCEDURE; G; H; READ-X : PROCEDURE. X;

Take a look at the following PL/I variables. Which of the given conditions is NOT correct? DCL INFILE FILE RECORD INPUT; DCL EOF BIT(1) INIT (‘0’B); ON ENDFILE (INFILE) EOF = ‘1’B; (1) DO WHILE (NOT EOF); (2) DO WHILE (^EOF); (3) DO WHILE (EOF = ‘0’B); (4) DO WHILE (EOF ^= ‘1’B);

Assume a PL/I program that wants to execute a call to an external procedure. This procedure expects 1 parameter and returns 1 parameter. Which instructions do you have to provide in the main program ? (1) DCL MYSUB ENTRY (CHAR(5)) EXTERNAL; (2) DCL MYSUB ENTRY (CHAR(5)) RETURNS (CHAR(5)) EXTERNAL; (3) DCL MYPARAMETER,MYRESULT CHAR(5); (4) CALL MYSUB (MYPARAMETER); (5) MYRESULT = MYSUB; (6) MYRESULT = MYSUB(MYPARAMETER);

If you have the following declarations, what will be the content of RESULT at the end of the given instructions? DCL 1 VAR1 CHAR(5) INIT (‘PL/I’); DCL 1 VAR2 CHAR(10); DCL 1 VAR3 CHAR (2); DCL 1 RESULT CHAR (5); RESULT = ‘COBOL’; VAR2 = VAR1; VAR3 = VAR2; RESULT = VAR3;

Which of the following PL/I SELECT statements is correct ?

Which of the following array declarations is NOT correct ? (1) DCL ARRAY_1 DEC FIXED (3)(5,2); (2) DCL ARRAY_1 (5,2) DEC FIXED (3); (3) DCL ARRAY_1 (5) DEC FIXED (3), (2) DEC FIXED (3); (4) DCL (5,2) ARRAY_1 DEC FIXED (3);

The following are only recognized in white space programming