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. 4)

  • 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 #16
Which statement regarding event monitors is TRUE?
  1. A
    Event monitor data can be reviewed while the event monitor is active
  2. B
    Event monitors must always be started manually after activating a database
  3. C
    Event monitors must write data to .EVT files before the data can be loaded into database tables
  4. D
    Event monitors are used to obtain information about how a database system looks at a specific point in time

Correct Answer:
B
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000915.html

Question #17
Which options are valid for an online reorganization operation?
  1. A
    FULL and RECLAIM EXTENTS
  2. B
    CLASSIC and RECLAIM EXTENTS
  3. C
    FULL and CLEANUP OVERFLOWS
  4. D
    CLEAN OVERFLOWS and RECLAIM EXTENTS

Correct Answer:
A

Question #18
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the
SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?
  1. A
    REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
  2. B
    REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND INDEXES ALL;
  3. C
    RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
  4. D
    RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Correct Answer:
A

Question #19
Which of the following are valid Explain operators? (Choose two.)
  1. A
    CTQ
  2. B
    XSCAN
  3. C
    IXSCAN
  4. D
    SELECT
  5. E
    COLSCAN

Correct Answer:
BC
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.explain.doc/doc/r0052023.html

Question #20
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
  1. A
    CONNECT TO mydb PRUNE HISTORY TO /outdir
  2. B
    db2trc on –db mydb –m "backup,load" run the desired operations db2tc dump db2trc.dmp db2tc format db2tc.dmp db2tc.fmt db2tc off
  3. C
    BACKUP DATABASE mydb NO TABLESPACE TO /outdir
  4. D
    db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed). Run the desired operations.

Correct Answer:
B

Previous Questions Next Questions

All Pages