IBM C2090-558 Interactive Bootcamp 2021

NEW QUESTION 1
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 2
Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

• A. Logical Recovery
• B. Physical Recovery
• C. Dbspace Recovery
• D. Transactional Recovery

Answer: A

NEW QUESTION 3
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 4
Which utility would you use to print out the physical layout of the instance?

• A. onstat
• B. onmode
• C. onspaces
• D. dbschema

Answer: D

NEW QUESTION 5
Which two database objects can be created using fragmentation? (Choose two.)

• A. view
• B. table
• C. index
• D. trigger
• E. synonym

Answer: BC

NEW QUESTION 6
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 7
Which of the following can be used to create and drop logical logs?

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

Answer: D

NEW QUESTION 8
Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

• A. Row level lock
• B. Page level locking
• C. RAW or unlogged tables
• D. Tables containing complex data types

Answer: A

NEW QUESTION 9
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 10
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 11
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 12
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 13
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 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
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 16
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 17
Which two products can be used by client applications to connect to Informix instances? (Choose two.)

• A. IBM Global Connect
• B. IBM Informix Connect
• C. IBM Informix JDBC Driver
• D. IBM Informix Office Manager
• E. IBM Informix Universal Driver Kit

Answer: BC

NEW QUESTION 18
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 19
Which configuration parameters are used by ontape logical log backup?

• A. LOGFILES, LOGSIZE, TAPEDEV
• B. LTAPEBLK, TAPEDEV, TAPESIZE
• C. LTAPESIZE, LTAPEDEV, LTAPEBLK
• D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER

Answer: C

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

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

Answer: C

NEW QUESTION 22
You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?

• A. EXTENT SIZE 75000 NEXT SIZE 0
• B. EXTENT SIZE 1000 NEXT SIZE 50000
• C. EXTENT SIZE 50000 NEXT SIZE 1000
• D. EXTENT SIZE 50000 NEXT SIZE 50000

Answer: C

NEW QUESTION 23
Which of the following is true of system catalogs?

• A. one system catalog per chunk
• B. one system catalog per instance
• C. one system catalog per database
• D. one system catalog per installation

Answer: C

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