Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

27
Students signed up in the last 24H

IBM C2090-600 Exam Actual Questions

The questions for C2090-600 were last updated on April 29, 2024.
  • Viewing page 1 out of 15 pages.
  • Viewing questions 1-4 out of 60 questions
 

Topic 1 - Single Topic

Question #1 Topic 1

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named
SAMPLE to AUTOMATIC?

  • A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
  • B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
  • C. CONNECT TO sample; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
  • D. ATTACH TO db2inst1; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;
Reveal Solution Hide Solution   Discussion   5

Correct Answer: C 🗳️

Question #2 Topic 1

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

  • A. Catalog a storage access alias in the DB2 database
  • B. Create an FTP account on IBM Softlayer Object Storage
  • C. Use the DB2REMOTE parameter of the LOAD command
  • D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
  • E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
Reveal Solution Hide Solution   Discussion   1

Correct Answer: AC 🗳️

Question #3 Topic 1

Which of the following statements about compression for BLU MPP tables is TRUE?

  • A. Compression must be explicitly enabled for BLU MPP tables
  • B. Compression requires decompression to evaluate partition joins
  • C. Unique compression dictionaries are generated for each partition
  • D. Each table has a single compression dictionary that gets replicated across all partitions
Reveal Solution Hide Solution   Discussion   2

Correct Answer: D 🗳️
Reference:
http://www.idug.org/p/bl/et/blogaid=503

Question #4 Topic 1

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity
(inserts, updates, and deletes).

Sunday Delta -

Monday Incremental -

Tuesday Delta -

Wednesday Delta -

Thursday Incremental -

Friday Delta -

Saturday Full -
Which day would you expect a RECOVER DATABASE following that days backup to take the longest time to complete?

  • A. Friday
  • B. Monday
  • C. Saturday
  • D. Wednesday
Reveal Solution Hide Solution   Discussion   3

Correct Answer: A 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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.

SaveCancel