NEW QUESTION 1
What are two system level databases? (Choose two.)

• A. sysperf
• B. sysadmin
• C. sysmaster
• D. sysmonitor
• E. sysscheduler

Answer: BC

NEW QUESTION 2
Which two storage objects exist in Informix? (Choose two.)

• A. dbspace
• B. flash space
• C. smart rowspace
• D. smart blobspace
• E. encrypted space

Answer: AD

NEW QUESTION 3
Which statement is true when using onload/onunload?

• A. The output will be in text format.
• B. The source and target operating system can be different.
• C. The target schema can be modified with additional columns.
• D. The source and target database Informix versions must be identical.

Answer: D

NEW QUESTION 4
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

• A. onsql
• B. onadmin
• C. dbaccess
• D. dbschema

Answer: C

NEW QUESTION 5
Which of the following statement is correct about Shared Disk (SD) secondary servers?

• A. SD secondary servers support automatic index repair
• B. SD secondary servers use paging files to track pages between checkpoints
• C. SD secondary servers require an HDR secondary server to be present in order to function
• D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

Answer: B

NEW QUESTION 6
Which of the following methods will allow you to determine how much space is currently in use?

• A. Query the $ table
• B. Query the sysstats database
• C. Query the sysusers database
• D. Query the sysmaster database

Answer: D

NEW QUESTION 7
How can you determine which databases are created in an instance?

• A. use dbschema utility
• B. inspect ONCONFIG file
• C. List reserved pages with oncheck -pr
• D. run SELECT name FROM sysmaster:sysdatabases

Answer: D

NEW QUESTION 8
Which search condition is allowed in a check constraint?

• A. It can contain aggregates.
• B. It can contain subqueries.
• C. It can contain host variables.
• D. It can contain a range of values.

Answer: D

NEW QUESTION 9
What is the only isolation level available on an unlogged database?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: A

NEW QUESTION 10
What is true about poll threads?

• A. poll threads always run on a CPU vp
• B. poll threads always run on a NET vp
• C. poll threads always run on an ADM vp
• D. poll threads can be configured on a CPU or NET vp

Answer: D

NEW QUESTION 11
You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

• A. When the buffer is full.
• B. When a checkpoint occurs.
• C. When a user issues a begin work.
• D. When a user commits the transaction.
• E. When a user rolls back the transaction.

Answer: AB

NEW QUESTION 12
Which command option should be used to resume an interrupted onbar restore?

• A. -RETRY
• B. -RESTART
• C. -REINTIIALZE
• D. -BEGIN_AGAIN

Answer: B

NEW QUESTION 13
A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

• A. dbload
• B. dbexport
• C. external table
• D. SQL unload statement

Answer: C

NEW QUESTION 14
Which isolation level is appropriate if you do not want your query to place any locks?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: A

NEW QUESTION 15
When installing Informix, which two installation methods can be used? (Choose two.)

• A. quiet
• B. native
• C. staged
• D. console
• E. graphical

Answer: DE

NEW QUESTION 16
Click the Exhibit button.

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

• A. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (class_id));
• B. ALTER TABLE class ADD CONSTRAINT (PRIMARY KEY (course_num));
• C. ALTER TABLE course ADD CONSTRAINT (PRIMARY KEY (course_num));
• D. ALTER TABLE class ADD CONSTRAINT (FOREIGN KEY (course_num)REFERENCES course);
• E. ALTER TABLE course ADD CONSTRAINT (FOREIGN KEY (course_num) REFERENCES class);

Answer: CD

NEW QUESTION 17
You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

• A. in a temporary dbspace
• B. in the default dbspace that is defined in onconfig
• C. in the dbspace where the current database was created
• D. in the dbspace specified by the IFX_DBSPACE environment variable

Answer: C

NEW QUESTION 18
Which of the following modes is NOT supported by Informix?

• A. On-Line
• B. Quiescent
• C. Replication
• D. Administration

Answer: C

NEW QUESTION 19
Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

• A. Use a trigger.
• B. Create a foreign key.
• C. Use a nightly batch process.
• D. Define a task in the sysadmin database.

Answer: A

NEW QUESTION 20
Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

• A. Offline
• B. On-Line
• C. Quiescent
• D. Administrative

Answer: C

NEW QUESTION 21
There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

• A. commit work;
• B. set isolation to dirty read;
• C. set lock mode to not wait;
• D. set lock mode to nolocking;

Answer: B

NEW QUESTION 22
Which of the following statements can be used to prevent duplicate values in an indexed column?

• A. CREATE HASH INDEX
• B. CREATE UNIQUE INDEX
• C. CREATE DISTINCT TYPE
• D. CREATE CLUSTER INDEX

Answer: B

NEW QUESTION 23
What is the lowest level of granularity supported by Enterprise Replication?

• A. column
• B. instance
• C. database
• D. fragment

Answer: A

NEW QUESTION 24
Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

• A. task ( )
• B. admin ( )
• C. oncmd ( )
• D. ifxcreate ( )
• E. oncreate ( )

Answer: AB

NEW QUESTION 25
Which two statements will delete all rows from table_name? (Choose two.)

• A. DROP FROM table_name ;
• B. DELETE FROM table_name ;
• C. DELETE * FROM table_name ;
• D. TRUNCATE TABLE table_name ;
• E. DELETE ALL FROM table_name ;

Answer: BD

NEW QUESTION 26
......