C2090-616 PDF Dumps

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

 solution: C

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/
db2z_sql_createfuncinlinesqlscalar.html


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

 solution: A

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html


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

authenticated
 - B:   To group a collection of users together so that they can be simultaneously granted and revoked specific

authorities and privileges
 - C:   To group a collection of privileges together so that they can be simultaneously granted to and revoked from

multiple users, groups, or other roles
 - D:   To assign one or more users that need to run local DB2 applications and tools on a particular server to the

DB2ADMNS or the DB2USERS group

 solution: A



Q4.Which of the following authorities is sufficient for connecting to a database?
 - A:   SQLADM
 - B:   CONNECT
 - C:   DATAACESS
 - D:   ACCESSCTRL

 solution: D

Explanation:
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21427232


Q5.Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
 - A:   DELETE FROM t1
 - B:   DELETE* FROM t1
 - C:   DELETE* TABLE t1
 - D:   TRUNCATE TABLE t1 IMMEDIATE
 - E:   TRUNCATE TABLE t1

 solution: A, B



Q6.Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
 - A:   Sequence
 - B:   Row Identifier
 - C:   Identity Column
 - D:   Insert time clustering table

 solution: A

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/
db2z_sequencereference.html


Q7.Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)
 - A:   No other applications can access the table
 - B:   Only uncommitted read (UR) applications can access the table
 - C:   The lock owner and other applications can read, but not update, the locked table
 - D:   The lock owner can both read and update data. Other applications can read the table
 - E:   This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on

the table is dropped

 solution: A, E

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html


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

 solution: B

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.perf.doc/doc/c0021283.html


Q9.Which of the following is designed for continuous availability, increased throughput of many concurrent short
queries, and easy scalability?
 - A:   DB2 HADR
 - B:   DB2 pureScale
 - C:   DB2 Express-C
 - D:   DS2 Database Partitioning Feature

 solution: B

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/
com.ibm.db2.luw.licensing.doc/doc/c0054843.html


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

 solution: B