IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 11:

  Which statement about INSERT operations is true?

  A. The INSERT statement is used to insert rows into a table, view, or table function.
  B. Inserted values must satisfy the conditions of any check constraints defined on the table.
  C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.
  D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.
  B. Inserted values must satisfy the conditions of any check constraints defined on the table.

• Question 12:

  If no isolation level is specified, what is the default isolation level used?

  A. Cursor Stability (CS)
  B. Repeatable Read (RR)
  C. Read Stability (RS) with Currently Committed semantics
  D. Cursor Stability (CS) with Currently Committed semantics
  A. Cursor Stability (CS)

• Question 13:

  User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?

  A. CREATE TABLE parts (part_no INTEGER, desc CLOB))
  B. CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200))
  C. CREATE TABLE parts (part_no INTEGER, desc CLOB FOR BIT DATA))
  D. CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200) FOR BIT DATA)
  D. CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200) FOR BIT DATA)

• Question 14:

  Which isolation level offers the greatest protection of data but provides the least amount of concurrency?

  A. Read Stability (RS)
  B. Cursor Stability (CS)
  C. Repeatable Read (RR)
  D. Uncommitted Read (UR)
  C. Repeatable Read (RR)

• Question 15:

  Given the following statements:

  

  What will be the result?

  A. Joe Smith
  B. Joe Smith
  C. Joe Smith>DB2
  D. Joe Smith
  B. Joe Smith

• Question 16:

  What is the purpose of a role?

  A. To define exactly what a specific user can do within a particular database once they have been authenticated.
  B. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.
  C. To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.
  D. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.
  B. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

• Question 17:

  Which statement is valid about the Row and Column Access Control (RCAC) feature?

  A. A row mask's access control rule is defined by an SQL CASE expression; a column permission's access control rule is defined by an SQLsearch condition.
  B. A row permission's access control rule is defined by an SQL CASE expression; a column mask's access control rule is defined by an SQLsearch condition.
  C. A row mask's access control rule is defined by an SQL search condition; a column permission's access control rule is defined by an SQL CASEexpression.
  D. A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.
  D. A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.

• Question 18:

  Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

  A. Change the data type of the sequence.
  B. Reset the sequence to its starting value.
  C. Establish new minimum or maximum values.
  D. Change the increment between future values.
  A. Change the data type of the sequence.

• Question 19:

  What factor influences lock conversion/promotion?

  A. Lock size
  B. Number of locks
  C. Lock mode needed
  D. Available real storage
  C. Lock mode needed

• Question 20:

  Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?

  A. Type-1 connect
  B. Type-2 connect
  C. Type-3 connect
  D. Type-4 connect
  B. Type-2 connect