IBM IBM Certifications C2090-600 Questions & Answers

• Question 1:

  Which statement about NOT ENFORCED unique constraints is TRUE?

  A. NOT ENFORCED unique constraints can not be defined on primary key columns

  B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

  C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

  D. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

  Correct Answer: A

• Question 2:

  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

  Correct Answer: B

• Question 3:

  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

  Correct Answer: C

• Question 4:

  Which statement about label-based access control (LBAC) is TRUE?

  A. LBAC protection can be applied to a nickname

  B. LBAC cannot be used to restrict access to a staging table

  C. LBAC cannot be used to restrict access to data of columns and rows in the same table

  D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

  Correct Answer: D

• Question 5:

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

  A. NONE

  B. LOCAL

  C. DOMAIN

  D. GLOBAL

  Correct Answer: D

• Question 6:

  Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

  A. When the registry variableDB2_AUTORECLAIMSPACE=YES

  B. After termination all the back-end processes using TERMINATE command

  C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON

  D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

  Correct Answer: C

• 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

  Correct Answer: A

• Question 8:

  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 璱 DB2_FMP_COMM_HEAPSZ=256000

  D. As the db2 instance owner (db2inst1)execute the command:db2set 璱 db2inst1 DB2_FMP_COMM_HEAPSZ=256000

  Correct Answer: C

• Question 9:

  You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

  A. LOAD

  B. INGEST

  C. IMPORT

  D. TRANSPORT

  Correct Answer: C

• Question 10:

  The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

  A. You can change the principal standby of the primary without first stopping HADR on the primary.

  B. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.

  C. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.

  D. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.

  E. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.

  Correct Answer: AE