Top Tips Of Down To Date C2090-600 Samples

NEW QUESTION 1
If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: D

NEW QUESTION 2
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

• A. The page size is too small.
• B. The extent size is too small.
• C. Low cardinality of the dimension(s) chosen.
• D. High cardinality of the dimension(s) chosen.

Answer: D

NEW QUESTION 3
What levels of authority are needed to create a storage group? (Choose two.)

• A. DBADM
• B. SYSADM
• C. SQLADM
• D. SYSCTRL
• E. SYSMAINT

Answer: BD

NEW QUESTION 4
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

• A. XML
• B. REAL
• C. NUMBER
• D. VRCHAR2
• E. VARBINARY

Answer: CE

NEW QUESTION 5
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

• A. db2val
• B. db2set
• C. db2look
• D. db2greg

Answer: B

NEW QUESTION 6
An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?

• A. SYNC
• B. ASYNC
• C. NEARSYNC
• D. SUPERASYNC

Answer: D

NEW QUESTION 7
Which operation can be performed with trusted context privileges that are acquired through a role?

• A. DML operations
• B. DDL operations
• C. Server maintenance operations
• D. Security administration operations

Answer: A

NEW QUESTION 8
Which of the following are all valid types of trigger?

• A. AFTER, ATOMIC, BEFORE
• B. AFTER, ATOMIC, INSTEAD OF
• C. AFTER, BEFORE, INSTEAD OF
• D. ATOMIC, BEFORE, INSTEAD OF

Answer: C

NEW QUESTION 9
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

• A. As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000
• B. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000
• C. As the db2 instance owner (db2inst1) execute the command:db2set –i DB2_FMP_COMM_HEAPSZ=256000
• D. As the db2 instance owner (db2inst1)execute the command:db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Answer: C

NEW QUESTION 10
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

• A. To prunethe contents of a staging table.
• B. To prune the contents of a synopsis table.
• C. To prune the contents of a materialized query table (MQT).
• D. To prune the contents of a declared global temporary table.

Answer: A

NEW QUESTION 11
Which statement about Data Server Manager (DSM) is TRUE?

• A. DSM can be used for reviewing audit trails
• B. DSM cannot be used for database administration
• C. DSM can be used for configuration management of DB2 Data Server drivers
• D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Answer: D

NEW QUESTION 12
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

• A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
• B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;
• C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
• D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer: A

NEW QUESTION 13
Which of the following statements about compression for BLU MPP tables is TRUE?

• A. Compression must be explicitly enabled for BLU MPP tables
• B. Compression requires decompression to evaluate partition joins
• C. Unique compression dictionaries are generated for each partition
• D. Each table has a single compression dictionary that getsreplicated across all partitions

Answer: D

NEW QUESTION 14
What does dsmtop use to gather metrics?

• A. db2pd
• B. db2dart
• C. the system catalog
• D. monitoring tablefunctions

Answer: D

NEW QUESTION 15
Where does the DB2 Problem Determination tool (db2pd) get information from?

• A. DB2memory sets
• B. the db2diag.log file
• C. Monitoring table functions
• D. A set of pre-defined event monitors

Answer: A

NEW QUESTION 16
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

• A. It does not acquire locks on the table
• B. It does not require additional temporary disk space
• C. It enables the user to control when the table will be offline
• D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Answer: D

NEW QUESTION 17
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

• A. CONNECT TO mydbPRUNE HISTORY TO /outdir
• B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dumpdb2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
• C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>

Answer: B

NEW QUESTION 18
Which of the following statements is TRUE?

• A. REORGCHK automatically runstables reorganization.
• B. REORGCHK uses only current table and index statistics.
• C. REORGCHK can only be used for user tables, not for system tables.
• D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

Answer: B

NEW QUESTION 19
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON ‘/data1’;
CREATE STOGROUP ibmstogroup ON ‘/data2’; CREATE STOGROUP sg2 ON ‘/data3’;
Which storage group is the default storage group for the TESTDB database?

• A. SG1
• B. SG2
• C. IBMSTOGROUP
• D. IBMDEFAULTTSG

Answer: C

NEW QUESTION 20
What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

• A. SYSIBM
• B. SYSFUN
• C. SYSCAT
• D. SYSIBMADM

Answer: A

NEW QUESTION 21
Which of the following statements about audit policies is TRUE?

• A. Audit policy changes are applied instantly and affect all inflight transactions.
• B. Multiple audit policies can be associated with the same table at the same time.
• C. The audit policy applied to a table is automatically applied to any view based on that table.
• D. If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.

Answer: D

NEW QUESTION 22
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

• A. UPDATE DB CFG USING MON_OBJ_METRICS BASE
• B. UPDATE DB CFG USING MON_ACT_METRICS BASE
• C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
• D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Answer: C

NEW QUESTION 23
......