Best Quality of C2090-730 answers materials and faq for IBM certification for IT learners, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 Apr C2090-730 Study Guide Questions:
Q181. Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?
A. DB2 Enterprise Server Edition
B. DB2 Personal Developer's Edition
C. DB2 Universal Developer's Edition
D. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition
Answer: C
Explanation:
Q182. A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority issues the following statement:
GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
A. GRANT INSERT ON t.table1 TO user2
B. GRANT CONTROL ON v.view1 TO user2
C. GRANT ALL PRIVILEGES ON v.view1 TO user2
D. GRANT INSERT ON v.view1 TO user2
Answer: D
Explanation:
Q183. Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?
A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
Answer: B
Explanation:
Avant-garde C2090-730 free question:
Q184. The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT
101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11
The MANAGER table contains the following information:
MGRID NAME DEPTNO EMPCOUNT
1 WU B01 -2 JONES A11 -3 CHEN - -4 SMITH - -5 THOMAS C12 -
After this statement is executed:
UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE
workdept=m.deptno)
What is the result of the following query?
SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid
A. MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1
B. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1
C. MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3
D. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
Answer: B
Explanation:
Q185. The following statements:
CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY (col1));
CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE CASCADE ON UPDATE RESTRICT);
CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE NO ACTION ON UPDATE RESTRICT);
INSERT INTO t1 VALUES (1), (2);
INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c');
INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);
How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1 = 1;
A. 4
B. 3
C. 1
D. 0
Answer: D
Explanation:
Q186. Which of the following database objects is considered executable using SQL?
A. View
B. Table
C. Routine
D. Package
Answer: C
Explanation:
Vivid C2090-730 free demo:
Q187. Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country?
A. PHONECHAR(15)
B. PHONEVARCHAR(15)
C. PHONELONG VARCHAR
D. PHONECLOB(1K)
Answer: A
Explanation:
Q188. A stored procedure object is created into which DB2 object?
A. Alias
B. Schema
C. Package
D. Routine Space
Answer: B
Explanation:
Q189. Which of the following statements is used to grant user TOM and
Application team APPGRP the ability to add data to table TAB1?
A. GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B. GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D. GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
Answer: C
Explanation:
Q190. An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
A. The application must release the row-level Share lock it holds and acquire an Update lock on the row
B. The application must release the row-level Share lock it holds and acquire an Update lock on the table
C. The row-level Share lock will automatically be converted to a row-level Update lock
D. The row-level Share lock will automatically be escalated to a table-level Update lock
Answer: C
Explanation: