IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 61:

  When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

  A. Columns that are used in indexes.
  B. Columns that are used in constraints.
  C. You provide no value for a specific column.
  D. Where a zero is specified in the VALUES clause of a serial column.
  E. Where you specify the NULL keyword in the VALUES clause for a specific column.
  C. You provide no value for a specific column.
  E. Where you specify the NULL keyword in the VALUES clause for a specific column.

• Question 62:

  What is the default isolation level on a mode ANSI database?

  A. Dirty Read
  B. Cursor Stability
  C. Committed Read
  D. Repeatable Read
  D. Repeatable Read

• Question 63:

  Which two storage objects exist in Informix? (Choose two.)

  A. dbspace
  B. flash space
  C. smart rowspace
  D. smart blobspace
  E. encrypted space
  A. dbspace
  D. smart blobspace

• Question 64:

  Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

  A. Offline
  B. On-Line
  C. Quiescent
  D. Administrative
  C. Quiescent

• Question 65:

  What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

  A. pagesize
  B. extent size
  C. creation date
  D. partition partnum
  B. extent size

• Question 66:

  Which statement is true when using onload/onunload?

  A. The output will be in text format.
  B. The source and target operating system can be different.
  C. The target schema can be modified with additional columns.
  D. The source and target database Informix versions must be identical.
  D. The source and target database Informix versions must be identical.

• Question 67:

  You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

  A. in a temporary dbspace
  B. in the default dbspace that is defined in onconfig
  C. in the dbspace where the current database was created
  D. in the dbspace specified by the IFX_DBSPACE environment variable
  C. in the dbspace where the current database was created

• Question 68:

  Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

  A. RUN function
  B. CALL function
  C. CALL procedure
  D. EXECUTE function
  E. EXECUTE procedure
  D. EXECUTE function
  E. EXECUTE procedure

• Question 69:

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

• Question 70:

  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
  A. a single table