Exam Code: C2090-610 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 Fundamentals
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-610 Exam.
2021 May C2090-610 Study Guide Questions:
Q61. A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?
A. SELECT state_cd, COUNT(*)
FROM states
ORDER BY COUNT(*);
B. SELECT state_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY state_cd;
C. SELECT region_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY COUNT(*);
D. SELECT region_cd, COUNT(*)
FROM states
GROUP BY region_cd
ORDER BY COUNT(*);
Answer: D
Explanation:
Q62. 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:
Q63. 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:
Latest C2090-610 study guide:
Q64. You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?
A. CLI
B. XML
C. JDBC
D. RUBY
Answer: C
Explanation:
Q65. A table named DEPARTMENT contains the following data:
What will happen?
A. The statement will fail because a subquery cannot be used in an UPDATE statement.
B. The statement will fail because the result set produced by the subquery will contain more than one row.
C. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
D. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
Answer: B
Explanation:
Q66. Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;
Which statement is correct?
A. USER1 can only remove the SALES table.
B. USER1 can only remove records from the SALES table.
C. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.
Answer: D
Explanation:
Guaranteed C2090-610 questions:
Q67. If no isolation level is specified, what is the default isolation level used?
A. Cursor Stability (CS)
B. Repeatable Read (RR)
C. Read Stability (RS) with Currently Committed semantics
D. Cursor Stability (CS) with Currently Committed semantics
Answer: A
Explanation:
Q68. What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?
A. Lock exchange
B. Lock promotion
C. Lock escalation
D. Lock conversion
Answer: C
Explanation:
Q69. 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:
Q70. Which action needs to be performed in order to complete the definition of an application-period temporal table?
A. A transaction-start-id column must be defined for the table.
B. A history table must be defined and associated with the base table.
C. A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
D. A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.
Answer: C
Explanation: