Download DB2 11.1 Fundamentals for LUW.C2090-616.TestKing.2018-08-30.37q.vcex
| Vendor: | IBM |
| Exam Code: | C2090-616 |
| Exam Name: | DB2 11.1 Fundamentals for LUW |
| Date: | Aug 30, 2018 |
| File Size: | 61 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
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
Question 4
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
- Direct Standard Edition
- Enterprise Server Edition
- Workgroup Server Edition
- DB2 Direct Advanced Edition
- Advanced Enterprise Server Edition
Correct answer: BC
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.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?
- COMMIT
- SAVEPOINT
- ROLLBACK WORK
- UPDATE TERMINATE
Correct answer: C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_rollback.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_rollback.html
Question 6
Which of the following authorities are sufficient for creating a database? (Choose two.)
- DBADM
- SYSADM
- SECADM
- SYSCTRL
- SYSMAINT
Correct answer: BD
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
Question 7
Which operation typically requires a Share (S) lock?
- INSERT
- SELECT
- DELETE
- UPDATE
Correct answer: D
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0509schuetz/index.html Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0509schuetz/index.html
Question 8
What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
RETURN SIN(X)/COS(X)
- Row
- Table
- Scalar
- External
Correct answer: C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createfuncinlinesqlscalar.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createfuncinlinesqlscalar.html
Question 9
What of the following is TRUE about triggers?
- Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
- Triggers can be used to perform data manipulation operations against complex views
- Triggers can only be used to execute logic before or after appropriate SQL statements
- Only one trigger for a particular event and activation time can be created for a particular table
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html
Question 10
What is the purpose of a role?
- To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
- To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
- To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles
- To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group
Correct answer: A
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!