ExamTopics Logo
Mail Us[email protected]
Menu
 

C2090-558 Actual Exam Questions

Last updated on Dec. 13, 2024.
Vendor:IBM
Exam Code:C2090-558
Exam Name:Informix 11.70 Fundamentals
Exam Questions:120
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

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

  • A. a single table
  • B. a single chunk
  • C. a single dbspace
  • D. an entire instance
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

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

  • A. onbar -t timestamp
  • B. onbar -r -log lognum
  • C. onbar -r -t timestamp
  • D. onbar -r -l timestamp
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Question #3 Topic 1

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
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #4 Topic 1

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

  • A. -RETRY
  • B. -RESTART
  • C. -REINTIIALZE
  • D. -BEGIN_AGAIN
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

file Viewing page 1 out of 30 pages.
Viewing questions 1-4 out of 120 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago