IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 91:

  Which utility can be used to relocate the physical log to a new dbspace?

  A. onlog
  B. ontape
  C. onspaces
  D. onparams
  D. onparams

• Question 92:

  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 );
  D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

• Question 93:

  Which authentication functionality allows you to implement different authentication mechanisms for different applications?

  A. Single Sign-On
  B. Secure Socket Layer
  C. Pluggable Authentication Modules
  D. Lightweight Directory Access Protocol
  C. Pluggable Authentication Modules

• Question 94:

  You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?

  A. EXTENT SIZE 75000 NEXT SIZE 0
  B. EXTENT SIZE 1000 NEXT SIZE 50000
  C. EXTENT SIZE 50000 NEXT SIZE 1000
  D. EXTENT SIZE 50000 NEXT SIZE 50000
  C. EXTENT SIZE 50000 NEXT SIZE 1000

• Question 95:

  Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

  A. a primary key
  B. a unique index
  C. a virtual column
  D. a unique constraint
  A. a primary key

• Question 96:

  Which two installation modes are available for Informix? (Choose two.)

  A. Full
  B. Typical
  C. Custom
  D. Compact
  E. Complete
  B. Typical
  C. Custom

• Question 97:

  When installing Informix, which two installation methods can be used? (Choose two.)

  A. quiet
  B. native
  C. staged
  D. console
  E. graphical
  D. console
  E. graphical

• Question 98:

  Which statement will change the column address1 to a null value?

  A. UPDATE customer SET address1 = null WHERE customer_num = 134;
  B. UPDATE customer SET address1 = ' ', SET address2 = null WHERE customer_num = 134;
  C. UPDATE customer SET address1 = "" WHERE customer_num = 134;
  D. UPDATE customer SET address1 = '', SET address2 = null WHERE customer_num = 134;
  A. UPDATE customer SET address1 = null WHERE customer_num = 134;

• Question 99:

  Which two of the following are required for creating a dbspace? (Choose two.)

  A. a mirror chunk
  B. two or more chunks
  C. a cooked file or raw device
  D. a file owned by root or administrator
  E. dbspace name containing only letters, digits, underscores, or $ characters.
  C. a cooked file or raw device
  E. dbspace name containing only letters, digits, underscores, or $ characters.

• Question 100:

  Which command can be executed against a view?

  A. DEFRAGMENT
  B. CREATE INDEX
  C. CREATE SYNONYM
  D. UPDATE STATISTICS
  C. CREATE SYNONYM