Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
If you are already connected to a database, what does running the following statement do?
The DDL statement is used to create table T1:
CREATE TABLEt1 (
c2 INTEGER NOT NULL,
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
Which of the following INSERT statements will execute successfully?
The creator of an index or an index specification automatically receives which privilege on the index?