It is more faster and easier to pass the IBM C2090-610 exam by using Accurate IBM DB2 10.1 Fundamentals questuins and answers. Immediate access to the Improved C2090-610 Exam and find the same core area C2090-610 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 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
Q11. User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?
A. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE CASCADE rule.
B. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE CASCADE rule.
C. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE RESTRICT rule.
D. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE RESTRICT rule.
Answer: A
Explanation:
Q12. Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?
A. CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
C. CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
D. CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
Answer: B
Explanation:
Q13. What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?
A. Lock escalation
B. Lock substitution
C. Lock switch/exchange
D. Lock conversion/promotion
Answer: D
Explanation:
Q14. Which tool allows users to connect to a DB2 database using a wizard?
A. Control Center
B. IBM Data Studio
C. Universal Connection Expert
D. DB2 Connection Pool Manager
Answer: B
Explanation:
Q15. A table named EMPLOYEES was created as follows:
What will be the results?
A. 0
B. 1
C. 2
D. 3
Answer: C
Explanation:
Q16. Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
A. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id
B. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id
C. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id
D. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id
Answer: D
Explanation:
Q17. What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?
A. To override the limit on index key columns.
B. To further enforce the uniqueness of index values.
C. To combine two or more indexes to create a single unique index.
D. To improve performance of some queries by allowing index-only access.
Answer: D
Explanation:
Q18. An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:
How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_INFO?
A. CALL conv_temp(climate_info.avg_temp);
B. CALL convert_ftoc(climate_info.avg_temp);
C. SELECT conv_temp(avg_temp) FROM climate_info;
D. SELECT convert_ftoc(avg_temp) FROM climate_info;
Answer: C
Explanation:
Q19. Which object is used to cache table and index data as it is read from disk?
A. Database
B. Buffer pool
C. Table space
D. Package cache
Answer: B
Explanation:
Q20. By default, where is the data stored for a column defined with an XML data type?
A. In an XML index.
B. In line with the rest of the data for the table.
C. In an XML storage object that is separate from the table.
D. In line with the rest of the data for the table, for XML columns less than 32KB.
Answer: C
Explanation: