C2090-616 exam

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 . RowB . TableC . ScalarD . ExternalView AnswerAnswer: C Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createfuncinlinesqlscalar.html

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?A . A ROLLBACK command executed just after the COMMIT command cancels that COMMITB . Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command...

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?A . DeadlockB . Lock timeoutC . Lock escalationD . Lock conversionView AnswerAnswer: A Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?A . NOT NULLB . Foreign keyC . Primary keyD . Informational constraintView AnswerAnswer: C Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html

What is the purpose of a role?A . To define exactly what a specific user can and cannot do within a particular database once they have been authenticatedB . To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privilegesC ....

Which of the following is TRUE about indexes on column organized tables?A . No indexes are allowedB . Indexes are only allowed on numeric columnsC . Indexes are automatically created to enforce unique constraintsD . An index is only allowed on the synopsis table supporting a column organized tableView AnswerAnswer:...

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)A . DELETE FROM t1B . DELETE* FROM t1C . DELETE* TABLE t1D . TRUNCATE TABLE t1 IMMEDIATEE . TRUNCATE TABLE t1View AnswerAnswer: AD

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...

What of the following is TRUE about triggers?A . Triggers are activated by INSERT, UPDATE, DELETE and SELECT statementsB . Triggers can be used to perform data manipulation operations against complex viewsC . Triggers can only be used to execute logic before or after appropriate SQL statementsD . Only one...

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)A . Direct Standard EditionB . Enterprise Server EditionC . Workgroup Server EditionD . DB2 Direct Advanced EditionE . Advanced Enterprise Server EditionView AnswerAnswer: BC Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/ com.ibm.db2.luw.licensing.doc/doc/r0053238.html