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:
Q71. 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:
Q72. Which statement is true about an index that is used to support a UNIQUE constraint?
A. It must not contain more than one column.
B. It cannot be used in a referential constraint.
C. It must be defined with the UNIQUE attribute.
D. It must be defined as UNIQUE WHERE NOT NULL.
Answer: C
Explanation:
Q73. Which DB2 object can be used to improve the execution performance of qualified SELECT statements?
A. Trigger
B. SQL Procedure
C. Sequence Object
D. Materialized Query Table
Answer: D
Explanation:
Renewal C2090-610 vce:
Q74. 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
Q75. Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?
A. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2
B. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2
C. SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2
D. SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2
Answer: D
Explanation:
Q76. Which is NOT a valid reason for creating an index?
A. To allow queries to run more efficiently.
B. To enforce constraints such as uniqueness on index keys.
C. To order the columns of a table in ascending or descending sequence according to values in a row.
D. To order the rows of a table in ascending or descending sequence according to the values in a column.
Answer: C
Explanation:
Actual C2090-610 keys:
Q77. When an index is created for a table, where is the metadata for that index stored?
A. In the table definition.
B. In the system catalog.
C. In the schema that the index resides in.
D. In the metadata of the table the index was created for.
Answer: B
Explanation:
Q78. When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?
A. The data in the table is deleted and the table persists.
B. The data in the table is deleted and the table is implicitly dropped.
C. The temporary table is converted to a base table and the data is deleted.
D. The temporary table is converted to a base table and the data is persistent.
Answer: B
Explanation:
Q79. Which type of temporal table can be used to store only time-sensitive data?
A. Bitemporal
B. Time-period
C. System-period
D. Application-period
Answer: D
Explanation:
Q80. What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
A. Read stability (RS)
B. Cursor stability (CS)
C. Repeatable read (RR)
D. Uncommitted read (UR)
Answer: C
Explanation: