IBM Informix 12.10 System Administrator - C2090-619 Exam Practice Test
You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?
Correct Answer: D
Vote an answer
Which fragmentation strategy is capable of generating new fragments automatically?
Correct Answer: B
Vote an answer
Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?
Correct Answer: C
Vote an answer
Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?
Correct Answer: D
Vote an answer
Given the following:
How many locks will be used on tab1 to run the query?
How many locks will be used on tab1 to run the query?
Correct Answer: C
Vote an answer
The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement
CANNOT define a purging policy on a table that has which two attributes? (Choose two.)
CANNOT define a purging policy on a table that has which two attributes? (Choose two.)
Correct Answer: C,D
Vote an answer
Which statement accurately describes the selective row-level auditing feature in Informix?
Correct Answer: D
Vote an answer
You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;").
How can you determine the relationship between the violations table and the target table later?
How can you determine the relationship between the violations table and the target table later?
Correct Answer: A
Vote an answer