Do you know what a certification is? It is a procedure of learning or gaining knowledge on a total distinct training course and passes it in least suitable score. There are many online web sites that play a significant role in providing IBM DB2 9 DBA for Linux UNIX and Windows exam resources, study materials (like exam notes and free questions etc), just to improve your exam preparation. Killtest DB2 9 DBA for Linux UNIX and Windows has gained a lot of status in the certification industry as they have a lot of study material (study notes, practice papers, brain dumps, study guides, exam answers, test dump) there on the web site.
Which of the following statements about SCHEMA objects is true?
A.A schema must always be associated with a user.
B.Triggers and sequences do not have schemas associated with them.
C.After creating a new database, all users who successfully authenticate with the database have the ability
to create a new schema.
D.If a schema is not explicitly specified in a SQL statement, the PUBLIC schema is assumed.
Answer: C
Which of the following REORG table options will compress the data in a table using the existing
compression dictionary?
A.KEEPEXISTING
B.KEEPDICTIONARY
C.RESETDICTIONARY
D.EXISTINGDICTIONARY
Answer: B
