In which of the following scenarios is Informix the best fit?
A. Applications with variable and dynamic data records.
B. Large data warehouses requiring cubing and complex multi-dimensional queries.
C. Applications requiring dedicated hardware as part of the solution.
D. High-transaction OLTP workloads.
Which Informix utility allows you to change the logging mode for one or more databases?
A. oninit
B. ondblog
C. onmode
D. ondbmode
Which of the following is a Database-level privilege?
A. CONNECT
B. EXECUTE
C. SELECT
D. REFERENCES
Which of the following statements about the level of compatibility between the backups produced by ontape and ON-Bar is true?
A. You can create a backup with ON-Bar and restore it with ontape, but not vice versa.
B. You can create a backup with ontape and restore it with ON-Bar, but not vice versa.
C. The respective backups are not compatible; you cannot create a backup with ontape and restore it with ON-Bar, or vice versa.
D. The respective backup tapes are compatible; you can create a backup with ontape and restore it with ON-Bar, and vice versa.
Which of the following statements about the ontape utility is TRUE?
A. Itcan be used to backup a database to a tape device or file system, or directory.
B. It can be used to backup operating system files in addition to databases.
C. It can be used to backup and restore different storage spaces in parallel.
D. It can be used tobackup a database to tape devices only.
In which case would an Enterprise Replication (ER) solution be needed over a High Availability Cluster?
A. Servers are running different versions of Informix.
B. Data is being replicated between more than two locations.
C. The Linux operating system is being used.
D. An entire database needs to be replicated.
Which Informix edition, at a minimum, would permit a Global company to deploy multiple database backup sites for protection against man-made or natural disasters? They want to include oneshared disk secondary, as well as one Remote Secondary Server in their plan.
A. Informix Ultimate-C Edition
B. Informix Growth Edition
C. Informix Ultimate Edition
D. Informix Innovator-C Edition
TheXYZ Company's failover recovery strategy requires a backup site; however, they do not have a constant or uninterrupted communication link to that site. What type of high availability configuration should be used?
A. Two Shared Disk Secondary (SDS) servers with hardware disk mirroring
B. A High Availability Data Replication (HDR) secondary server running in SYNC mode
C. Continuous Log Restore (CLR) with backup and recovery
D. Enterprise Replication (ER)
The physical log is usedto do what?
A. Alert the DBA when the system needs maintenance or tuning.
B. Store a copy of a page from the shared-memory buffer pool before it is modified for the first time.
C. Record error information when a severe error is encountered.
D. Store information about the status of used and free space in a dbspace.
Which of the following statements is True about the Onstat utility?
A. It cannot be used to retrieve locking information.
B. It consume a lot of the system's resources andshould be used infrequently.
C. It doesn't place any locks on shared memory.
D. It can be used to view table data.
