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:
Q41. Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
A. GRANT ALTER ON SEQUENCE myseq TO user1
B. GRANT USAGE ON SEQUENCE myseq TO user1
C. GRANT SELECT ON SEQUENCE myseq TO user1
D. GRANT COMMENT ON SEQUENCE myseq TO user1
Answer: A
Explanation:
Q42. Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?
A. Base Table
B. Temporal Table
C. Transition Table
D. Temporary Table
Answer: D
Explanation:
Q43. 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:
Leading C2090-610 exam cram:
Q44. After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?
A. BIND
B. REBIND
C. BINDADD
D. BIND_REBIND
Answer: A
Explanation:
Q45. A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?
A. DBCTRL authority
B. SQLADM authority
C. DATAACCESS authority
D. ACCESSCTRL authority
Answer: C
Explanation:
Q46. Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job;
B. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;
C. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);
D. SELECT JOB, MIN(salary), MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary);
Answer: A
Explanation:
Simulation C2090-610 resource:
Q47. When is a mask used to limit access to data in a table?
A. When mandatory access control (MAC) is used to protect the table.
B. When discretionary access control (DAC) is used to protect the table.
C. When label-based access control (LBAC) is used to protect the table.
D. When row and column access control (RCAC) is used to protect the table.
Answer: D
Explanation:
Q48. In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?
A. Locked
B. Waiting
C. Pending
D. Unconnected
Answer: D
Explanation:
Q49. Which data type should be used to store data in a column that represents money and accurately returns a two position scale?
A. BIGINT
B. BINARY
C. DOUBLE
D. DECIMAL
Answer: D
Explanation:
Q50. Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?
A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job
ORDER BY job;
B. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;
C. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY SALARY
ORDER BY job;
D. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY MIN(salary), MAX(salary)
ORDER BY job;
Answer: A
Explanation: