Free IBM C2090-616 Practice Test & Real Exam Questions
Which of the following is TRUE regarding user switching in a trusted context?
Correct Answer: A
Vote an answer
Which of the following editions of DB2 include support for Federation with Oracle database?
Correct Answer: D
Vote an answer
What is the maximum precision for the DECIMAL data type?
Correct Answer: D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
What is the primary use case for creating an index with the RANDOM option on a table?
Correct Answer: B
Vote an answer
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
Correct Answer: B
Vote an answer
Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT='NPS'
Correct Answer: C,D
Vote an answer
A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?
Correct Answer: B
Vote an answer
