IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 51:

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

  A. Level 1 Backup of instance
  B. Rename spaces during a restore
  C. Applying a filter to the backup data
  D. Back up the instance to standard out
  D. Back up the instance to standard out

• Question 52:

  A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

  A. Use the built-in tasks in the sysadmin database.
  B. Query the ph_run table in the sysadmin database.
  C. Query the ph_task table in the sysadmin database.
  D. Query the command_history table in the sysadmin database.
  D. Query the command_history table in the sysadmin database.

• Question 53:

  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
  A. the rootdbs dbspace is online
  C. the rootdbs dbspace contains 2 chunks

• Question 54:

  Click the Exhibit button.

  

  In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

  A. Client 2 will update col2 of the rows having col1=20.
  B. Client 2 will return successfully without updating any rows.
  C. Client 2 will keep waiting for client 1 to finish its transaction.
  D. Client 2 will get an error that the "record is locked" or the "table is locked".
  D. Client 2 will get an error that the "record is locked" or the "table is locked".

• Question 55:

  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
  B. a level-0 backup soon after the load operation

• Question 56:

  Which two statements are true about the COMMIT WORK statement? (Choose two.)

  A. The keyword WORK is optional.
  B. A single COMMIT WORK can end several BEGIN WORK statements.
  C. The COMMIT WORK statement releases all row locks but not table locks.
  D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
  E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.
  A. The keyword WORK is optional.
  D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.

• Question 57:

  Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

  A. INT
  B. INT8
  C. BIGINT
  D. DOUBLE
  E. LARGEINT
  B. INT8
  C. BIGINT

• Question 58:

  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
  B. EXECUTE on the procedure

• Question 59:

  Which document describes new Informix features?

  A. oncofig.std file
  B. Release Notes
  C. Machine Notes
  D. Quick Start Guide
  B. Release Notes

• Question 60:

  You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

  A. onspaces
  B. onmonitor
  C. oncheck -pe
  D. SELECT * from SYSTABLES
  C. oncheck -pe