C2090-558 Exam Questions

Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

What functionality is exclusive to ontape (i.e. not present in onbar)?

Which of the following is required for a cold restore?

Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

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

User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

Which command would you execute to restore to a specific moment-in-time?

Click the Exhibit button. Which of the following will display the values in the lead_time column from highest to lowest?

What Informix data type is suitable for storing video clips up to a size of 4 TB?

Why would you want to create a table with a lock mode row as opposed to a lock mode page?

In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?

Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix datab...

Which command option should be used to resume an interrupted onbar restore?

What functionality is exclusive to onbar (i.e. not present in ontape)?

Which two of the following are required for creating a dbspace? (Choose two.)

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