Practice IBM C2090-616 Exam Questions

You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority? Which of the following editions would be best meet the described needs?

Which of the following editions of DB2 include support for Federation with Oracle database?

Which three facilities are used to control authorization in DB2?

Which database object can be locked explicitly?

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