IBM IBM Certifications C2090-558 Questions & Answers

• Question 11:

  What is true about poll threads?

  A. poll threads always run on a CPU vp

  B. poll threads always run on a NET vp

  C. poll threads always run on an ADM vp

  D. poll threads can be configured on a CPU or NET vp

  Correct Answer: D

• Question 12:

  Which utility would you use to print out the physical layout of the instance?

  A. onstat

  B. onmode

  C. onspaces

  D. dbschema

  Correct Answer: D

• Question 13:

  Which of the following is true of system catalogs?

  A. one system catalog per chunk

  B. one system catalog per instance

  C. one system catalog per database

  D. one system catalog per installation

  Correct Answer: C

• Question 14:

  Which search condition is allowed in a check constraint?

  A. It can contain aggregates.

  B. It can contain subqueries.

  C. It can contain host variables.

  D. It can contain a range of values.

  Correct Answer: D

• Question 15:

  Click the Exhibit button.

  

  In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

  A. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES order );

  B. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES customer );

  C. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES order );

  D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

  Correct Answer: D

• Question 16:

  Which command can be executed against a view?

  A. DEFRAGMENT

  B. CREATE INDEX

  C. CREATE SYNONYM

  D. UPDATE STATISTICS

  Correct Answer: C

• Question 17:

  Which two events can initiate a trigger on a table? (Choose two.)

  A. DROP

  B. ALTER

  C. INSERT

  D. SELECT

  E. TRUNCATE

  Correct Answer: CD

• Question 18:

  Which of the following statements is true about referential integrity?

  A. Primary and foreign key values must be integers.

  B. You must explicitly define constraint names for primary and foreign key columns.

  C. A row in a table cannot be deleted if it contains a foreign key value that exists as a primary key value in the referenced table.

  D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

  Correct Answer: D

• Question 19:

  Which two database objects can be created using fragmentation? (Choose two.)

  A. view

  B. table

  C. index

  D. trigger

  E. synonym

  Correct Answer: BC

• Question 20:

  Which statement is used to create a permanent nonlogged table in a logged database?

  A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)

  B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)

  C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)

  D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)

  Correct Answer: B