C2090-558 Online Practice Questions and Answers

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

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

Which one of the following will generate a typical Decision Support System (DSS) type of workload?

A. Ordering a book from an online retailer

B. Inquiring usage data for a particular mobile phone user

C. Bank operation involving transfer of money between two accounts

D. Generating of a report by a large global retail company to find top selling items by country

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

A. Type-Level

B. Table-Level

C. Routine-Level

D. Database-Level

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

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

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

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;

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.

What is true about poll threads?

A. poll threads always run on a CPU vp

B. poll threads always run on a NET vp

C. poll threads always run on an ADM vp

D. poll threads can be configured on a CPU or NET vp