IBM IBM Certifications C2090-558 Questions & Answers

• Question 51:

  From the items listed below, what is the smallest granularity of item which may be restored?

  A. a single table

  B. a single dbspace

  C. an entire instance

  D. a set of dbspaces

  Correct Answer: A

• Question 52:

  Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

  A. INSERT INTO t1 values ('t');

  B. INSERT INTO t1 values ('f');

  C. INSERT INTO t1 values (1);

  D. INSERT INTO t1 values (NULL);

  Correct Answer: C

• Question 53:

  Adding a row to which one of the following tables is required to create a database scheduler job?

  A. ph_task

  B. ph_alert

  C. ph_sensor

  D. ph_scheduler

  Correct Answer: A

• Question 54:

  What is the purpose of DB_LOCALE?

  A. It enables operating system independent data storage.

  B. It enables Informix client connectivity by specifying where the instance is located.

  C. It defines conventions for a particular language, collation, or code set within a database.

  D. It defines conventions for a particular language, collation, or code set for a client application.

  Correct Answer: C

• Question 55:

  Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?

  A. frequent writes

  B. frequent updates

  C. uses query parallelization

  D. typically uses memory resident tables

  Correct Answer: C

• Question 56:

  Which document describes new Informix features?

  A. oncofig.std file

  B. Release Notes

  C. Machine Notes

  D. Quick Start Guide

  Correct Answer: B

• Question 57:

  What is the minimum database-level privilage required for a user to create Stored Procedure Language routines?

  A. DBA

  B. Execute

  C. Connect

  D. Resource

  Correct Answer: D

• Question 58:

  Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?

  A. Task

  B. Trigger

  C. Stored Procedure

  D. User Defined Routine

  Correct Answer: A

• Question 59:

  Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

  A. INT

  B. INT8

  C. BIGINT

  D. DOUBLE

  E. LARGEINT

  Correct Answer: BC

• Question 60:

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

  A. quiet

  B. native

  C. staged

  D. console

  E. graphical

  Correct Answer: DE