Verifone Omni 5750 paper

1. What does a COMMIT statement do to a CURSOR

a] Open the Cursor
b] Fetch the Cursor
c] Close the Cursor
d] None of the above
Ans : D
2. Which of the following is TRUE

1] Host variables are declared anywhere in the program
2] Host variables are declared in the DECLARE section
a] Only 1 is TRUE
b] Only 2 is TRUE
c] Both 1 & 2are TRUE
d] Both are FALSE
Ans : B
3. Which of the following is NOT VALID is PL/SQL

a] Bool boolean;
b] NUM1, NUM2 number;
c] deptname dept.dname%type;
d] date1 date := sysdate
Ans : B
4. Declare
fvar number := null; svar number := 5
Begin
goto < fproc>
if fvar is null then
< fproc>
svar := svar + 5
end if;
End;
What will be the value of svar after the execution ?
a] Errord] None of the above
Ans : A

5. Which of the following is not correct about an Exception ?

a] Raised automatically / Explicitly in response to an ORACLE_ERROR
b] An exception will be raised when an error occurs in that block
c] Process terminates after completion of error sequence.
d] A Procedure or Sequence of statements may be processed.
Ans : C
6. Which of the following is not correct about User_Defined Exceptions ?

a] Must be declared
b] Must be raised explicitly
c] Raised automatically in response to an Oracle error
d] None of the above
Ans : C
7. A Stored Procedure is a

a] Sequence of SQL or PL/SQL statements to perform specific function
b] Stored in compiled form in the database
c] Can be called from all client environments
d] All of the above
Ans : D
8. Which of the following statement is false

a] Any procedure can raise an error and return an user message and error number
b] Error number ranging from 20000 to 20999 are reserved for user defined messages
c] Oracle checks Uniqueness of User defined errors
d] Raise_Application_error is used for raising an user defined error.
Ans : C
9. Is it possible to open a cursor which is in a Package in another procedure ?

a] Yes
b] No
Ans : A
10. Is it possible to use Transactional control statements in Database Triggers ?

a] Yes
b] No
Ans : B
11. Is it possible to Enable or Disable a Database trigger ?

a] Yes
b] No
Ans : A
12. PL/SQL supports datatype(s)

a] Scalar datatype
b] Composite datatype
c] All of the above
d] None of the above
Ans C
13. Find the ODD data type out

a] VARCHAR2
b] RECORD
c] BOOLEAN
d] RAW
Ans : B
14. Which of the following is not correct about the "TABLE" data type ?

a] Can contain any no of columns
b] Simulates a One-dimensional array of unlimited size
c] Column datatype of any Scalar type