Top Quality of C2090-730 exam question materials and keys for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q161. 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:
Q162. Which kind of non-sourced UDF can be created so that it only returns a single value?
A. Row
B. Table
C. Scalar
D. Column
Answer: C
Explanation:
290. Given that tables T1 and T2 contain the following rows:
Table T1:
C1 C2
1 4
1 3
1 2
Table T2:
C1 C2
1 1
1 2
1 3
Which of the following queries will return only those rows that exist in both T1 and T2?
A. SELECT * FROM t1 UNION SELECT * FROM t2
B. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C. SELECT * FROM t1 INTERSECT SELECT * FROM t2
D. SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
Answer: C
Explanation:
291. Which of the following will begin a new unit of work?
A. The CONNECT statement
B. The first FETCH of a cursor
C. The BEGIN TRANSACTION statement
D. The first executable SQL statement
Answer: D
Explanation:
Q163. Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?
A. "<employee />"
B. "<name>John Doe</name>"
C. "<?xml version='1.0' encoding='UTF-8' ?>"
D. "<p></p>"
Answer: C
Explanation:
Most up-to-date C2090-730 exam question:
Q164. Given the following two tables:
TAB1 R1
A A A B B C C D E TAB2
R2
A
A
B
B
C
C
D
Which of the following queries returns the following result set?
RETVAL
E
A. SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
B. SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
C. SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
D. SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
Answer: B
Explanation:
Q165. Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?
A. LIST DB DIRECTORY
B. LIST DCS DIRECTORY
C. LIST NODE DIRECTORY
D. LIST ACTIVE DATABASES
Answer: B
Explanation:
Q166. Given the following queries:
SELECT c1 FROM tab1;
SELECT c1 FROM tab2;
Which of the following set operators can be used to produce a result data set that contains only records that are not found in the result data set produced by each query after duplicate rows have been eliminated?
A. UNION
B. INTERSECT
C. EXCEPT
D. MERGE
Answer: D
Explanation:
Tested C2090-730 faq:
Q167. Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?
A. %
B. *
C. ?
D.
Answer: A
Explanation:
Q168. CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML)
How many names will be returned for this XQuery?
A. 0
B. 1
C. 2
D. 3 Answer: C
Explanation:
Q169. Which of the following DB2 objects is NOT considered executable using SQL?
A. Routine
B. Function
C. Procedure
D. Trigger
Answer: D
Explanation:
Q170. Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition
Answer: A
Explanation: