Download DB2 11.1 Fundamentals for LUW.C2090-616.ExamTopics.2025-05-13.49q.vcex

Vendor: IBM
Exam Code: C2090-616
Exam Name: DB2 11.1 Fundamentals for LUW
Date: May 13, 2025
File Size: 30 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator
ProfExam Discount

Demo Questions

Question 1
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year.
Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?
  1. DB2 Express-C
  2. DB2 Enterprise Server Edition
  3. DB2 Workgroup Server Edition
  4. DB2 Advanced Enterprise Server Edition D
Correct answer: Explanation
Question 2
Which edition of DB2 LUW has been discontinued in v11.1?
  1. DB2 Developer Edition
  2. DB2 Express Server Edition
  3. DB2 Enterprise Server Edition
  4. DB2 Connect Enterprise Server Edition
Correct answer: B
Question 3
Which of the following statements about triggers are TRUE? (Choose two.)
  1. There is a limit of 8 for the maximum number of cascading trigger activations
  2. Triggers can be activated as a result of changes due to referential constraint enforcement
  3. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
  4. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
  5. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time
Correct answer: BD
Question 4
Which of the following is TRUE about indexes on column organized tables?
  1. No indexes are allowed
  2. Indexes are only allowed on numeric columns
  3. Indexes are automatically created to enforce unique constraints
  4. An index is only allowed on the synopsis table supporting a column organized table
Correct answer: A
Question 5
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
  1. db2look with the ""x option
  2. db2pd with the ""auth option
  3. Query the SYSCAT.DBAUTH view
  4. Query the SYSCAT.TABLES view
  5. Query the SYSCAT.TABAUTH view CE
Correct answer: Explanation
Question 6
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 7
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
Question 8
BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
  1. Direct Standard Edition
  2. Enterprise Server Edition
  3. Workgroup Server Edition
  4. DB2 Direct Advanced Edition
  5. Advanced Enterprise Server Edition
Correct answer: BC
Question 9
Which of the following authorities are sufficient for creating a database? (Choose two.)
  1. DBADM
  2. SYSADM
  3. SECADM
  4. SYSCTRL
  5. SYSMAINT
Correct answer: BD
Question 10
Which of the following editions of DB2 include support for Federation with Oracle database?
  1. DB2 Express-C
  2. DB2 Developer Edition
  3. DB2 Enterprise Server Edition
  4. DB2 Workgroup Server Edition
Correct answer: C
Question 11
Which operation typically requires a Share (S) lock?
  1. INSERT
  2. SELECT
  3. DELETE
  4. UPDATE
Correct answer: D
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!