Summer 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 constraint can be used to ensure that identical values are never stored in a set of columns in a table?

Options:

A.

NOT NULL

B.

Foreign key

C.

Primary key

D.

Informational constraint

Buy Now
Question 2

Which of the following is TRUE about DB2 OLAP functions?

Options:

A.

They return scalar values and not array values

B.

There are no DB2 monitor elements specific to OLAP functions

C.

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

D.

OLAP aggregation functions are not supported with column organized tables

Question 3

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