IBM Assessment DB2 10.1 Fundamentals

Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?

By default, where is the data stored for a column defined with an XML data type?

What is used in conjunction with a foreign key to define a relationship between two tables?

Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?

Given the following statement: GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION; Which statement is correct?

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

When is a mask used to limit access to data in a table?

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?