Free IBM P2090-068 Exam Dumps Questions & Answers

In which case would an Enterprise Replication (ER) solution be needed over a High Availability Cluster?

• A.  An entire database needs to be replicated.
• B.  The Linux operating system is being used.
• C.  Data is being replicated between more than two locations.
• D.  Servers are running different versions of Informix.

Which Informix utility can be used to create a snapshot of an instance, including the data?

• A.  onspaces
• B.  onbar
• C.  dbaccess
• D.  ifxdeploy

In which segment of database shared memory is sorting performed?

• A.  Volatile portion
• B.  Virtual portion
• C.  Extended portion
• D.  Non-parity portion

Which utility is used to debug SPL routines?

• A.  IBM Optim Data Studio
• B.  dbx.
• C.  dbaccess.
• D.  OAT (OpenAdmin Tool)

In which of the following scenarios is Informix the best fit?

• A.  Applications requiring dedicated hardware as part of the solution.
• B.  High-transaction OLTP workloads.
• C.  Applications with variable and dynamic data records.
• D.  Large data warehouses requiring cubing and complex multi-dimensional queries.