IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 31:

  Which of the following privileges allow a user to update the comment on a sequence?

  A. ALTER
  B. USAGE
  C. UPDATE
  D. COMMENT
  A. ALTER

• Question 32:

  Which statement about triggers is true?

  A. A trigger is designed to return specific types of values and contains executable code.
  B. A trigger is designed to return specific types of values but contains no executable code.
  C. A trigger performs actions to capture details about an activity like a join operation against multiple tables.
  D. A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.
  D. A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.

• Question 33:

  Which statement will prevent concurrent application processes from performing anything other than read- only operations against a table named TAB1?

  A. LOCK TABLE tab1 IN READ MODE
  B. LOCK TABLE tab1 IN SHARE MODE
  C. LOCK TABLE tab1 IN EXCLUSIVE MODE
  D. LOCK TABLE tab1 IN READ-ONLY MODE
  B. LOCK TABLE tab1 IN SHARE MODE

• Question 34:

  Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?

  A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY job;
  B. SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;
  C. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY SALARY ORDER BY job;
  D. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY MIN(salary), MAX(salary) ORDER BY job;
  A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY job;

• Question 35:

  Which database object provides an alternative way of describing data that exists in one or more base tables?

  A. Alias
  B. View
  C. ndex
  D. Sequence
  B. View

• Question 36:

  If a table named MY_TAB contains 100 rows and the following statement is executed:

  

  How many rows will be updated?

  B. 1
  C. 10
  D. 99
  C. 10

• Question 37:

  What is the primary function of an Online Transaction Processing (OLTP) workload?

  A. To combine data from multiple sources.
  B. To discover hidden relationships in data.
  C. To analyze large amounts of data to find patterns.
  D. To make changes to a small number of records within a single transaction.
  D. To make changes to a small number of records within a single transaction.

• Question 38:

  Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

  A. REVOKE USE OF TABLESPACE mytbsp FROM user1
  B. REVOKE ALTER ON TABLESPACE mytbsp FROM user1
  C. REVOKE UPDATE OF TABLESPACE mytbsp FROM user1
  D. REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1
  A. REVOKE USE OF TABLESPACE mytbsp FROM user1

• Question 39:

  What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

  A. locator
  B. pointer
  C. address
  D. reference
  A. locator

• Question 40:

  Which DB2 product is NOT suitable for very large data warehouse applications?

  A. DB2 for i
  B. DB2 for AIX
  C. DB2 for z/OS
  D. DB2 for Linux
  A. DB2 for i