Free and Premium IBM C2090-616 Dumps Questions Answers

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

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

They return scalar values and not array values

There are no DB2 monitor elements specific to OLAP functions

OLAP functions are not supported in a common table expression (CTE)

OLAP aggregation functions are not supported with column organized tables

Application 2 will read the amount of 90

Application 2 will read the amount of 100

Application 2 will receive a warning message

Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires

INSERT INTO t1 VALUES (100)

INSERT INTO t1 (c1, c2) VALUES (100)

INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)

INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

privileges, db2ssh, LBAC credentials

privileges, authority levels, certificates

db2ssh, trusted contexts, authority levels

privileges, authority levels, LBAC credentials

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

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

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

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

NOT NULL

Foreign key

Primary key

Informational constraint

Authentication

Authorities and privileges

Label-based access control

Row and column access control