C2090-616: DB2 11.1 Fundamentals for LUW - Free download from Exam Files

Which of the following editions of DB2 include support for Federation with Oracle database?

DB2 Express-C
DB2 Developer Edition
DB2 Enterprise Server Edition
DB2 Workgroup Server Edition

Correct answer: C

Explanation:

Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html

Which three facilities are used to control authorization in DB2?

privileges, db2ssh, LBAC credentials
privileges, authority levels, certificates
db2ssh, trusted contexts, authority levels
privileges, authority levels, LBAC credentials

Correct answer: D

Explanation:

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

A user executes the following statements:

СREATE TABLE t1 (c1 INT, c2 INT);

CREATE ALIAS a1 FOR t1;

What will be the result if the user executes the following statement?

DROP ALIAS a1;

The alias A1 will be dropped
The table T1 will be dropped
Both T1 and A1 will be dropped
Nothing, the statement will result in an error

Correct answer: A

Explanation:

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

NOT NULL
Foreign key
Primary key
Informational constraint

Correct answer: C

Explanation:

Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command
It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Correct answer: D

Explanation:

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

Which of the following statements about stored procedures is TRUE?

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

Correct answer: B

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0023603.html

Which of the following statements about triggers are TRUE? (Choose two.)

There is a limit of 8 for the maximum number of cascading trigger activations
Triggers can be activated as a result of changes due to referential constraint enforcement
Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Correct answer: BD

Explanation:

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

Which of the following is TRUE about indexes on column organized tables?

No indexes are allowed
Indexes are only allowed on numeric columns
Indexes are automatically created to enforce unique constraints
An index is only allowed on the synopsis table supporting a column organized table

Correct answer: A

Explanation:

How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

db2look with the –x option
db2pd with the –auth option
Query the SYSCAT.DBAUTH view
Query the SYSCAT.TABLES view
Query the SYSCAT.TABAUTH view

Correct answer: CE

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/t0005823.html

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

Deadlock
Lock timeout
Lock escalation
Lock conversion

Correct answer: A

Explanation:

Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html

Vendor:	IBM
Exam Code:	C2090-616
Exam Name:	DB2 11.1 Fundamentals for LUW
Date:	Mar 04, 2019
File Size:	18 KB

Download DB2 11.1 Fundamentals for LUW.C2090-616.Test4Prep.2019-03-04.25q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown