Download DB2 11.1 Fundamentals for LUW.C2090-616.TestKing.2018-09-01.35q.tqb

Download Exam

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

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)

Correct answer: C

Explanation:

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

What of the following is TRUE about triggers?

Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
Triggers can be used to perform data manipulation operations against complex views
Triggers can only be used to execute logic before or after appropriate SQL statements
Only one trigger for a particular event and activation time can be created for a particular table

Correct answer: A

Explanation:

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

What is the purpose of a role?

To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles
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

Correct answer: A

CONNECT US

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset