IBM Braindumps

Real Exam Questions Dumps With Their Answers

'C2090-730 Dumps PDF'

C2090-730 Dumps


You can pass easily using C2090-730 dumps. We keep postings these C2090-730 exam questions answers on this site regularly. Some search words are C2090-730 braindumps, past papers, study material and C2090-730 dumps practice test.

C2090-730 Dumps PDF | A programmer wants to generate values

Question: 4

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?

A. Sequence
B. Table Function
C. Identity Column
D. INSTEAD OF Trigger

Answer: A

C2090-730 | Which of the following DB2 objects is NOT…

Question: 3

Which of the following DB2 objects is NOT considered executable using SQL?

A. Routine
B. Function
C. Procedure
D. Trigger

Answer: D

C2090-730 | A declared temporary table is used for which…

Question: 2

A declared temporary table is used for which of the following purposes?

A. Backup purposes
B. Storing intermediate results
C. Staging area for load operations
D. Sharing result data sets between applications

Answer: B

C2090-730 | Within the application MY_APP the following…

Question: 1

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq
After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

A. After a ROLLBACK is issued
B. After the sequence is altered
C. After the sequence is dropped
D. After the current session ends

Answer: A