Want to know Ucertify C2090-610 Exam practice test features? Want to lear more about IBM DB2 10.1 Fundamentals certification experience? Study Precise IBM C2090-610 answers to Improved C2090-610 questions at Ucertify. Gat a success with an absolute guarantee to pass IBM C2090-610 (DB2 10.1 Fundamentals) test on your first attempt.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-610 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-610 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-610-exam-dumps.html

Q21. Which statement about roll back operations is correct? 

A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released. 

B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released. 

C. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released. 

D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held. 

Answer: A 

Explanation: 


Q22. Which DB2 object is used to provide a logical grouping of other database objects? 

A. Alias 

B. Index 

C. Schema 

D. Collection 

Answer: C 

Explanation: 


Q23. Which type of stored procedure is not associated with an external application program? 

A. A Java stored procedure. 

B. A REXX stored procedure. 

C. A native SQL stored procedure. 

D. An external SQL stored procedure. 

Answer: C 

Explanation: 


Q24. Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement? 

A. Change the data type of the sequence. 

B. Reset the sequence to its starting value. 

C. Establish new minimum or maximum values. 

D. Change the increment between future values. 

Answer: A 

Topic 2, Volume B 


Q25. Which statement about large object (LOB) locators is true? 

A. A LOB locator is a data type that is used to store LOB data in binary files. 

B. A LOB locator is a data type that is used to store LOB data in a database. 

C. A LOB locator represents a value for a LOB resource that is stored in a database. 

D. A LOB locator represents a value for a LOB resource that is stored in a binary file. 

Answer: C 

Explanation: 


Q26. What needs to be defined in order to track changes made to a system-period temporal table over time? 

A. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked. 

B. A history table must be created with identical columns to the base table and a unique index must be defined on the transaction-start-id column. 

C. A history table must be created as a clone table of the base table after the row-begin, row-end, and transaction-start-id columns have beendefined. 

D. A history table must be created with identical columns to the base table and then the base table altered with the ADD VERSIONING clause torelate it to the history table. 

Answer: D 

Explanation: 


Q27. The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following? 

A. Concurrent application processes from performing any operations on the table. 

B. Concurrent application processes from performing any read-only operations on the table. 

C. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable. 

D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table. 

Answer: A 

Explanation: 


Q28. An SQL function named DEPT_INFO was created as follows: 

What is the correct way to use this function in a query? 

A. SELECT dept_info(dept_id, dept_name) 

B. SELECT dept_id, dept_name FROM dept_info() 

C. SELECT TABLE dept_id, dept_name FROM dept_info() 

D. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results 

Answer: D 

Explanation: 


Q29. What are two valid objects that can be created in DB2? (Choose two.) 

A. Tree 

B. Node 

C. Trigger 

D. Contexts 

E. Sequence 

Answer: C,E 

Explanation: 


Q30. When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF? 

A. The SYSIBM schema. 

B. The SYSFUN schema. 

C. A schema with the name of the UDF. 

D. A schema with the userid of the UDF definer. 

Answer: D 

Explanation: