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
A user executes the following statements:СREATE TABLE t1 (c1 INT, c2 INT);CREATE ALIAS a1 FOR t1;What will be the result if the user executes the following statement?DROP ALIAS a1;
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?
