C2090_610 questions • Exam prepare

Exam contains 135 questions

Page 21 of 23

Question 121 🔥

What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?

Which database solution meets these requirements?

A. To override the limit on index key columns.

B. To further enforce the uniqueness of index values.

C. To combine two or more indexes to create a single unique index.

D. To improve performance of some queries by allowing index-only access.

Discussion of the question

Question 122 🔥

What are INSTEAD OF triggers used for?

Which database solution meets these requirements?

A. To update data in other tables.

B. To perform insert, update, and delete operations against complex views.

C. To check or modify values before they are actually stored in a database.

D. To run non-database operations that are coded in user-defined functions.

Discussion of the question

Question 123 🔥

User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

Which database solution meets these requirements?

A. CREATE TABLE parts(part_no INTEGER,desc CLOB))

B. CREATE TABLE parts(part_no INTEGER,desc VARCHAR(200))

C. CREATE TABLE parts(part_no INTEGER,desc CLOB FOR BIT DATA))

D. CREATE TABLE parts(part_no INTEGER,desc VARCHAR(200) FOR BIT DATA)

Discussion of the question

Question 124 🔥

What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

Which database solution meets these requirements?

A. Trigger

B. Procedure

C. Table function

D. Scalar function

Discussion of the question

Question 125 🔥

Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

Which database solution meets these requirements?

A. BIGINT

B. BINARY

C. DOUBLE

D. DECIMAL

Discussion of the question

Question 126 🔥

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

Which database solution meets these requirements?

A. 1) Create a primary key on table TAB1;2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.

B. 1) Create a primary key on table TAB2;2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.

C. 1) Create a primary key on table TAB1;2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.

D. 1) Create a primary key on table TAB2;2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE

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