What does SPUFI stands for
SQL Programming Using File Input
SQL Processing Using File Input
SQL Processor Using File Input
Sequence Processing Using File Input
A key made up of more than one column is called
Complex Key
Secondary Key
Composite Key
Foreign Key
For which database object can a lock be obtained
a database directory
a database tablespace
a database bufferpool
a database column
What is the purpose of the COLLECTION parameter of precompile/bind parameter
define the name of the package
provide an alias for the package
define the schema of the package
define the database of the package
Which type of cursor should be used so that its position will be maintained between transactions
FOR HOLD
FOR UPDATE
FOR FETCH
WITH HOLD
What is the function of DB2 pre-compiler
Removes all the statements in source code
Replaces all the SQL statements into corresponding host language CALL statements
Replaces SQL statements into corresponding host language statements
None of the above
Where is the isolation level specified
BIND
REBIND
Both A & B
Which SQLCODE is used to check for duplicate index on a column
-803
-811
-805
-855
A Package is
A single, bound DBRM
A Multi bound DBRM with optimised access paths
A Single bound DBRM with optimised access paths
A Multi bound DBRM
What does DBRM contain
Edited form of the SQL statements with some additional information
Complied version of SQL statements
Complied version of source code