IBM IBM Certifications C2090-558 Questions & Answers

• Question 71:

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

  A. DROP FROM table_name ;

  B. DELETE FROM table_name ;

  C. DELETE * FROM table_name ;

  D. TRUNCATE TABLE table_name ;

  E. DELETE ALL FROM table_name ;

  Correct Answer: BD

• Question 72:

  Given the query shown below:

  

  What will happen?

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

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

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

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

  Correct Answer: A

• Question 73:

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

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

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

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

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

  Correct Answer: A

• Question 74:

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

  A. The keyword WORK is optional.

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

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

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

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

  Correct Answer: AD

• Question 75:

  Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

  A. INSERT INTO orders SELECT * FROM new_orders;

  B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");

  C. DELETE FROM stock WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)

  D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip FROM newaddr WHERE newaddr.customer_num = customer.customer_num) WHERE customer_num IN (SELECT customer_num FROM newaddr);

  Correct Answer: B

• Question 76:

  User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

  A. DBA on the database

  B. EXECUTE on the procedure

  C. RESOURCE on the database

  D. SELECT on the tables used in the procedure

  Correct Answer: B

• Question 77:

  Click the Exhibit button.

  Which of the following will display the values in the lead_time column from highest to lowest?

  A. SELECT * FROM manufact ORDER BY lead_time

  B. SELECT * FROM manufact ORDER BY lead_time ASC

  C. SELECT * FROM manufact ORDER BY lead_time HIGH

  D. SELECT * FROM manufact ORDER BY lead_time DESC

  Correct Answer: D

• Question 78:

  In which two places may a function be used in a SELECT statement? (Choose two.)

  A. in a subquery

  B. in a HAVING clause

  C. in a GROUP BY clause

  D. in the ORDER BY clause

  E. in the select (or projection) list

  Correct Answer: AE

• Question 79:

  Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

  A. a primary key

  B. a unique index

  C. a virtual column

  D. a unique constraint

  Correct Answer: A

• Question 80:

  In which way is a Remote Standalone (RS) secondary server different from a High- Availability Data Replication (HDR) secondary server?

  A. RS secondary servers do not support DRAUTO.

  B. RS secondary servers support replication at the column level

  C. You can have more than one RS secondary server in a cluster.

  D. RS secondary servers can be directly upgraded to a primary server.

  Correct Answer: C