IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 131:

  Given the following statement:

  GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;

  Which statement is correct?

  A. USER1 can only remove the SALES table.
  B. USER1 can only remove records from the SALES table.
  C. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
  D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.
  D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

• Question 132:

  Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

  A. View
  B. Index
  C. Trigger
  D. Check constraint
  A. View

• Question 133:

  Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

  A. ALTER TABLE sales ADD COLUMN item CHAR(40);
  B. ALTER TABLE sales ALTER COLUMN item CHAR(40);
  C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);
  D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
  D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

• Question 134:

  Which type of stored procedure is not associated with an external application program?

  A. A Java stored procedure.
  B. A REXX stored procedure.
  C. A native SQL stored procedure.
  D. An external SQL stored procedure.
  C. A native SQL stored procedure.

• Question 135:

  Which statement about system-period temporal tables is true?

  A. They store user-based period information.
  B. They do not have a separate history table.
  C. They can be queried without a time period specification.
  D. They manage data based on time criteria specified by users or applications.
  C. They can be queried without a time period specification.

• Question 136:

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

  A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP 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 job, MIN(salary), MAX(salary);
  D. SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);
  A. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

• Question 137:

  Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

  A. View
  B. Table
  C. Sequence
  D. Identity Column
  C. Sequence

• Question 138:

  The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

  A. Concurrent application processes from performing any operations on the table.
  B. Concurrent application processes from performing any read-only operations on the table.
  C. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.
  D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.
  A. Concurrent application processes from performing any operations on the table.