Posted on

IBM Cloud Certification C2090-611 Free Online Test

Cloud-exams would like to share IBM Cloud Certification C2090-611 free online test. Currently, DB2 10.1 DBA for Linux UNIX and Windows C2090-611 exam online test only provide 20 questions. Answer one question correctly, you can get 5 points. The content of these questions are the latest C2090-611 exam questions. Please feel free to test your skill level.

If you have some opinions or suggestions about our C2090-611 exam online test, please leave your message, we will improve it step by step.

Now, begin to test:

1. Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

 
 
 
 

2. Which of the following table types is NOT supported by the load utility?

 
 
 
 

3. Which statement is correct for a user who holds SECADM authority?

 
 
 
 

4. What authorization is needed to execute the CREATE MASK statement?

 
 
 
 

5. Which statement regarding SECADM authority is true?

 
 
 
 

6. Which authority is required to revoke SECADM authority?

 
 
 
 

7. Which authorities can be audited with the AUDIT statement?

 
 
 
 

8. Which statement is correct when describing trusted contexts?

 
 
 
 

9. Where are column mask definitions stored?

 
 
 
 

10. What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

 
 
 
 
 

11. If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive)
Which statement is true?

 
 
 
 

12. In IBM Data Studio, where can you schedule script-based jobs?

 
 
 
 

13. What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

 
 
 
 

14. What is the MAX_LOG database configuration parameter used for?

 
 
 
 

15. Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

 
 
 
 

16. What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

 
 
 
 

17. Which command can be used to restore a corrupted database using only the recovery history file?

 
 
 
 

18. You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?

 
 
 
 

19. If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored.?

 
 
 
 

20. Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a “bad page”. DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1.
What command can be used to recover the database and repair the corruption in table space TBSP_1?

 
 
 
 

Question 1 of 20