Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following C2090-616 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

DB2 11.1 Fundamentals for LUW Questions and Answers

Question 1

Which of the following statements about stored procedures is TRUE?

Options:

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

Buy Now
Question 2

Which three facilities are used to control authorization in DB2?

Options:

A.

privileges, db2ssh, LBAC credentials

B.

privileges, authority levels, certificates

C.

db2ssh, trusted contexts, authority levels

D.

privileges, authority levels, LBAC credentials

Question 3

Application 1 executes the following statements:

INSERT INTO TAB1 (NAME,AMOUNT) VALUES (‘John,100);

COMMIT;

UPDATE TAB1 SET AMOUNT=90 WHERE NAME=‘John’;

After a few seconds, application 2 executes the following query:

SELECT AMOUNT FROM TAB1 WHERE NAME=‘John’

Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?

Options:

A.

Application 2 will read the amount of 90

B.

Application 2 will read the amount of 100

C.

Application 2 will receive a warning message

D.

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