Create Next App

Exam contains 135 questions

Page 11 of 23

Question 61 🔥

Which statement is true regarding constraints?

Which database solution meets these requirements?

A. A table can only have one unique key constraint.

Highly voted

B. A table can have multiple primary key constraints.

Highly voted

C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

Highly voted

D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreign key.

Highly voted

Discussion of the question

Question 62 🔥

By default, where is the data stored for a column defined with an XML data type?

Which database solution meets these requirements?

A. In an XML index.

Highly voted

B. In line with the rest of the data for the table.

Highly voted

C. In an XML storage object that is separate from the table.

Highly voted

D. In line with the rest of the data for the table, for XML columns less than 32KB.

Highly voted

Discussion of the question

Question 63 🔥

Which statement about BEFORE triggers is FALSE?

Which database solution meets these requirements?

A. A BEFORE trigger can be used to perform validation of input data.

Highly voted

B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.

Highly voted

C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

Highly voted

D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

Highly voted

Discussion of the question

Question 64 🔥

What is used in conjunction with a foreign key to define a relationship between two tables?

Which database solution meets these requirements?

A. Primary key

Highly voted

B. Partitioning key

Highly voted

C. Check constraint

Highly voted

D. Unique constraint

Highly voted

Discussion of the question

Question 65 🔥

Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

Which database solution meets these requirements?

A. Change the data type of the sequence.

Highly voted

B. Reset the sequence to its starting value.

Highly voted

C. Establish new minimum or maximum values.

Highly voted

D. Change the increment between future values.

Highly voted

Discussion of the question

Question 66 🔥

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

Which database solution meets these requirements?

A. 4

Highly voted

B. 8

Highly voted

D. 32

Highly voted

C. 16

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_610

Exam contains 135 questions

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

Company

Product

Resources

Follow us