Create Next App

Exam contains 117 questions

Page 8 of 20

Question 43 🔥

Which two statements are true about the COMMIT WORK statement? (Choose two.)

Which database solution meets these requirements?

A. The keyword WORK is optional.

Highly voted

B. A single COMMIT WORK can end several BEGIN WORK statements.

Highly voted

C. The COMMIT WORK statement releases all row locks but not table locks.

Highly voted

D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.

Highly voted

E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.

Highly voted

Discussion of the question

Question 44 🔥

Which statement will change the column address1 to a null value?

Which database solution meets these requirements?

A. UPDATE customer SET address1 = null WHERE customer_num = 134;

Highly voted

B. UPDATE customer SET address1 = ' ', SET address2 = null WHERE customer_num = 134;

Highly voted

C. UPDATE customer SET address1 = "" WHERE customer_num = 134;

Highly voted

D. UPDATE customer SET address1 = '',

Highly voted

Discussion of the question

Question 45 🔥

Which two statements will delete all rows from table_name? (Choose two.)

Which database solution meets these requirements?

A. DROP FROM table_name ;

Highly voted

B. DELETE FROM table_name ;

Highly voted

C. DELETE * FROM table_name ;

Highly voted

D. TRUNCATE TABLE table_name ;

Highly voted

E. DELETE ALL FROM table_name ;

Highly voted

Discussion of the question

Question 46 🔥

Given the query shown below:What will happen?

Which database solution meets these requirements?

A. All rows will be retrieved in which item_desc contains the characters 'pencil'.

Highly voted

B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.

Highly voted

C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.

Highly voted

D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.

Highly voted

Discussion of the question

Question 47 🔥

Which of the following statements can be used to prevent duplicate values in an indexed column?

Which database solution meets these requirements?

A. CREATE HASH INDEX

Highly voted

B. CREATE UNIQUE INDEX

Highly voted

C. CREATE DISTINCT TYPE

Highly voted

D. CREATE CLUSTER INDEX

Highly voted

Discussion of the question

Question 48 🔥

When restoring data, which granularity of object may NOT be restored?

Which database solution meets these requirements?

A. a single table

Highly voted

B. a single chunk

Highly voted

C. a single dbspace

Highly voted

D. an entire instance

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_558

Exam contains 117 questions

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

Company

Product

Resources

Follow us