Precise of C2090-730 real exam materials and dumps for IBM certification for IT specialist, 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:
Q151. Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?
A. Journal
B. Task Center
C. Control Center
D. Activity Monitor
Answer: A
Explanation:
Q152. 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:
Q153. 57 Given table T1 has column I1 containing the following data: I1
1 2 3 4
If the following sequence of SQL statements is applied within a single unit of work:
UPDATE t1 SET i1 = 3 WHERE i1 = 2; S
AVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
UPDATE t1 SET i1 = 5 WHERE i1 = 3;
SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;
INSERT INTO t1 (i1) VALUES (6);
ROLLBACK TO SAVEPOINT s1;
UPDATE t1 SET i1 = 2 WHERE i1 = 4;
COMMIT;
What is the expected sequence of values returned from?
SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6
Answer: A
Explanation:
Updated C2090-730 test engine:
Q154. Given the following table definitions:
EMPLOYEES
EMPID INTEGER NAME CHAR(20) DEPTID CHAR(3) SALARY DECIMAL(10,2)
COMMISSION DECIMAL(8,2)
DEPARTMENTS
DEPTNO INTEGER
DEPTNAME CHAR(20)
Which of the following statements will produce a result data set that satisfies all of these conditions:
> Displays the total number of employees in each department
>> Displays the corresponding department name for each department ID
>> Sorted by department employee count, from greatest to least
A. SELECT *, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC
B. SELECT deptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC
C. SELECT deptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 ASC
D. SELECT deptname, COUNT(*) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2
Answer: B
Explanation:
Q155. Which of the following is NOT a characteristic of a unique index?
A. Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot be used in multiple uniqueindexes)
B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute
C. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value
D. A unique index can only be created for a non-nullable column
Answer: D
Explanation:
Q156. Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?
A. It will randomly pick an application and rollback its current transaction
B. It will rollback the current transactions of both applications
C. It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved
D. It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction
Answer: A
Explanation:
Validated C2090-730 free demo:
Q157. If the following SQL statements are executed in the order shown:
CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);
INSERT INTO table1 VALUES (123, 456);
UPDATE table1 SET c1 = NULL;
What will be the result of the following statement?
SELECT * FROM table1;
A. C1 C2
123 456
1 record(s) selected.
B. C1 C2
NULL 456 1 record(s) selected.
C. C1 C2
-
456
1 record(s) selected.
D.
C1 C2
0 456
1 record(s) selected.
Answer: C
Explanation:
Q158. Which of the following describes how DB2 9 stores an XML document if the
XML Extender is not used?
A. CLOB
B. BLOB
C. Hierarchically
D. Rows and columns
Answer: C
Explanation:
Q159. Given the following function:
CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END
How can this function be used in an SQL statement?
A. SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
Answer: D
Explanation:
Q160. Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
A. BLOB
B. CLOB
C. DBCLOB
D. GRAPHIC
Answer: B
Explanation: