C2090-919 Informix 11.70 System Administrator Exam (Exam 4)

C2090-919 Informix 11.70 System Administrator Exam (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which user isolation level may cause concurrency problems with SELECT statements?

  • What does the following SQL statement do? execute function task("reset sysadmin", ...

  • Given the following statement:session A:set lock mode to wait;select * from tab1;i...

  • Which two statements are true for onbar only but not for ontape? (Choose two.)

  • Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?

  • On which node of an Informix H/A cluster can you execute an external backup withou...

  • What are the main administrative roles involved in secure auditing and role separa...

  • Which of the following privileges is NOT valid for a table fragment?

  • The ability for Informix to allow database access to users without a local operati...

  • Which statement regarding the Single Sign-On (SSO) feature is correct?

  • Which role can create, alter, or delete trusted context objects?

  • Which is a valid PAM mode supported by Informix in a UNIX platform?

  • Which of the following schema privileges allows you to rename a fragment?

  • Consider the following selective row-level auditing example:How many entries will ...

  • The following shrink command has what effect on the customer table? execute functi...

  • When executing the following command: execute function sysadmin:task("table compre...

  • Which statement about Informix data compression is NOT true?

  • Which statement about compression is NOT true?

  • A storage pool entry can be used to do what?

  • How is the automatic addition of more space triggered?

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:46 a.m.
    20 questions
    0 completed
    0 takers

  • C2090-919 Informix 11.70 System Administrator Exam (Exam 4) QR code