IBM IBM Certified Database Associate C2090-730 Questions & Answers

• Question 71:

  Which of the following CANNOT be used to restrict specific values from being inserted into a column in a particular table?

  A. Index

  B. Check constraint

  C. Referential constraint

  D. Default constraint

  Correct Answer: D

• Question 72:

  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

  Correct Answer: D

• Question 73:

  Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?

  A. Unique

  B. Check

  C. Referential

  D. Informational

  Correct Answer: B

• Question 74:

  A view is created with the following statement:

  CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ;

  When will DB2 access the data from table T1 for view V1?

  A. When view V1 is created

  B. Each time the REFRESH VIEW v1 statement is executed

  C. Each time an SQL statement is executed against view V1

  D. Only the first time an SQL statement is executed against view V1

  Correct Answer: C

• Question 75:

  Which of the following database objects can be used to raise an error if a table is updated?

  A. Package

  B. Trigger

  C. Stored Procedure

  D. Informational Constraint

  Correct Answer: B

• Question 76:

  Which of the following is a characteristic of a schema?

  A. Foreign key references cannot cross schema boundaries.

  B. A DB2 user must be created before a schema with the same name can be created.

  C. If no schema is specified when an object is created, the default schema PUBLIC is used.

  D. A schema enables the creation of multiple objects in a database without encountering namespace collisions.

  Correct Answer: D

• Question 77:

  Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?

  A. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.

  B. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).

  C. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

  D. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

  Correct Answer: C

• Question 78:

  An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?

  A. GRAPHIC

  B. BINARY

  C. IMAGE

  D. BLOB

  Correct Answer: D

• Question 79:

  If the following SQL statements are executed:

  CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

  CREATE TABLE tab2 (empid SMALLINT,

  weekno SMALLINT,

  payamt DECIMAL(6,2),

  CONSTRAINT const1 FOREIGN KEY (empid)

  REFERENCES taba(id) ON UPDATE NO ACTION);

  Which of the following statements is true?

  A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  B. The updating of values in the ID column of table TAB1 is not allowed

  C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

  D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well

  Correct Answer: A

• Question 80:

  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

  Correct Answer: DE