Our pass rate is high to 98.9% and the similarity percentage between our C2090-730 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the IBM C2090-730 exam in just one try? I am currently studying for the IBM C2090-730 exam. Latest IBM C2090-730 Test exam practice questions and answers, Try IBM C2090-730 Brain Dumps First.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-730-exam-dumps.html
Q11. 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:
Q12. Which of the following is true about XML columns?
A. XML columns are used to store XML documents as a hierarchical set of entities
B. Only XQuery can be used to retrieve an XML document from an XML column
C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
Answer: A
Explanation:
Q13. A user invoking a user-defined function requires which DB2 privilege?
A. CALL
B. USAGE
C. EXECUTE
D. REFERENCES
Answer: C
Explanation:
Q14. Which of the following tools can be used to automate table reorganization operations?
A. Control Center
B. Command Center
C. Command Line Processor
D. Task Center
Answer: D
Explanation:
Q15. If application A issues the following SQL statement, which of the following statements about concurrency is true?
SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = 'A00' FOR READ ONLY WITH RS
A. Rows accessed by application A can be seen by other applications.
B. Rows accessed by application A cannot be seen by other applications.
C. Application A can see uncommitted changes made by other applications.
D. Results produced by re-execution of the statement by application A will not be affected by other applications.
Answer: B
Explanation:
Q16. What does the following statement do?
GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH
GRANT OPTION
A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.
B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.
C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.
D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.
Answer: C
Explanation:
Q17. Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Answer: D
Explanation:
71. Which of the following privileges permits a user to update the comment on a sequence?
A. CONTROL
B. UPDATE
C. USAGE
D. ALTER
Answer: D
Explanation:
Q18. Which of the following actions will NOT cause a trigger to be fired?
A. INSERT
B. DELETE
C. ALTER
D. UPDATE
Answer: C
Explanation:
Q19. Which of the following is NOT a valid method of authentication that can be used by DB2 9?
A. SERVER
B. SERVER_ENCRYPT
C. CLIENT
D. DCS Answer: D
Explanation:
Q20. Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
A. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)
B. CREATE DISTINCT TYPE currency AS SMALLINT
C. CREATE DISTINCT TYPE currency AS BIGINT
D. CREATE DISTINCT TYPE currency AS DOUBLE
Answer: A
Explanation:
179. 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: