NEW QUESTION 1
From the items listed below, what is the smallest granularity of item which may be restored?

• A. a single table
• B. a single dbspace
• C. an entire instance
• D. a set of dbspaces

Answer: A

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 command can be executed against a view?

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

Answer: C

NEW QUESTION 4
Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

• A. ontape
• B. onunload and onload
• C. ifxsend and ifxreceive
• D. dbexport and dbimport

Answer: D

NEW QUESTION 5
Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

• A. ALL
• B. ANY
• C. EACH
• D. EVERY

Answer: A

NEW QUESTION 6
Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?

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

Answer: A

NEW QUESTION 7
Which of the following privileges can NOT be granted to a role?

• A. Type-Level
• B. Table-Level
• C. Routine-Level
• D. Database-Level

Answer: D

NEW QUESTION 8
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 9
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 10
What is the purpose of DB_LOCALE?

• A. It enables operating system independent data storage.
• B. It enables Informix client connectivity by specifying where the instance is located.
• C. It defines conventions for a particular language, collation, or code set within a database.
• D. It defines conventions for a particular language, collation, or code set for a client application.

Answer: C

NEW QUESTION 11
Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

• A. create table t1 (c1 int)
• B. create table t1 (c1 int) locking page
• C. create table t1 (c1 int) lock level page
• D. create table t1 (c1 int) lock mode page
• E. create table t1 (c1 int) locking mode page

Answer: AD

NEW QUESTION 12
What are two ways to create table t1 with row level locking? (Choose two.)

• A. Execute the command "create table t1 (c1 int) locking row".
• B. Execute the command "create table t1 (c1 int) lock level row".
• C. Execute the command "create table t1 (c1 int) lock mode row".
• D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
• E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".

Answer: CD

NEW QUESTION 13
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 14
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 15
Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

• A. Manage Virtual Processors (VP).
• B. Automate the update statistics process.
• C. Perform installation of an Informix server.
• D. Run the High Performance Loader (HPL) GUI tool.
• E. Remove an instance's orphaned shared memory segment.

Answer: AB

NEW QUESTION 16
Which of the following can be used to move the physical log?

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

Answer: D

NEW QUESTION 17
Click the Exhibit button.

An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to optimize a backup strategy to recover the client table in case of a failure?

• A. a level-1 backup at 6:00 AM everyday
• B. a level-0 backup soon after the load operation
• C. a level-1 backup on Sunday and continuous log backup
• D. a level-2 backup at 6:00 AM every day and continuous log backup

Answer: B

NEW QUESTION 18
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 19
Which of the following methods can be used to tranfer data in EXPRESS mode?

• A. dbload
• B. external tables
• C. onload/onunload
• D. dbexport/dbimport

Answer: B

NEW QUESTION 20
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 21
Which command could be used to display the definition of user-defined and complex data types?

• A. onstat -g smb
• B. oncheck -cc database_name
• C. oncheck -pB database_name
• D. dbschema -u all -d database_name

Answer: D

NEW QUESTION 22
When restoring data, which granularity of object may NOT be restored?

• A. a single table
• B. a single chunk
• C. a single dbspace
• D. an entire instance

Answer: B

NEW QUESTION 23
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 24
Which of the following modes is NOT supported by Informix?

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

Answer: C

NEW QUESTION 25
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 26
......