Act now and download your IBM C2090-610 test today! Do not waste time for the worthless IBM C2090-610 tutorials. Download Refresh IBM DB2 10.1 Fundamentals exam with real questions and answers and begin to learn IBM C2090-610 with a classic professional.
♥♥ 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
Q41. Which of the following privileges allow a user to update the comment on a sequence?
A. ALTER
B. USAGE
C. UPDATE
D. COMMENT
Answer: A
Explanation:
Q42. A table named EMPLOYEES was created as follows:
What will be the results?
A. 0
B. 1
C. 2
D. 3
Answer: C
Explanation:
Q43. 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:
Q44. 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:
Q45. Which statement is true regarding constraints?
A. A table can only have one unique key constraint.
B. A table can have multiple primary key constraints.
C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.
D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.
Answer: C
Explanation:
Q46. 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:
Q47. What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?
A. Oracle connect
B. Trusted context
C. Oracle federation
D. Distributed request
Answer: D
Explanation:
Q48. Which DB2 product is NOT suitable for very large data warehouse applications?
A. DB2 for i
B. DB2 for AIX
C. DB2 for z/OS
D. DB2 for Linux
Answer: A
Explanation:
Q49. Which command will delete all rows from a table without generating log records?
A. TRIM
B. DROP
C. DELETE
D. TRUNCATE
Answer: D
Explanation:
Q50. A table named EMPLOYEE was created as follows:
Which action will prevent unauthorized users from accessing SSN data?
A. Assign the SSN column to a restricted role that only authorized users can access.
B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.
D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.
Answer: D
Explanation: