Want to know Testking C2090-730 Exam practice test features? Want to lear more about IBM DB2 9 Family Fundamentals certification experience? Study Best Quality IBM C2090-730 answers to Avant-garde C2090-730 questions at Testking. Gat a success with an absolute guarantee to pass IBM C2090-730 (DB2 9 Family Fundamentals) test on your first attempt.
♥♥ 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
Q51. A view is created with the following statement:
CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?
A. When view V1 is created
B. Each time the REFRESH VIEW v1 statement is executed
C. Each time an SQL statement is executed against view V1
D. Only the first time an SQL statement is executed against view V1
Answer: C
Explanation:
Q52. A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?
A. User ID/password file
B. Communications layer
C. Client applications
D. Operating system
Answer: D
Explanation:
Q53. The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row to be deleted?
A. DELETE ALL FROM tab01 FOR CURRENT OF csr01
B. DELETE FROM tab01 FOR CURRENT csr01 WITH RS
C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
Answer: D
Explanation:
142. Given the following query:
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?
SUPPLIER
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. 3,SILVER 4,SILVER 1,PLATINUM 1,ERROR 5,SILVER 3,GOLD 1,PLATINUM
D. 3,SILVER 4,SILVER 1,GOLD 1,GOLD 5,SILVER 3,ERROR 1,PLATINUM
Answer: B
Explanation:
Q54. Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?
A. INTEGER
B. REAL
C. NUMERIC(7, 3)
D. DECIMAL(10, 3)
Answer: D
Explanation:
Q55. 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:
Q56. A table was created using the following DDL:
CREATE TABLE employee
(id SMALLINT NOT NULL,
name VARCHAR(9),
dept SMALLINT CHECK (dept BETWEEN 10 AND 100),
job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')),
hiredate DATE,
salary DECIMAL(7,2),
comm DECIMAL(7,2),
PRIMARY KEY (id),
CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500)
); Which of the following INSERT statements will fail?
A. INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
B. INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
C. INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
D. INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)
Answer: D
Explanation:
Q57. Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedure
B. Develop and debug a user-defined data type
C. Develop and debug a user-defined function
D. Develop and run XML queries
Answer: B
Explanation:
Q58. Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?
A. Visual Explain
B. Activity Monitor
C. SQL Performance Monitor
D. DB2 Performance Monitor
Answer: C
Explanation:
Q59. Which of the following is the major difference between relational data and XML data?
A. Relational data is self-describing; XML data is not
B. Relational data has inherent ordering; XML data does not
C. Relational data must be tabular; XML data does not have to be tabular
D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
Answer: C
Explanation:
Q60. If the following statement is executed:
CREATE TABLE employee
(empid INT NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 5),
name VARCHAR(20),
dept INT CHECK (dept BETWEEN 1 AND 20),
hiredate DATE WITH DEFAULT CURRENT DATE,
salary DECIMAL(7,2), PRIMARY KEY(empid),
CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR
Salary > 60500));
Which of the following INSERT statements will fail?
A. INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
B. INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
C. INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
D. INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
Answer: D
Explanation: