File Info
| Exam | DB2 11.1 Fundamentals for LUW |
| Number | C2090-616 |
| File Name | IBM.C2090-616.TestKing.2018-08-30.37q.tqb |
| Size | 175 KB |
| Posted | Aug 30, 2018 |
| Download | IBM.C2090-616.TestKing.2018-08-30.37q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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;
- This statement will succeed and DB2 INST3 will still be able to create in the database
- This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
- This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
- 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?
- Jeff’s SELECT privilege will be revoked
- Jeff’s SELECT privilege will be retained
- Jeff’s SELECT privilege will be retained only if he has ACCESSCTRL authority
- 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?
- Deadlock
- Lock timeout
- Lock escalation
- 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
