C2090-558 Exam - Informix 11.70 Fundamentals (C2090-558)

NEW QUESTION 1
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 2
What is the default isolation level on a mode ANSI database?

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

Answer: D

NEW QUESTION 3
Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

• A. INSERT INTO t1 values ('t');
• B. INSERT INTO t1 values ('f');
• C. INSERT INTO t1 values (1);
• D. INSERT INTO t1 values (NULL);

Answer: C

NEW QUESTION 4
Which of the following statements is true about referential integrity?

• A. Primary and foreign key values must be integers.
• B. You must explicitly define constraint names for primary and foreign key columns.
• C. A row in a table cannot be deleted if it contains a foreign key value that exists as aprimary key value in the referenced table.
• D. A row in a table cannot be deleted if it contains a primary key value that is referenced by a foreign key value in another table.

Answer: D

NEW QUESTION 5
Which statement is used to create a permanent nonlogged table in a logged database?

• A. CREATE TABLE tab1 (col1 INTEGER, col2 INTEGER)
• B. CREATE RAW TABLE tab1 (col1 INTEGER , col2 INTEGER)
• C. CREATE STATIC TABLE tab1 (col1 INTEGER , col2 INTEGER)
• D. CREATE NONLOGGING TABLE tab1 (col1 INTEGER , col2 INTEGER)

Answer: B

NEW QUESTION 6
Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

• A. Flexible Grid
• B. Enterprise Replication
• C. High Availability Cluster
• D. High Availability Data Replication

Answer: A

NEW QUESTION 7
Adding a row to which one of the following tables is required to create a database scheduler job?

• A. ph_task
• B. ph_alert
• C. ph_sensor
• D. ph_scheduler

Answer: A

NEW QUESTION 8
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 9
Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?

• A. 60 and 120 seconds before aborting
• B. Every 3 minutes within one hour before aborting
• C. Every 3 seconds within one hour before aborting
• D. Wait indefinitely until it is successfully completed

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
Which two operations are performed with the onspaces command? (Choose two.)

• A. Add space to the server.
• B. Compress server space.
• C. Encrypt the server space.
• D. Remove space from the server.
• E. Restrict access to the server space.

Answer: AD

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

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

Answer: C

NEW QUESTION 13
In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

• A. sysutils
• B. sysusers
• C. sysadmin
• D. sysmaster

Answer: C

NEW QUESTION 14
Click the Exhibit button.

In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

• A. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES order );
• B. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num)REFERENCES customer );
• C. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES order );
• D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

Answer: D

NEW QUESTION 15
Which two events can initiate a trigger on a table? (Choose two.)

• A. DROP
• B. ALTER
• C. INSERT
• D. SELECT
• E. TRUNCATE

Answer: CD

NEW QUESTION 16
Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

• A. a primary key
• B. a unique index
• C. a virtual column
• D. a unique constraint

Answer: A

NEW QUESTION 17
Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can
access Informix databases?

• A. only Informix
• B. only a DBSA
• C. only Informix or a DBSA
• D. only root, Informix or a DBSA

Answer: C

NEW QUESTION 18
User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

• A. DBA on the database
• B. EXECUTE on the procedure
• C. RESOURCE on the database
• D. SELECT on the tables used in the procedure

Answer: B

NEW QUESTION 19
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 20
Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

• A. HAVING
• B. WHERE
• C. GROUP BY
• D. ORDER BY

Answer: A

NEW QUESTION 21
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 22
......