C2090-616 Sample Questions & Answers
Product knowledge and workload planning take the lead, close to SQL data manipulation, alongside creating databases and database objects, restricting data access through security and privileges, working with tables, views and indexes, and locking and isolation levels.
Launch the full C2090-616 simulator →Showing 10 of 20 free samples.
- Question 1
Which of the following authorities is sufficient for connecting to a database?
Show answer & explanation
Correct answer: B
B
- Question 2Select 2
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
Show answer & explanation
Correct answers: B, C
- Question 3
Which of the following statements about stored procedures is TRUE?
Show answer & explanation
Correct answer: B
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG 10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html
- Question 4Select 2
Which of the following authorities are sufficient for creating a database? (Choose two.)
Show answer & explanation
Correct answers: B, D
B, D -- Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPGG 11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
B, D -- Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPGG 11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
- Question 5
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?
Show answer & explanation
Correct answer: C
Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPEK 10.0.0/sqlref/src/tpc/db2z sql rollback.html
- Question 6Select 2
DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)
Show answer & explanation
Correct answers: A, B
- Question 7
Which method for restricting data access relies on security labels and security policies to control what data a user can access?
Show answer & explanation
Correct answer: C
Explanation:
www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.1 uw. ad min. sec. doc/doc') Reference
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.1 uw. ad min. sec. doc/doc/c0021114.html
- Question 8
Which of the following set operators can be used to find all rows that are common in 2 queries?
Show answer & explanation
Correct answer: D
D
- Question 9
A user executes the following statements:
CREATE TABLE t1 (d INT, c2 INT);
CREATE ALIAS a1 FORtl;What will be the result if the user executes the following statement?
DROP ALIAS a1;
Show answer & explanation
Correct answer: A
A
- Question 10
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
Show answer & explanation
Correct answer: C
Reference: https://www.ibm.eom/support/knowledgecenter/en/SSEPGG 10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0004121.html
Ready for the real thing?
The full C2090-616 simulator has every exam-style question, timed mode, and instant scoring.