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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary t...

  • What two onconfig parameters will help improve performance of new network connecti...

  • Given the following SQL command where the DBSPACETEMP onconfig and environment var...

  • What ONCONFIG parameter can be tuned to increase memory for hash joins?

  • Which two options can be used to monitor PDQ resources? (Choose two.)

  • Which statement about updating statistics is NOT true?

  • Most, but not all Virtual Processors, can be modified via the onmode -p command. W...

  • Which of the following gives a good initial estimate for the physical log size?

  • Which two onconfig parameters can be set to backup/restore to/from a cloud storage...

  • Which two objects are NOT included in a backup? (Choose two.)

  • What is used during Fast Recovery to return pages to the original state?

  • To maximize the performance of your OnBar backup and recovery operations, what sho...

  • Which option would be used with "cdr define replicate" to create a shadow replicate?

  • How many paging files are required for SD secondary instances?

  • What statement about users accessing a Flexible Grid is true?

  • A Connection Manager is started with the following Service Level Agreement:SLA rep...

  • Which of the following is NOT a step in setting up HDR for the first time?

  • Assuming you have a table with a replicate defined. A Flexible Grid procedure is e...

  • Given the following:

  • Given the following SQL statement:What does the merge statement do?

Oct. 20, 2016
review by Christopher Karsten (@christopher4)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:46 a.m.
    20 questions
    1 completed
    1 takers

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