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.
What is an advantage of using a SPL routine?
A. Increased performance because additional indexes can be selected by the optimizer for complex queries.
B. Increased network utilization since more data is passed between client and server.
C. Increased efficiency since business logic can be centrally maintained and managed on the server.
D. Increased security because SPL routines can only be invoked by Java applications.
By default, who is granted access to the sysadmin database?
A. Nobody
B. PUBLIC
C. The Informix user only
D. root
A small dentist office uses Informix as the backend database for their operational system. A small Intel-based system with a single processor and 2 GB of memory is used. It also runs theWindows operating system. Which edition of Informix is the minimum required?
A. Informix Growth Edition
B. Informix Ultimate Edition
C. Informix Choice Edition
D. Informix Innovator-C Edition
In which segment of database shared memory are bufferpools created by default?
A. Resident portion
B. Flash portion
C. Extended portion
D. Volatile portion
Which of the following is a key benefit of Informix?
A. Database extensions can be added to supportnew business problem domains.
B. Chunks can be two gigabytes in size.
C. Uptime of at most 80% can be achieved using continuous availability features.
D. Databases can be administered by a local database administrator.
Which Informix utility is useful in debugging failedtransactions, the time period of a transaction, and changes that are made to a tablespace?
A. onlog
B. onload
C. onbar
D. onunload
Which of the following components is used to create, schedule, and execute maintenance,monitoring and administrative tasks?
A. Scheduler
B. Optimizer
C. PDQ
D. ON-Bar
Which of the following Informix security methods protects network data transmitted between a server and a client?
A. Set-column level encryption
B. Cell-level encryption
C. Column-level encryption
D. Network data encryption
Which Informix utility can be used to create a snapshot of an instance, including the data?
A. dbaccess
B. onspaces
C. onbar
D. ifxdeploy
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-068 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.