IBM C2090-730 - DB2 9 Family Fundamentals Exam
Page: 2 / 61
Total 301 questions
Question #6 (Topic: )
In which situation is shredding XML data recommended?
A. When the data is naturally tabular
B. When the number of nodes are volatile
C. When the data by nature has sparse attributes
D. When the data is of low volumeand requires a complex star-schema topology
Answer: A
Question #7 (Topic: )
Application A wants to read a subset of rows from table TAB1 multiple times. Which of the
following isolation levels should Application A use to prevent other users from making
modifications and additions to table TAB1 that will affect the subset of rows read?
following isolation levels should Application A use to prevent other users from making
modifications and additions to table TAB1 that will affect the subset of rows read?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: A
Question #8 (Topic: )
Given the following stored procedure:
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SETp_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6),
OUT p_sum DECIMAL(9,2) )
SETp_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);
How can this stored procedure be called from the Command Line Processor?
A. CALL increase_salary('A00')
B. VALUES increase_salary('A00')
C. CALL increase_salary('A00', ?)
D. VALUES increase_salary('A00', ?)
Answer: A
Question #9 (Topic: )
Which of the following statements will catalog the database MYDB on the node MYNODE
and assign it the alias MYNEWDB?
and assign it the alias MYNEWDB?
A. CATALOG DATABASE mynewdb AT NODE mynode
B. CATALOG DATABASE mynewdb AS mydb AT NODE mynode
C. CATALOGDATABASE mydb AT NODE mynode
D. CATALOG DATABASE mydb AS mynewdb AT NODE mynode
Answer: D
Question #10 (Topic: )
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?
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
