Free IBM C1000-085 Exam Dumps Questions & Answers

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

• A.It reclaims space from deleted rows and re-orders data.
• B.GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.
• C.Enough space is required for GROOM to make a complete copy of the table
• D.It reclaims space from deleted rows and does not re-order data

Which two cross-database SQL operations are allowed?

• A.DELETE
• B.ALTER VIEW
• C.ALTER TABLE
• D.CREAE TABLE
• E.REVOKE

To how many resource groups can a user be assigned?

• A.one
• B.three
• C.unlimited
• D.four

Which two commands can be used to get a plan file for a query?

• A.nz_get <planid>
• B.nzsql -c "get planfile <planid>"
• C.nzsql -c "select plan_text from _v_plan"
• D.nzsql -c "show planfile <planid>"
• E.nz_plan <planid>

Which two file formats are valid for external tables?

• A.fixed-length
• B.JSON
• C.XML
• D.text-delimited
• E.HL7