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.
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)
What is the smallest unit ofphysical I/O in an Informix server?
A. Chunk
B. Extent
C. Page
D. Dbspace
In which segment of database shared memory is sorting performed?
A. Volatile portion
B. Virtual portion
C. Non-parity portion
D. Extended portion
What size of business does Informix target?
A. Medium-sized businesses only
B. Small, medium, and large businesses
C. Small businesses only
D. Small businesses with a team of database administrators
Which of the following statements aboutFlexible Grid technology is TRUE?
A. It requires high speed interconnect technology between nodes.
B. It works only in a shared disk environment.
C. It requires additional technology for disaster recovery.
D. Both DDL and DML can be performed dynamicallyon all grid nodes from a single server.
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
What isthe purpose of the sysmaster database?
A. To provide information about the current state of the database server.
B. To provide an entry point so you can change tablespaces.
C. To allow you to modify data within tables.
D. To allow you to drop a database or any of its tables.
What is a feature of the architecture of Informix?
A. Limited extensibility capabilities
B. Fan-In and Fan-Out parallelism
C. Synchronous I/O for fast read-ahead
D. Process-based with minimal use ofmultithreading
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.