Prepare these C2090-730 dumps and pass your exam. C2090-730 practice exam questions answers are collected from real paper. Keep visiting for C2090-730 study material or C2090-730 dumps.
Q151. 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: Q152. Which of the following will allow user USER1 to change the comment associated with a table named TABLE1? A. GRANT UPDATE ON TABLE table1 TO user1 B. GRANT CONTROL ON TABLE table1 TO user1 C. GRANT ALTER ON TABLE table1 TO use
Q141. Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them? A. REVOKE DROP ON t1 FROM PUBLIC B. REVOKE UPDATE ON t1 FROM PUBLIC C. REVOKE DELETE ON t1 FROM PUBLIC D. REVOKE CONTROL ON t1 FROM PUBLIC Answer: C Explanation: Q142. Given the following two tables: TAB1 C1
Q131. 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: Q132
Q121. A stored procedure has been created with the following statement: CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER) SPECIFIC myproc LANGUAGE SQL … What is the correct way to invoke this procedure from the command line processor (CLP)? A. CALL proc1 ('SALES', ?) B. CALL myproc ('SALES', ?) C. CALL proc1 (SALES, ?) D. RUN proc1 (SALES, ?) Answer: A Explana
Q21. 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 ye
Q51. 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: Q52. Given the following t
Q41. Which of the following DB2 data types CANNOT be used to create an identity column? A. SMALLINT B. INTEGER C. NUMERIC D. DOUBLE Answer: D Explanation: Q42. Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table? A. Define a UNIQUE constraint on t
Q31. On which of the following database objects may the SELECT privilege be controlled? A. Sequence B. Schema C. Group D. View Answer: D Explanation: Q32. Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them? A. REVOKE DROP ON t1 FROM PUBLIC B. REVOKE UPDATE ON t1 FRO
Q61. 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 i
Q1. Given the following table definition: EMPLOYESS EMP ID INTEGER NAME CHAR(20) DEPT CHAR(10) SALARY DECIMAL (10, 2) COMMISSION DECIMAL (8, 2) Assuming the DEPT column contains the values ‘ADMIN’, ‘PRODUCTION’, and ‘SALES’, which of the following statements will produce a result data set in which all ADMIN department employees are grouped together, all PRODUCTION department em
Q91. Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur? A. Applications A and B will cause a deadlock situation. B. Application B will read the previous version of the row. C. Application B will read the row and see uncommi
Q131. Which of the following is true of an index used to support a UNIQUE constraint? A. It must have the UNIQUE attribute. B. It cannot be created explicitly by the user. C. It must have the UNIQUE and CLUSTER attributes. D. It must have the UNIQUE WHERE NOT NULL attribute. Answer: A Explanation: Q132. A view is created with the following statement: CREATE VIEW v1 AS SELECT col1, col2,
Q151. Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1? A. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1 B. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1 C. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 T
Q111. Which of the following provides a logical grouping of database objects? A. View B. Table C. Schema D. Buffer pool Answer: C Explanation: Q112. An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended.
Q101. Given the following table and XML data stored in the CONTACTINFO column: CREATE TABLE clients( id INT PRIMARY KEY NOT NULL, name VARCHAR(50), status VARCHAR(10), contactinfo XML) <Client> <Address> <street>25 EastCreek</street> <city>Toronto</city> <prov-state>Ontario</prov-state> <pcode-zip>M8X-3T6</pcode-zip> </Add
Q161. Which of the following best describes the lock protection provided by DB2 for the current row of a cursor? A. The cursor is only protected from updates and deletes by concurrent applications. B. The row is only protected from positioned updates and deletes that reference another cursor of the same application. C. The cursor is protected from positioned updates and deletes that reference