C2090-558

C2090-558 practice questions, page 5 of 5, with answer review and explanations.

Question 21

Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?

  1. only Informix
  2. only a DBSA
  3. only Informix or a DBSA
  4. only root, Informix or a DBSA

Question 22

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

  1. onsql
  2. onadmin
  3. dbaccess
  4. dbschema

Question 23

Which of the following can be used to create and drop logical logs?

  1. onlog
  2. ondblog
  3. onspaces
  4. onparams

Question 24

When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

  1. ontape
  2. onmode
  3. ifxcollect
  4. onparams