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

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

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

Which database object can be locked explicitly?

A. Row

B. View

C. Index

D. Table

Which of the following statements about stored procedures is TRUE?

A. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

C. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

D. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Which of the following statements regarding locking is TRUE?

A. The same lock modes apply to tables, rows, or blocks

B. Lock conversion can take place implicitly as a query executes

C. Changing the mode of a lock that is already held is called lock escalation

D. Lock conversion is not necessary if an X lock is required and an S or U lock is currently held

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

A. Oracle

B. Sybase

C. Netezza

D. MongoDB

E. Microsoft SQL Server

If you are already connected to a database, what does running the following statement do? Db2 CONNECT

A. Prompts you for the database name or alias

B. Returns information about the current server

C. Prompts you for the authentication information

D. Returns an error, because you provided no database or alias

Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

A. CREATE TABLE t1 (c1 INT, c2 INT);

B. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;

C. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;

D. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;

With HADR, which of the following configuration and topology choices provides the highest level of protection from potential loss of data in a pureScale environment?

A. Principal standby with SYNC synchronization mode

B. Auxiliary standby with SYNC synchronization mode

C. Principal standby with NEARSYNC synchronization mode

D. Auxiliary standby with SUPERSYNC synchronization mode