IBM IBM Certifications C2090-616 Questions & Answers

• Question 51:

  You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?

  Which of the following editions would be best meet the described needs?

  A. DB2 Express-C

  B. DB2 Enterprise Server Edition

  C. DB2 Workgroup Server Edition

  D. DB2 Advanced Enterprise Server Edition

  Correct Answer: D

• Question 52:

  Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

  A. Implicit casting

  B. Double-dot notation

  C. Use of bitmap indexes

  D. Selecting from the DUAL table

  Correct Answer: D

• Question 53:

  What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)

  A. Row

  B. Table

  C. Scalar

  D. External

  Correct Answer: C

• Question 54:

  Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

  A. COMMIT

  B. SAVEPOINT

  C. ROLLBACK WORK

  D. UPDATE TERMINATE

  Correct Answer: C

• Question 55:

  Which of the following is TRUE about indexes on column organized tables?

  A. No indexes are allowed

  B. Indexes are only allowed on numeric columns

  C. Indexes are automatically created to enforce unique constraints

  D. An index is only allowed on the synopsis table supporting a column organized table

  Correct Answer: A

• Question 56:

  Which of the following set operators can be used to find all rows that are common in 2 queries?

  A. UNION

  B. UNION ALL

  C. EXCEPT ALL

  D. INTERSECT ALL

  Correct Answer: B

• Question 57:

  Which of the following statements about triggers are TRUE? (Choose two.)

  A. There is a limit of 8 for the maximum number of cascading trigger activations

  B. Triggers can be activated as a result of changes due to referential constraint enforcement

  C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view

  D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers

  E. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

  Correct Answer: BD

• Question 58:

  Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

  A. DB2 Connect

  B. DB2 Runtime Client

  C. DB2 Data Server Client

  D. DB2 Enterprise Server Edition

  Correct Answer: A

• Question 59:

  What of the following is TRUE about triggers?

  A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements

  B. Triggers can be used to perform data manipulation operations against complex views

  C. Triggers can only be used to execute logic before or after appropriate SQL statements

  D. Only one trigger for a particular event and activation time can be created for a particular table

  Correct Answer: A

• Question 60:

  Below are the SQL statements a DBA is planning to execute on a database:

  CREATE TABLE t1 (name VARCHAR (1));

  INSERT INTO t1 VALUES (`A'), (`B'), (`C'), (`D');

  ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;

  What will be the outcome of the last statement?

  A. The statement will fail due to variable length character error

  B. The statement will fail due to an incompatible data type error

  C. The statement will execute successfully and it deletes the character data

  D. The statement will execute successfully and it internally converts the character data into ASCII numbers

  Correct Answer: C