IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 121:

  Which of the following isolation levels will lock all rows scanned to build a result data set?

  A. Uncommitted Read
  B. Cursor Stability
  C. Read Stability
  D. Repeatable Read
  D. Repeatable Read

• Question 122:

  The following SQL statements were executed in sequence:

  CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS; CREATE TABLE staffsalary(empid INT, empsalary salary); INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00); UPDATE staffsalary SET empsalary =

  60000

  What is the current content of the staffsalary table?

  A. ID | EMPSALARY ----------------- 10 | 60000 20 | 50000.00 ----------------
  B. ID | EMPSALARY ----------------- 10 | 50000.00 20 | 50000.00 ----------------
  C. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 60000.00 ----------------
  D. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 50000.00 ----------------
  C. ID | EMPSALARY ----------------- 10 | 60000.00 20 | 60000.00 ----------------

• Question 123:

  Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

  A. It will randomly pick an application and rollback its current transaction
  B. Itwill rollback the current transactions of both applications
  C. It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved
  D. It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction
  A. It will randomly pick an application and rollback its current transaction

• Question 124:

  What is the purpose of the Design Advisor?

  A. To analyze workloads and make recommendations for indexes and MQTs
  B. To present a graphical representation of a data access plan and recommend design changes that will improve performance
  C. To replicate data between a DB2 database and another relational database
  D. To configure clients so they can access databases stored on remote servers
  A. To analyze workloads and make recommendations for indexes and MQTs

• Question 125:

  If the following SQL statements are executed in the order shown:

  CREATE TABLE orders (order_num INTEGER NOT NULL, buyer_name VARCHAR(35), amount NUMERIC(5,2));

  CREATE UNIQUE INDEX idx_orderno ON orders (order_num);

  Which of the following describes the resulting behavior?

  A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values
  B. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows will be displayed in no particular order
  C. Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS table that reference the ORDER_NUM column
  D. Every ORDER_NUM value entered must be unique; no other index can be created for the ORDERS table that reference the ORDER_NUM column
  A. Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried rows should be displayed in order of increasing ORDER_NUM values

• Question 126:

  Which of the following is NOT a characteristic of an OLTP database?

  A. Granular transactions
  B. Current data
  C. Optimized for queries
  D. Frequent updates
  C. Optimized for queries

• Question 127:

  Which of the following is a characteristic of a sequence?

  A. A sequence will never generate duplicate values.
  B. The MAXVALUE of a sequence can be equal to the MINVALUE.
  C. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.
  D. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.
  B. The MAXVALUE of a sequence can be equal to the MINVALUE.

• Question 128:

  Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?

  A. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1
  B. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1
  C. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1
  D. GRANT CONTROL ON TABLE table1 TO user1 AND group1
  B. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

• Question 129:

  Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?

  A. GRANT ADD DATA ON TABLE tab1 TO GROUP tomappgrp
  B. GRANT INSERT TO USER tom, GROUPappgrp ON TABLE tab1
  C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp
  D. GRANT ADD DATA ON TABLE tab1 TO USERappgrp, GROUP tom
  C. GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp

• Question 130:

  Which of the following will DELETE all of the rows from table T03?

  A. DELETE * FROM TABLE T03
  B. DELETE ALL FROM T03
  C. DELETE * FROM T03
  D. DELETE FROM T03
  D. DELETE FROM T03