IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 71:

  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
  A. Task

• Question 72:

  Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

  A. ontape
  B. onunload and onload
  C. ifxsend and ifxreceive
  D. dbexport and dbimport
  D. dbexport and dbimport

• Question 73:

  Which command would you execute to restore an instance without using or restoring the logical logs?

  A. onbar -w
  B. onbar -e
  C. onbar -r -p
  D. onbar -r -nolog
  C. onbar -r -p

• Question 74:

  Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

  A. ALL
  B. ANY
  C. EACH
  D. EVERY
  A. ALL

• Question 75:

  What are two system level databases? (Choose two.)

  A. sysperf
  B. sysadmin
  C. sysmaster
  D. sysmonitor
  E. sysscheduler
  B. sysadmin
  C. sysmaster

• Question 76:

  Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

  A. onsql
  B. onadmin
  C. dbaccess
  D. dbschema
  C. dbaccess

• Question 77:

  Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

  A. CALL PROCEDURE
  B. CREATE PROCEDURE
  C. OPTIMIZE PROCEDURE
  D. EXECUTE PROCEDURE
  E. UPDATE STATISTICS FOR PROCEDURE
  B. CREATE PROCEDURE
  E. UPDATE STATISTICS FOR PROCEDURE

• Question 78:

  Which configuration parameters are used by ontape logical log backup?

  A. LOGFILES, LOGSIZE, TAPEDEV
  B. LTAPEBLK, TAPEDEV, TAPESIZE
  C. LTAPESIZE, LTAPEDEV, LTAPEBLK
  D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER
  C. LTAPESIZE, LTAPEDEV, LTAPEBLK

• Question 79:

  Which table type is always nonlogging?

  A. RAW
  B. TEMP
  C. STATIC
  D. STANDARD
  A. RAW

• Question 80:

  Click the Exhibit button.

  Which of the following will display the values in the lead_time column from highest to lowest?

  A. SELECT * FROM manufact ORDER BY lead_time
  B. SELECT * FROM manufact ORDER BY lead_time ASC
  C. SELECT * FROM manufact ORDER BY lead_time HIGH
  D. SELECT * FROM manufact ORDER BY lead_time DESC
  D. SELECT * FROM manufact ORDER BY lead_time DESC