C2090-616 Exam Dumps - DB2 11.1 Fundamentals for LUW

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

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

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

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

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.)

Consider the following sequence of events:

Eddie grants SELECT WITH GRANT OPTION privilege to Mike.

Mike grants SELECT privilege to Jeff.

Eddie revokes SELECT privilege from Mike.

What will happen to Jeff’s SELECT privilege?