New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

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

C2090-616 Exam Dumps - DB2 11.1 Fundamentals for LUW

Go to page:
Question # 4

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

A.

32672 bytes

B.

65344 bytes

C.

98016 bytes

D.

130688 bytes

Full Access
Question # 5

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

A.

db2look with the –x option

B.

db2pd with the –auth option

C.

Query the SYSCAT.DBAUTH view

D.

Query the SYSCAT.TABLES view

E.

Query the SYSCAT.TABAUTH view

Full Access
Question # 6

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

A.

View

B.

Alias

C.

Table

D.

Schema

Full Access
Question # 7

Which of the following is TRUE regarding user switching in a trusted context?

A.

You cannot switch user id in a trusted context

B.

You can issue a switch-user request within a transaction

C.

The new user must have the connect-privilege on the database for it to succeed

D.

No password is ever required for the new user as an authentication is established in the trusted connection

Full Access
Question # 8

DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

A.

Oracle

B.

Sybase

C.

Netezza

D.

MongoDB

E.

Microsoft SQL Server

Full Access
Go to page: