Examcollection offers free demo for C2090-730 exam. "DB2 9 Family Fundamentals", also known as C2090-730 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-730 exam, will help you answer those questions. The C2090-730 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-730 exams and revised by experts!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-730-exam-dumps.html
Q121. Given the following expression:
SELECT QUANTITY,
CASE WHEN ITEMCODE = '099' THEN "SILVER"
WHEN ITEMCODE = '788' THEN "GOLD"
WHEN ITEMCODE = '899' THEN "PLATINUM"
ELSE ERROR
END
FROM SUPPLIER What will be the result of the query if the following data is evaluated by the CASE expression?
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
A. 3, SILVER 4, GOLD 1, SILVER 1, GOLD 5, PLATINUM 3, SILVER 1, GOLD
B. 3, SILVER 4, SILVER 1, GOLD 1, PLATINUM 5, ERROR 3, GOLD 1, PLATINUM
C. C. C. 3, SILVER 4, SILVER 1, PLATINUM 1, ERROR 5, SILVER 3, GOLD 1, PLATINUM
D. D. D. 3, SILVER 4, SILVER 1, GOLD 1, GOLD 5, SILVER 3, ERROR 1, PLATINUM
Answer: B
Explanation:
Q122. The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;
What is the current content of the staffsalary table?
A. ID | EMPSALARY ----------------- 10 | 60000 20 | 50000.00 -----------------
B. ID | EMPSALARY ----------------- 10 | 50000.00 20 | 50000.00 -----------------
C. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 60000.00 -----------------
D. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 50000.00 -----------------
Answer: C
Explanation:
Q123. Given the following UPDATE statement:
UPDATE employees SET workdept =
(SELECT deptno FROM department WHERE deptno = 'A01')
WHERE workdept IS NULL
Which of the following describes the result if this statement is executed?
A. The statement will fail because an UPDATE statement cannot contain a subquery.
B. The statement will only succeed if the data retrieved by the subquery does not contain multiple records.
C. The statement will succeed; if the data retrieved by the subquery contains multiple records, only the first record will be used to perform the update.
D. The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.
Answer: B
Explanation:
Q124. When does a view get populated?
A. When it is created
B. When it is referenced in an INSERT statement
C. The first time any executable SQL statement references it
D. Any time an executable SQL statement references it
Answer: D
Explanation:
Q125. Given the following tables: TABLEA EMPIDNAME
1 USER1 2 USER2
TABLEB
EMPID WEEKNO PAYAMT
1 1 1000.00 1 2 1000.00 2 1 2000.00 and the fact that TABLEB was defined as follows:
CREATE TABLE tableb (empid SMALLINT, weekno SMALLINT, payamt DECIMAL(6,2), CONSTRAINT const1 FOREIGN KEY (empid) REFERENCES tablea(empid) ON DELETE NO ACTION)
If the following command is issued:
DELETE FROM tablea WHERE empid=2
How many rows will be deleted from TABLEA and TABLEB?
A. TABLEA - 0, TABLEB - 0
B. TABLEA - 0, TABLEB - 1
C. TABLEA - 1, TABLEB - 0
D. TABLEA - 1, TABLEB – 1
Answer: A
Explanation:
253. Which of the following actions will NOT cause a trigger to be fired?
A. INSERT
B. DELETE
C. ALTER
D. UPDATE
Answer: C
Explanation:
Q126. A view is created with the following statement:
CREATE VIEW v1
AS SELECT col1, col2, col3, col4
FROM t1
WHERE col4 > 1000
WITH CHECK OPTION
What is the effect of the CHECK OPTION clause?
A. Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B. From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C. At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D. Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.
Answer: A
Explanation:
Q127. Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?
A. REVOKE SELECT FROM user2 ON TABLE org.tab1
B. REVOKE SELECT ON TABLE org.tab1 FROM user2
C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
Answer: B
Explanation:
Q128. Which of the following tools can make recommendations for indexes and/or
MQTs to improve the performance of DB2 applications?
A. Design Advisor
B. Visual Explain
C. Performance Advisor
D. Configuration Assistant
Answer: A
Explanation:
Q129. Given the following tables:
YEAR_2006 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Wood, Ronnie 4 Watts, Charlie 5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Chapman, Tony 6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2006 UNION SELECT name FROM year_1962
A. 0
B. 6
C. 10
D. 12
Answer: C
Explanation:
Q130. What is the maximum size that can be specified when creating an XML column in a DB2 table?
A. No size is specified
B. The buffer pool size
C. The page size for the table space
D. The extent size for the table space
Answer: A
Explanation: