Create Next App

Exam contains 115 questions

Page 18 of 20

Question 103 🔥

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALLWhat will happen?

Which database solution meets these requirements?

A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.

Highly voted

B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.

Highly voted

C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.

Highly voted

D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.

Highly voted

Discussion of the question

Question 104 🔥

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

Which database solution meets these requirements?

A. To terminate a failed INGEST command.

Highly voted

B. To restart a failed INGEST command from the beginning.

Highly voted

C. To clean up the log records of a failed INGEST command.

Highly voted

D. To restart a failed INGEST command from the last commit point.

Highly voted

Discussion of the question

Question 105 🔥

What are two types of check options that can be used to create views? (Choose two.)

Which database solution meets these requirements?

Discussion of the question

Question 106 🔥

Which statement about referential constraints is true?

Which database solution meets these requirements?

A. A referential constraint can be defined against a catalog table.

Highly voted

B. A referential constraint can be defined on both tables and views.

Highly voted

C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.

Highly voted

D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.

Highly voted

Discussion of the question

Question 107 🔥

Which statement about primary keys is true?

Which database solution meets these requirements?

A. A table can have multiple primary keys.

Highly voted

B. A primary key accepts one, and only one, NULL value.

Highly voted

C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.

Highly voted

D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

Highly voted

Discussion of the question

Question 108 🔥

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

Which database solution meets these requirements?

A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED

Highly voted

B. ALTER TABLE mytab CHECK (COL IS VALIDATED)

Highly voted

C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED

Highly voted

D. ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_611

Exam contains 115 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us