Free IBM C2090-616 Exam Dumps Questions & Answers

What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser

• A.All privileges are granted to user MYUSER on MYTABLE
• B.An error is returned
• C.An entry is mane in SYSCAT.TABAUTH
• D.The REVOKE statement succeeds with no effect

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?

• A.Jeff's SELECT privilege will be revoked
• B.Jeff's SELECT privilege will be retained only if Eddie has ACCESSCTRL authority
• C.Jeff's SELECT privilege will be retained only if he has ACCESSCTRL authority
• D.Jeff's SELECT privilege will be retained

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.Table
• B.Schema
• C.Alias
• D.View

The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?

• A.Temporal Table
• B.Range-Partitioned Table
• C.Multidimensional Clustered Table
• D.Shadow Table

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

• A.Concurrency may be improved
• B.Lock escalation will be prevented
• C.The number of locks for the same workload will be reduced
• D.Query performance will be reduced