Cause all that matters here is passing the IBM C2090-611 exam. Cause all that you need is a high score of C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows exam. The only one thing you need to do is downloading Actualtests C2090-611 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-611-exam-dumps.html
Q21. Which statement about triggers is FALSE?
A. A statement-level trigger fires only once for each SQL statement.
B. A trigger's code block can be executed either before or after a triggering event.
C. A row-level trigger fires once for each row that is affected by a triggering event.
D. A table-level trigger fires once for each table that is affected by a triggering event.
Answer: D
Q22. A table named CUSTOMER and an index named CUST_IDX were created as follows:
Which operation would you expect to see in the access plan diagram produced?
A. NLJOIN
B. HSJOIN
C. IXSCAN
D. TBSCAN
Answer: C
Q23. If the following statements are executed in the order shown:
Which statement is true?
A. Insert, update, and delete operations can be performed against table TAB2.
B. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.
C. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.
D. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.
Answer: C
Q24. Which statement about adaptive compression is true?
A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.
B. You can specify that tables be compressed by using either a table-level dictionary only, pagelevel dictionaries only, or both table-level andpage-level dictionaries.
C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.
D. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.
Answer: A
Q25. What is an informational constraint?
A. A constraint that defines a relationship to a federated object.
B. A constraint that is used by the optimizer but is not enforced.
C. A constraint that provides Information to the RUNSTATS utility.
D. A constraint that is created from information supplied to the design advisor.
Answer: B
Q26. Which table space is NOT created by default when the CREATE DATABASE command is executed?
A. USERSPACE1
B. TEMPSPACE1
C. SYSCATSPACE
D. SYSTOOLSSPACE
Answer: D
Q27. A user with SYSADM authority executes the following commands at host SERVER1:
Assuming the user ADMINISTRATOR exists, what could be causing the problem?
A. The password for user ADMINISTRATOR is missing.
B. The userid should not be longer than eight characters.
C. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.
D. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.
Answer: D
Q28. Which tool should be used to collect data during a potential hang without stopping the database manager?
A. db2ls
B. db2dart
C. db2fodc
D. db2cklog
Answer: C
Q29. Which is the suggested way to restore a database with a subset of its original table spaces?
A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES
IN IMAGE option and specify the set of table spacesthat are needed.
D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES
IN DATABASE option and specify the set of tablespaces that are needed.
Answer: A
Q30. Which tool should be used to give you lock wait information from the DB2 memory sets?
A. db2pd
B. db2mtrk
C. db2fodc
D. db2support
Answer: A