Actual of C2090-610 exam answers materials and practice for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-610 pdf dumps vce Materials. 100% PASS DB2 10.1 Fundamentals exam Today!
2021 May C2090-610 Study Guide Questions:
Q31. Which statement about triggers is true?
A. A trigger is designed to return specific types of values and contains executable code.
B. A trigger is designed to return specific types of values but contains no executable code.
C. A trigger performs actions to capture details about an activity like a join operation against multiple tables.
D. A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.
Answer: D
Explanation:
Q32. Which database object provides an alternative way of describing data that exists in one or more base tables?
A. Alias
B. View
C. Index
D. Sequence
Answer: B
Explanation:
Q33. Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT salary FROM employee WHERE salary > 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT * FROM employee WHERE salary GREATER THAN 100000
Answer: B
Explanation:
Improve C2090-610 vce:
Q34. 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:
Q35. Which statement about a deadlock is true?
A. The victim will be rolled back.
B. The victim will read through the lock.
C. Both victim and holder are rolled back.
D. The victim must wait until the holder releases the lock.
Answer: A
Explanation:
Q36. What is used in conjunction with a foreign key to define a relationship between two tables?
A. Primary key
B. Partitioning key
C. Check constraint
D. Unique constraint
Answer: A
Explanation:
Realistic C2090-610 resource:
Q37. What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?
A. Trigger
B. Procedure
C. Table function
D. Scalar function
Answer: A
Explanation:
Q38. Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
A. XMLTABLE
B. XMLPARSE
C. XMLEXISTS
D. XMLATTRIBUTES
Answer: A
Explanation:
Q39. Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?
A. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000
B. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000
C. SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000
D. SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000
Answer: B
Explanation:
Q40. Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?
A. DB2 Connect
B. DB2 pureScale
C. Workload Manager
D. High Availability Disaster Recovery
Answer: B
Explanation: