IBM Braindumps

Real Exam Questions Dumps With Their Answers

'C2090-545 Exam Questions'

C2090-545 Dumps


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

C2090-545 | What is a reason to use SQL procedures…

Question: 4

What is a reason to use SQL procedures in DB2?

A. to use different programming languages
B. to reduce code sharing
C. to move business logic rules into the database
D. to eliminate the need for testing

Answer: C

C2090-545 | Which statement is permitted within a scalar…

Question: 3

Which statement is permitted within a scalar user-defined function body?

A. COMMIT
B. INSERT
C. SIGNAL
D. LOOP

Answer: C

C2090-545 | Which three optional clauses can be used…

Question: 2

Which three optional clauses can be used when creating an external function? (Choose three.)

A. SCRATCHPAD
B. NOTEPAD
C. LANGUAGE
D. EXTERNAL NAME
E. DATABASEINFO

Answer: A,C,D

C2090-545 | Which statement correctly describes characteristics…

Question: 1

Which statement correctly describes characteristics of external functions?

A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until thedatabase is quiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.

Answer: C