NEW QUESTION 1
Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?

• A. frequent writes
• B. frequent updates
• C. uses query parallelization
• D. typically uses memory resident tables

Answer: C

NEW QUESTION 2
Which command can be executed against a view?

• A. DEFRAGMENT
• B. CREATE INDEX
• C. CREATE SYNONYM
• D. UPDATE STATISTICS

Answer: C

NEW QUESTION 3
Which command listed below can be used to change the state of an operating Informix server?

• A. oninit
• B. onstat
• C. onmode
• D. onparam

Answer: C

NEW QUESTION 4
Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

• A. CALL PROCEDURE
• B. CREATE PROCEDURE
• C. OPTIMIZE PROCEDURE
• D. EXECUTE PROCEDURE
• E. UPDATE STATISTICS FOR PROCEDURE

Answer: BE

NEW QUESTION 5
Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

• A. INT
• B. INT8
• C. BIGINT
• D. DOUBLE
• E. LARGEINT

Answer: BC

NEW QUESTION 6
Which command would you execute to restore an instance without using or restoring the logical logs?

• A. onbar -w
• B. onbar -e
• C. onbar -r -p
• D. onbar -r -nolog

Answer: C

NEW QUESTION 7
Why would you want to create a table with a lock mode row as opposed to a lock mode page?

• A. to reduce disk I/O
• B. to keep more information in memory for each locked row
• C. to increase concurrency among multiple users on the same table
• D. to reduce the number of locks when accessing rows out of the table

Answer: C

NEW QUESTION 8
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 9
A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

• A. Use the built-in tasks in the sysadmin database.
• B. Query the ph_run table in the sysadmin database.
• C. Query the ph_task table in the sysadmin database.
• D. Query the command_history table in the sysadmin database.

Answer: D

NEW QUESTION 10
Which statement will change the column address1 to a null value?

• A. UPDATE customerSET address1 = null WHERE customer_num = 134;
• B. UPDATE customerSET address1 = ' ',SET address2 = null WHERE customer_num = 134;
• C. UPDATE customer SET address1 = ""WHERE customer_num = 134;
• D. UPDATE customer SET address1 = '',SET address2 = null WHERE customer_num = 134;

Answer: A

NEW QUESTION 11
When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?

• A. VARCHAR (6)
• B. VARCHAR (4,2)
• C. VARCHAR (8,6)
• D. VARCHAR (6,8)

Answer: C

NEW QUESTION 12
Which two of the following are required for creating a dbspace? (Choose two.)

• A. a mirror chunk
• B. two or more chunks
• C. a cooked file or raw device
• D. a file owned by root or administrator
• E. dbspace name containing only letters, digits, underscores, or $ characters.

Answer: CE

NEW QUESTION 13
Which one of the following is most suitable for scheduling the periodic collection of data
about an instance?

• A. Sensor
• B. Trigger
• C. Stored Procedure
• D. User Defined Routine

Answer: A

NEW QUESTION 14
Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

• A. RUN function
• B. CALL function
• C. CALL procedure
• D. EXECUTE function
• E. EXECUTE procedure

Answer: DE

NEW QUESTION 15
Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

• A. INSERT INTO customer VALUES (453);
• B. INSERT INTO customer VALUES (453, '"ABC Company");
• C. INSERT INTO customer (company) VALUES ("ABC Company");
• D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");

Answer: A

NEW QUESTION 16
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 17
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 18
Which two statements are true about the COMMIT WORK statement? (Choose two.)

• A. The keyword WORK is optional.
• B. A single COMMIT WORK can end several BEGIN WORK statements.
• C. The COMMIT WORK statement releases all row locks but not table locks.
• D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
• E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.

Answer: AD

NEW QUESTION 19
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 20
What functionality is exclusive to ontape (i.e. not present in onbar)?

• A. Level 1 Backup of instance
• B. Rename spaces during a restore
• C. Applying a filter to the backup data
• D. Back up the instance to standard out

Answer: D

NEW QUESTION 21
......