Realistic of C2090-614 exam topics materials and braindump for IBM certification for IT engineers, Real Success Guaranteed with Updated C2090-614 pdf dumps vce Materials. 100% PASS DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam Today!
2021 May C2090-614 Study Guide Questions:
Q21. Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
A. db2dart
B. A snapshot monitor
C. A statement event monitor
D. The MON_GET_UNIT_OF_WORK_DETAILS table function
Answer: C
Q22. Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?
A. EXPLAIN_FROM_DATA
B. EXPLAIN_FROM_ACTIVITY
C. EXPLAIN_FROM_SECTION
D. EXPLAIN_FROM_CATALOG
Answer: C
Q23. If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?
A. The audit facility writes records to disk at the same time the statements generating the audit records are executing.
B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.
C. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
Answer: B
Up to date C2090-614 real exam:
Q24. Which operation can be performed by executing an ALTER STOGROUP statement?
A. Change the name of an existing storage group.
B. Make an existing storage group the default storage group.
C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.
D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.
Answer: B
Q25. Which statement about SMS table spaces is correct?
A. The system catalog cannot be stored in an SMS table space.
B. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
D. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.
Answer: C
Q26. A table named SALES was created as follows:
Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?
A. ALTER TABLE sales ADD PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
B. ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013')
FROM TABLE q12013_sales;
C. ALTER TABLE sales ADD PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
D. ALTER TABLE sales ATTACH PARTITION part_2013q1
STARTING ('01/01/2013') ENDING ('03/31/2013')
FROM TABLE q12013_sales;
SET INTEGRITY FOR sales IMMEDIATE CHECKED;
Answer: D
Pinpoint C2090-614 training tools:
Q27. Which statement about partitioned indexes is FALSE?
A. Both system- and user-generated indexes can be partitioned.
B. Each index partition contains references only to data in its corresponding data partition.
C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition
D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.
Answer: D
Q28. Which category must be enabled before db2audit will record the creation of new buffer pools?
A. OBJMAINT
B. SECMAINT
C. CHECKING
D. OBJCREATE
Answer: A
Q29. Which command will be executed successfully on every database partition if db2_all is used?
A. CONNECT
B. FORCE APPLICATION
C. RESTART DATABASE
D. ACTIVATE DATABASE
Answer: C
Q30. What type of file system is used to store data and logs in a DB2 pureScale environment?
A. Network File System (NFS)
B. General Parallel File System (GPFS)
C. Common Internet File System (CIFS)
D. Enhanced Journaled File System (JFS2 or EXT4)
Answer: B