NEW QUESTION 1
Click the Exhibit button.

In the exhibit, which two statements are correct? (Choose two.)

• A. the rootdbs dbspace is online
• B. the dataspace dbspace is online
• C. the rootdbs dbspace contains 2 chunks
• D. the dataspace dbspace contains 2 chunks
• E. the dataspace and rootdbs are both online

Answer: AC

NEW QUESTION 2
Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

• A. USERMAPPING
• B. IFX_EXTEND_ROLE
• C. SECURITY_LOCALCONNECTION
• D. ADMIN_USER_MODE_WITH_DBSA

Answer: A

NEW QUESTION 3
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 4
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 5
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 6
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 7
What is the default isolation level on a database with unbuffered logging?

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

Answer: C

NEW QUESTION 8
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 9
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 10
Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

• A. Ontape utility
• B. Snapshot utility
• C. Archecker utility
• D. Deployment utility

Answer: D

NEW QUESTION 11
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 12
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 13
What Informix data type is suitable for storing video clips up to a size of 4 TB?

• A. BLOB
• B. BYTE
• C. CLOB
• D. COLLECTION

Answer: A

NEW QUESTION 14
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 15
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 16
Which of the following is true about system catalog tables access?

• A. Only user informix can read system catalog tables
• B. Only system administrators can read system catalog tables
• C. Only database administrators can read system catalog tables
• D. Any user that can connect to the database can read system catalog tables

Answer: D

NEW QUESTION 17
Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

• A. sysutils
• B. sysstate
• C. sysmaster
• D. sysmonitor

Answer: C

NEW QUESTION 18
Click the Exhibit button.

Which of the following will display the values in the lead_time column from highest to lowest?

• A. SELECT * FROM manufact ORDER BY lead_time
• B. SELECT * FROM manufact ORDER BY lead_time ASC
• C. SELECT * FROM manufact ORDER BY lead_time HIGH
• D. SELECT * FROM manufact ORDER BY lead_time DESC

Answer: D

NEW QUESTION 19
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 20
When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

• A. ontape
• B. onmode
• C. ifxcollect
• D. onparams

Answer: C

NEW QUESTION 21
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 22
Which of the following can be used to move the physical log?

• A. onlog
• B. ondblog
• C. onspaces
• D. onparams

Answer: D

NEW QUESTION 23
Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

• A. Client 2 will update col2 of the rows having col1=20.
• B. Client 2 will return successfully without updating any rows.
• C. Client 2 will keep waiting for client 1 to finish its transaction.
• D. Client 2 will get an error that the "record is locked" or the "table is locked".

Answer: D

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
......