which of the following is the lowest cost DB2 edition that can be used to take advantage of all server’s
Considering you have a server with 4 processor cores and 8GB of memory, which of the following
is the lowest cost DB2 edition that can be used to take advantage of all server’s resources?
What will happen to the transaction after 20 seconds waiting?
One transaction is trying to acquire a lock to modify a row in table A. Consider the database lock
timeout (locktimeout) parameter is set to 20 and that DB2 checks for deadlocks every 60 seconds.
What will happen to the transaction after 20 seconds waiting?
Which of the following languages can NOT be used to create a UDF in DB2 9.7?
Which of the following languages can NOT be used to create a UDF in DB2 9.7?
Which privilege is required to invoke a user-defined function?
Which privilege is required to invoke a user-defined function?
Which of the following statements is TRUE about transactions?
Which of the following statements is TRUE about transactions?
The type of data structure that is used in a relational model is?
The type of data structure that is used in a relational model is?
which of the following commands would successfully execute procedure PROC1?
Consider a Stored Procedure with the following definition:
CREATE OR REPLACE PROCEDURE proc1 (IN p2 VARCHAR(20))
BEGIN
…
END
@
Using DB2 CLP, which of the following commands would successfully execute procedure
PROC1?
Which of the following statements is true about constraints?
Which of the following statements is true about constraints?
Which of the following packages have the smallest footprint but is still suitable for executing JDBC applicati
Which of the following packages have the smallest footprint but is still suitable for executing JDBC
applications?
Which of the following is FALSE about DSAC?
Which of the following is FALSE about DSAC?