Chapter 7
| A1: | C. Since no schema is explicitly specified, the schema will be the authorization ID for the connection. The authorization ID, also known as the connection ID, is the user ID used to connect to the database. Therefore, the table name will be foo.t1. |
| A2: | B. There is no object named IBMDEFAULTSPACE. When a database is created, DB2 creates the table spaces SYSCATSPACE, USERSPACE1, and TEMPSPACE1; the partition groups IBMCATGROUP, IBMTEMPGROUP, and IBMDEFAULTGROUP; and the buffer pool IBMDEFAULTBP. |
| A3: | C. An identity column ensures uniqueness, but only within a table. A sequence generates a unique value that is across the whole database and can therefore be used with multiple tables. |
| A4: | D. The statement alter table t1 activate not logged ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
