C2090_610 questions • Exam prepare

Exam contains 135 questions

Page 19 of 23

Question 109 🔥

Which statement about UPDATE processing is FALSE?

Which database solution meets these requirements?

A. The UPDATE statement logs the before and after value of every column it modifies.

B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.

D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

Discussion of the question

Question 110 🔥

Given the following statements:What will be the result?

Which database solution meets these requirements?

A. Joe Smith

B. <name>Joe Smith</name>

C. <name>Joe Smith></name><name>DB2</name>

D. <employeeinfo><name>Joe Smith</name></employeeinfo>

Discussion of the question

Question 111 🔥

A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?

Which database solution meets these requirements?

A. SELECT state_cd, COUNT(*)FROM statesORDER BY COUNT(*);

B. SELECT state_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY state_cd;

C. SELECT region_cd, COUNT(*)FROM statesGROUP BY state_cdORDER BY COUNT(*);

D. SELECT region_cd, COUNT(*)FROM statesGROUP BY region_cdORDER BY COUNT(*);

Discussion of the question

Question 112 🔥

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

Which database solution meets these requirements?

A. The SYSIBM schema.

B. The SYSFUN schema.

C. A schema with the name of the UDF.

D. A schema with the userid of the UDF definer.

Discussion of the question

Question 113 🔥

What is a function of a table check constraint?

Which database solution meets these requirements?

A. To provide a method of avoiding duplicate entries for a column.

B. To provide a method of ensuring a column's values are within a specific range.

C. To ensure that XML columns are properly populated in an associated XML table space.

D. To enforce relationships between tables by checking the existence of rows in one table against another.

Discussion of the question

Question 114 🔥

Which statement about foreign keys is true?

Which database solution meets these requirements?

A. A table can have only one foreign key.

B. Foreign keys can only be defined when a table is created.

C. A foreign key can be defined on a column or a set of columns in a table.

D. Foreign keys are enforced only during the execution of INSERT statements.

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