Leads4pass > IBM > IBM Certifications > C2090-558 > C2090-558 Online Practice Questions and Answers

C2090-558 Online Practice Questions and Answers

Questions 4

What are two system level databases? (Choose two.)

A. sysperf

B. sysadmin

C. sysmaster

D. sysmonitor

E. sysscheduler

Buy Now
Questions 5

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

Buy Now
Questions 6

Which of the following can be used to create and drop logical logs?

A. onlog

B. ondblog

C. onspaces

D. onparams

Buy Now
Questions 7

Given the query shown below:

What will happen?

A. All rows will be retrieved in which item_desc contains the characters 'pencil'.

B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.

C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.

D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.

Buy Now
Questions 8

Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

A. Use a trigger.

B. Create a foreign key.

C. Use a nightly batch process.

D. Define a task in the sysadmin database.

Buy Now
Questions 9

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

Buy Now
Questions 10

Which two statements will update all rows in the customer table? (Choose two.)

A. update customer set fname = "xyz";

B. modify customer set fname = "xyz";

C. modify customer set fname = "xyz" where 1 = 1;

D. update customer set fname = "xyz" where 1 = 1;

E. update customer set fname = "xyz" for all;

Buy Now
Questions 11

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

Buy Now
Questions 12

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)

Buy Now
Questions 13

What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

A. pagesize

B. extent size

C. creation date

D. partition partnum

Buy Now
Exam Code: C2090-558
Exam Name: Informix 11.70 Fundamentals
Last Update: Jan 17, 2025
Questions: 120
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99