7.19. Review Questions

1:Consider the following instructions/commands/statements: 
								Login to your Linux server as user JDOE
								su db2inst1 (switch user to db2inst1)
								CONNECT TO sample USER foo USING bar
								SELECT * FROM t1

Which table will you select data from?

  1. JDOE.t1

  2. db2inst1.t1

  3. foo.t1

  4. bar.t1

2:Which of the following is not created when you create a database?

  1. IBMDEFAULTBP

  2. IBMDEFAULTSPACE

  3. IBMDEFAULTGROUP

  4. SYSCATSPACE

  5. IBMTEMPGROUP

3:Which of the following objects will ensure rows are assigned a unique value across multiple tables?

  1. Identity column

  2. Unique index

  3. Sequence

  4. Row ID

4:Which of the following commands will delete all rows from the table t1 without logging?

  1. Truncate table

  2. Delete * from t1 no log

  3. Alter table t1 activate not logged initially with truncate

  4. Alter ...

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.

Start your free trial