IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 131:

  Which of the following DB2 data types has a fixed length?

  A. XML
  B. BLOB
  C. DOUBLE
  D. DBCLOB
  C. DOUBLE

• Question 132:

  If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

  A. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information
  B. View V1 can be used as a data source for other views
  C. View V1 does not have to reside in the same schema as the EMPLOYEE table
  D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1
  D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

• Question 133:

  A table called DEPARTMENT has the following columns:

  DEPT_ID DEPT_NAME MANAGER

  Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

  A. GRANT ALTER ON TABLE department TO user1
  B. GRANT ALTER (dept_name) ON TABLE department TO user1
  C. GRANT UPDATE ON TABLE department TO user1
  D. GRANT UPDATE (dept_name) ON TABLE department TO user1
  D. GRANT UPDATE (dept_name) ON TABLE department TO user1

• Question 134:

  Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ:

  PREVIOUS VALUE FOR my_seq

  After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

  A. After a ROLLBACK is issued
  B. After the sequence is altered
  C. After the sequence is dropped
  D. After the current session ends
  A. After a ROLLBACK is issued

• Question 135:

  A stored procedure object is created into which DB2 object?

  A. Alias
  B. Schema
  C. Package
  D. Routine Space
  B. Schema

• Question 136:

  If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?

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

• Question 137:

  Which type of key is defined on the child table to implement a referential constraint?

  A. Unique key
  B. Primary key
  C. Foreign key
  D. Composite key
  B. Primary key

• Question 138:

  Which type of key is defined on the child table to implement a referential constraint?

  A. Unique key
  B. Primary key
  C. Foreign key
  D. Composite key
  C. Foreign key

• Question 139:

  Given the following requirements:

  Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.

  Which of the following CREATE statements will successfully create this table?

  A. CREATE TABLEemp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );
  B. CREATE TABLEemp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );
  C. CREATE TABLEemp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
  D. CREATE TABLEemp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );
  D. CREATE TABLEemp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );

• Question 140:

  Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?

  A. An application process acquires at least a share lock on the current row of every cursor.
  B. Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
  C. Any row changed by another application process can be read, even if the change has not been committed by that application process.
  D. An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
  A. An application process acquires at least a share lock on the current row of every cursor.