IBM C2090-600 Online Practice Questions and Exam Preparation

IBM C2090-600 Online Questions & Answers

• Question 1:

  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.
  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.

• Question 2:

  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
  D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

• Question 3:

  Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

  A. Select from the ADMIN_GET_ENCRYPTION_INFO table function
  B. Run the db2ckbkp command and verify the compression settings
  C. Checkthe encrypted database parameter in database configuration
  D. Check ENCROPTS database configuration parameter for encryption options
  D. Check ENCROPTS database configuration parameter for encryption options

• Question 4:

  Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

  A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
  B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
  C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
  D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC
  C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

• Question 5:

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

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

• Question 6:

  Given the following:

  

  What will be the result of the following SQL statement?

  INSERT INTO v3 (col1) values (30);

  A. The insert will succeed as it passes validation.
  B. The insert will succeed as there is no WITH CHECK OPTION on view V3.
  C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
  D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.
  C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

• Question 7:

  When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

  A. The PAGESIZE database configuration parameter is set to 32K.
  B. The AUTO_REORG database configurationparameter is set to NO.
  C. The DFT_EXTENT_SZ database configuration parameter is set to 8.
  D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
  E. The INTRA_PARALLEL database manager configuration parameter is set to NO.
  D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
  E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

• Question 8:

  What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

  A. NONE
  B. LOCAL
  C. DOMAIN
  D. GLOBAL
  D. GLOBAL

• Question 9:

  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 dump db2trc.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
  B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

• Question 10:

  What is the result of the following scenario?

  

  A. The row is updated to (2, NULL)
  B. The row is updated to (2, 110.00)
  C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
  D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL
  B. The row is updated to (2, 110.00)