IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 81:

  Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

  A. BIGINT
  B. BINARY
  C. DOUBLE
  D. DECIMAL
  D. DECIMAL

• Question 82:

  When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

  A. The data in the table is deleted and the table persists.
  B. The data in the table is deleted and the table is implicitly dropped.
  C. The temporary table is converted to a base table and the data is deleted.
  D. The temporary table is converted to a base table and the data is persistent.
  B. The data in the table is deleted and the table is implicitly dropped.

• Question 83:

  When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

  A. The SYSIBM schema.
  B. The SYSFUN schema.
  C. A schema with the name of the UDF.
  D. A schema with the userid of the UDF definer.
  D. A schema with the userid of the UDF definer.

• Question 84:

  Which statement about UPDATE processing is FALSE?

  A. The UPDATE statement logs the before and after value of every column it modifies.
  B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.
  C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
  D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.
  C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.

• Question 85:

  User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:

  -The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended university Which SQL statement will accomplish this?

  A. SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education = 'University')
  B. SELECT * FROM employee WHERE (hiredate < '1999-01-01') OR (salary < 40000) OR (education = 'University')
  C. SELECT * FROM employee WHERE (hiredate < '1999-01-01' OR (salary < 40000 AND (education = 'University')
  D. SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000 AND (education = 'University')
  A. SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education = 'University')

• Question 86:

  What are two valid objects that can be created in DB2? (Choose two.)

  A. Tree
  B. Node
  C. Trigger
  D. Contexts
  E. Sequence
  C. Trigger
  E. Sequence

• Question 87:

  A table named STATES has the following columns:

  STATE_CD, REGION_CD, and STATE_NAME.

  Which SQL statement will return the number of states in each region, ordered by number of states?

  A. SELECT state_cd, COUNT(*) FROM states ORDER BY COUNT(*);
  B. SELECT state_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY state_cd;
  C. SELECT region_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY COUNT(*);
  D. SELECT region_cd, COUNT(*) FROM states GROUP BY region_cd ORDER BY COUNT(*);
  D. SELECT region_cd, COUNT(*) FROM states GROUP BY region_cd ORDER BY COUNT(*);

• Question 88:

  What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

  A. Lock wait
  B. Lock timeout
  C. Lock escalation
  D. Lock conversion
  D. Lock conversion

• Question 89:

  What factor influences lock escalation?

  A. Table size
  B. Buffer space
  C. Number of locks
  D. Available real storage
  C. Number of locks

• Question 90:

  In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

  A. Locked
  B. Waiting
  C. Pending
  D. Unconnected
  D. Unconnected