C2090-558

Review 120 C2090-558 practice questions with answer explanations and community insights.

Question 1

When restoring data, which granularity of object may NOT be restored?

  1. a single table
  2. a single chunk
  3. a single dbspace
  4. an entire instance

Question 2

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

  1. onbar -t timestamp
  2. onbar -r -log lognum
  3. onbar -r -t timestamp
  4. onbar -r -l timestamp

Question 3

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?

  1. a level-1 backup at 6:00 AM everyday
  2. a level-0 backup soon after the load operation
  3. a level-1 backup on Sunday and continuous log backup
  4. a level-2 backup at 6:00 AM every day and continuous log backup

Question 4

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

  1. -RETRY
  2. -RESTART
  3. -REINTIIALZE
  4. -BEGIN_AGAIN

Question 5

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?

  1. Client 2 will update col2 of the rows having col1=20.
  2. Client 2 will return successfully without updating any rows.
  3. Client 2 will keep waiting for client 1 to finish its transaction.
  4. Client 2 will get an error that the "record is locked" or the "table is locked".
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.