Breathing of C2090-730 free practice test materials and vce for IBM certification for customers, 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:
Q171. Which of the following queries will correctly return the manager information sorted by the manager's last name, department and project name?
A. SELECT lastname, dept, projname, manager, startdate FROM (SELECT name, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = empno) AS empproj ORDER BY name, dept, projname
B. SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj SORT BY lastname, firstname, dept, projname
C. SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname ASC SORT BY dept, projname DESC
D. SELECT lastname, dept, projname, manager, startdate FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate FROM employee, project WHERE empno = mgrno) AS empproj ORDER BY lastname, dept, projname
Answer: D
Explanation:
Q172. 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:
Q173. Given the following two tables: TAB1
COL_1 COL_2
A 10 B 12 C 14
TAB2
COL_A COL_B
A 21 C 23 D 25
Assuming the following results are desired: COL_1 COL_2 COL_A COL_B A 10 A 21 B 12 --C 14 C 23 --D 25
Which of the following joins will produce the desired results?
A. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_a
B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_a
C. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_a
D. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a
Answer: D
Explanation:
Improved C2090-730 torrent:
Q174. Which two of the following privileges is required in order to use a package?
A. BINDADD
B. BIND
C. CONNECT
D. EXECUTE
E. USE
Answer: C,D
Explanation:
Q175. Given the following table:
TAB1
COL1 COL2
A 10 B 20 C 30 D 40 E 50
And the following SQL statements:
DECLARE c1 CURSOR WITH HOLD FOR
SELECT * FROM tab1 ORDER BY col_1; OPEN c1; FETCH c1; FETCH c1; FETCH c1; COMMIT; FETCH c1; CLOSE c1; FETCH c1;
Which of the following is the last value obtained for COL_2?
A. 20
B. 30
C. 40
D. 50
Answer: C
Explanation:
Q176. A user invoking a user-defined function requires which DB2 privilege?
A. CALL
B. USAGE
C. EXECUTE
D. REFERENCES
Answer: C
Explanation:
Simulation C2090-730 pack:
Q177. Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20) SALARY DECIMAL(10,2) PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?
A. INSERT INTO current_employees (empid) VALUES (10)
B. INSERT INTO current_employees VALUES (10, ‘JAGGER’, 85000.00)
C. INSERT INTO current_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20
D. INSERT INTO current_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
Answer: D
Explanation:
Q178. User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?
A. DELETE privilege on the table
B. DELETE privilege on the alias
C. DELETE privilege on the alias; REFERENCES privilege on the table
D. REFERENCES privilege on the alias; DELETE privilege on the table
Answer: A
Explanation:
Q179. Given the following two tables:
TAB1
C1 C2
1 Antarctica
2 Africa
3 Asia
4 Australia
TAB2
CX CY 5 Europe 6 North America 7 South America
Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?
A. INSERT INTO tab1 SELECT cx, cy FROM tab2
B. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C. INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
Answer: A
Explanation:
Q180. A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?
A. CALL privilege on the procedure; SELECT privilege on the table
B. CALL privilege on the procedure; REFERENCES privilege on the table
C. EXECUTE privilege on the procedure; SELECT privilege on the table
D. EXECUTE privilege on the procedure; REFERENCES privilege on the table
Answer: C
Explanation: