IBM P2090-068 - IBM Information Management Informix Technical Mastery Test v3 Exam
Page: 2 / 9
Total 42 questions
Question #6 (Topic: )
Which of the following is a Database-level privilege?
A. CONNECT
B. EXECUTE
C. SELECT
D. REFERENCES
Answer: A
Question #7 (Topic: )
Which disposition type is not allowed withthe ifxclone utility?
A. rss
B. er
C. Blank.
D. sds
Answer: D
Question #8 (Topic: )
Which of the following administrative processes can Informix handle automatically?
A. Online Archival
B. Storage Provisioning
C. Database schema optimization
D. Datare-distribution
Answer: B
Question #9 (Topic: )
Which type of high availability server maintains a backup copy of the entire database that
applications can access immediately in the event of a catastrophic failure of the primary
server?
applications can access immediately in the event of a catastrophic failure of the primary
server?
A. Remote Primary Server (RPS)
B. Remote Standalone Secondary (RSS)
C. Continuous Log Restore (CLR)
D. High Availability Data Replication (HDR) Secondary
Answer: D
Question #10 (Topic: )
What is an advantage of using Multi-Index scan?
A. Multiprocessor support
B. Multiple disk drive support
C. Index keys are stored in compressed format
D. Less indexes need to be defined on a table
Answer: D
