IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 271:

  Which of the following will allow user USER1 to change the comment associated with a table named TABLE1?

  A. GRANT UPDATE ON TABLE table1 TO user1
  B. GRANT CONTROL ON TABLE table1 TO user1
  C. GRANT ALTER ON TABLE table1 TO user1
  D. GRANT REFERENCES ON TABLE table1 TO user1
  C. GRANT ALTER ON TABLE table1 TO user1

• Question 272:

  Given the following CREATE TABLE statement:

  CREATE TABLE table2 LIKE table1

  Which two of the following will NOT occur when the statement is executed?

  A. TABLE2 will have the same column names and column data types as TABLE1
  B. TABLE2 will have the same column defaults as TABLE1
  C. TABLE2 will have the samenullability characteristics as TABLE1
  D. TABLE2 will have the same indexes as TABLE1. E. TABLE2 will have the same referential constraints as TABLE1
  D. TABLE2 will have the same indexes as TABLE1. E. TABLE2 will have the same referential constraints as TABLE1

• Question 273:

  How does DB2 protect the integrity of indexes when data is updated?

  A. Locks are acquired on the data.
  B. Locks are acquired on index keys.
  C. Locks are acquired on index pages.
  D. Locks are acquired on index pointers.
  A. Locks are acquired on the data.

• Question 274:

  The EMPLOYEE table contains the following information:

  EMPNO NAME WORKDEPT

  101 SAM A11 102 JOHN C12 103 JANE 104 PAT Remote 105 ANNE 106 BOB A11

  The MANAGER table contains the following information:

  MGRID NAME DEPTNO EMPCOUNT

  1 WU B01 2 JONES A11 3 CHEN - 4 SMITH - 5 THOMAS C12

  After this statement is executed:

  UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno)

  What is the result of the following query?

  SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid

  A. MGRID EMPCOUNT ----- -------- 1 0 22 5 1
  B. MGRID EMPCOUNT ----- -------- 1 0 22 3 0 4 0 5 1
  C. MGRID EMPCOUNT ----- -------- 1 3 2 33 3 4 3 5 3
  D. MGRID EMPCOUNT ----- -------- 1 0 22 3 2 4 2 5 1
  B. MGRID EMPCOUNT ----- -------- 1 0 22 3 0 4 0 5 1

• Question 275:

  Which two of the following are optional and do not have to be specified when creating a table?

  A. Table name
  B. Column name
  C. Default constraint
  D. Column data type
  E. NOT NULL constraint
  C. Default constraint
  E. NOT NULL constraint

• Question 276:

  60 Which of the following best describes how locks are used in DB2?

  A. To maintain control of updated rows for commit processing
  B. To ensure only committed changes are altered by another application
  C. To allow two applications to update the same row of data simultaneously
  D. To prevent multiple applications from accessing the same data simultaneously
  B. To ensure only committed changes are altered by another application

• Question 277:

  To which of the following resources can a lock NOT be applied?

  A. Table spaces
  B. Buffer pools
  C. Tables
  D. Rows
  B. Buffer pools

• Question 278:

  What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?

  A. A check constraint on the EMPLOYEE table
  B. A unique constraint on the EMPLOYEE table WORKDEPT column
  C. A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
  D. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
  D. A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

• Question 279:

  Given the following two tables:

  EMPLOYEE

  ID NAME DEPTID

  01 Mick Jagger 10 02 Keith Richards 20 03 Ronnie Wood 20 04 Charlie Watts 20 05 Bill Wyman 30 06 Brian Jones

  DEPARTMENT

  ID DEPTNAME

  10 Executive Staff 20 Sales 30 Marketing 40 Engineering 50 Human Resources

  Which two of the following queries will display the employee name and department name for all employees that are in Sales?

  A. SELECT e.name,d.deptname FROM employee e, department d WHERE e.deptid = d.id AND d.id = '20'
  B. SELECT e.name,d.deptname FROM employee e FULL OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'
  C. SELECT e.name,d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'
  D. SELECT e.name,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'
  E. SELECT e.name,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE d.id = '20'
  D. SELECT e.name,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'
  E. SELECT e.name,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

• Question 280:

  If the following SQL statements are executed:

  CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));

  CREATE TABLE model (modelid SMALLINT,

  model VARCHAR(25),

  makeid SMALLINT,

  CONSTRAINT const1 FOREIGN KEY (makeid)

  REFERENCES make(makeid) ON DELETE RESTRICT);

  And each table created is populated as follows: MAKE MAKEID MAKE 1 Ford

  2 Chevrolet 3 Toyota MODEL

  MODELID MODEL MAKEID 1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3

  If the following SQL statement is executed:

  DELETE FROM make WHERE makeid = 1

  What is the total number of rows that will be deleted?

  B. 1
  C. 2
  D. 3
  A