Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-600

IBM C2090-600 Exam Practice Questions (P. 1)

  • Full Access (60 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #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?
  1. A
    UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE
  2. B
    UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
  3. C
    CONNECT TO sample; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC IMMEDIATE; CONNECT RESET;
  4. D
    ATTACH TO db2inst1; UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;

Correct Answer:
C

Question #2
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
  1. A
    Catalog a storage access alias in the DB2 database
  2. B
    Create an FTP account on IBM Softlayer Object Storage
  3. C
    Use the DB2REMOTE parameter of the LOAD command
  4. D
    Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
  5. E
    Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Correct Answer:
AC

Question #3
Which of the following statements about compression for BLU MPP tables is TRUE?
  1. A
    Compression must be explicitly enabled for BLU MPP tables
  2. B
    Compression requires decompression to evaluate partition joins
  3. C
    Unique compression dictionaries are generated for each partition
  4. D
    Each table has a single compression dictionary that gets replicated across all partitions

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

Question #4
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?
  1. A
    Friday
  2. B
    Monday
  3. C
    Saturday
  4. D
    Wednesday

Correct Answer:
A

Question #5
Which statement about NOT ENFORCED unique constraints is TRUE?
  1. A
    NOT ENFORCED unique constraints can not be defined on primary key columns
  2. B
    The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
  3. C
    When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned
  4. D
    Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Correct Answer:
A

Next Questions

All Pages