Correct Answer: By using WITH HOLD option
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Programming Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Programming MCQ Questions
When do you specify the isolation level?
How would you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP?
How do you concatenate the FIRSTNAME and LASTNAME from EMPLOYEE table to give a complete name?
Which technique is used to retrieve data from more than one table in a single SQL statement?
If the null indicator has -1, what does it mean?
SQL statements embedded into an application is called what?
Can static SQL statements be changed without altering the program itself?
When is it necessary to precompile DB2 REXX procedures before running them?
Given the statement: CREATE TABLE t1 (c1 INTEGER NOT NULL,c2 INTEGER,PRIMARY KEY(c1),FOREIGN KEY(c2) REFERENCES t2) How many non-unique indexes are defined for table t1?
When a user has a SELECT authorization on a certain base table, and he creates a view on that table alone, then which of the following is true?