Download DB2 11.1 Fundamentals for LUW.C2090-616.TestKing.2018-08-30.37q.tqb

Vendor: IBM
Exam Code: C2090-616
Exam Name: DB2 11.1 Fundamentals for LUW
Date: Aug 30, 2018
File Size: 175 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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;
  1. This statement will succeed and DB2 INST3 will still be able to create in the database
  2. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
  3. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
  4. This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles
Correct answer: D
Question 2
Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike. 
Mike grants SELECT privilege to Jeff. 
Eddie revokes SELECT privilege from Mike. 
What will happen to Jeff’s SELECT privilege?
  1. Jeff’s SELECT privilege will be revoked
  2. Jeff’s SELECT privilege will be retained
  3. Jeff’s SELECT privilege will be retained only if he has ACCESSCTRL authority
  4. Jeff’s SELECT privilege will be retained only if Eddie has ACCESSCTRL authority
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0125.htm
Reference: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0125.htm
Question 3
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?
  1. Deadlock
  2. Lock timeout
  3. Lock escalation
  4. Lock conversion
Correct answer: A
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!