IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 81:

  Which of the following DB2 tools allows a user to set DB2 registry parameters?

  A. Task Center
  B. Visual Explain
  C. Configuration Assistant
  D. Satellite Administration Center
  C. Configuration Assistant

• Question 82:

  Which of the following is NOT a valid method of authentication that can be used by DB2 9?

  A. SERVER
  B. SERVER_ENCRYPT
  C. CLIENT
  D. DCS
  D. DCS

• Question 83:

  Given the following statement:

  SELECT hyear, AVG(salary)

  FROM (SELECT YEAR(hiredate) AS hyear, salary

  FROM employee WHERE salary > 30000)

  GROUP BY hyear

  Which of the following describes the result if this statement is executed?

  A. The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.
  B. The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.
  C. The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.
  D. The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.
  B. The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.

• Question 84:

  Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock.

  Which isolation level should Application B run under to achieve this objective?

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

• Question 85:

  Given the following set of statements:

  CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));

  COMMIT;

  INSERT INTO tab1 VALUES (123, 'Red');

  INSERT INTO tab1 VALUES (456, 'Yellow');

  SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;

  DELETE FROM tab1 WHERE col1 = 123;

  INSERT INTO tab1 VALUES (789, 'Blue');

  ROLLBACK TO SAVEPOINT s1;

  INSERT INTO tab1 VALUES (789, 'Green');

  UPDATE tab1 SET col2 = NULL WHERE col1 = 789;

  COMMIT;

  Which of the following records would be returned by the following statement?

  SELECT * FROM tab1

  A. COL1 COL2 123 Red 456 Yellow 2 record(s) selected.
  B. COL1 COL2 456 Yellow 1 record(s) selected.
  C. COL1 COL2 123 Red 456 Yellow 3 record(s) selected.
  D. COL1 COL2 123 Red 456 Yellow 789 Green 3 record(s) selected.
  C. COL1 COL2 123 Red 456 Yellow 3 record(s) selected.

• Question 86:

  Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

  A. The cursor is only protected from updates and deletes by concurrent applications.
  B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
  C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
  D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application
  A. The cursor is only protected from updates and deletes by concurrent applications.

• Question 87:

  Which of the following resources can be explicitly locked?

  A. Row
  B. Page
  C. Table
  D. Column
  C. Table

• Question 88:

  Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?

  A. LIST DB DIRECTORY
  B. LIST DCS DIRECTORY
  C. LIST NODE DIRECTORY
  D. LIST ACTIVE DATABASES
  B. LIST DCS DIRECTORY

• Question 89:

  What does the following statement do?

  A. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.
  B. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give CONTROL authority for the sequence to other users and groups.
  C. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
  D. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
  C. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.

• Question 90:

  A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month's data?

  A. Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
  B. Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re-create the view.
  C. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
  D. Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
  C. Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.