You are asked to create a new database called PRODDB where no privileges will be automatically
granted to PUBLIC
Which CREATE statement will accomplish this?

Which three commands will apply the specified action to all objects in schema PAY1 in database
PRODDB? (Choose three.)

Which SQL statement will execute successfully?

You want to grant user BOB the ability to create tables in table space PLANS and to grant this
privilege to others
Which command would you use?

What is the purpose of a role?

Refer to the Exhibit.

Referring to the exhibit, which security mechanism would be used to
authenticate a remote user running a db2trc command?

Which operating system has client side Kerberos support enabled by default?

Which statement is true about unique constraints?

Refer to the Exhibit.

What is the result after executing the SELECT statement shown below?
SELECT COUNTO FROM applicant WHERE gender=’C’

Given the DDL shown below:
CREATE TABLE tab1 (col1 CHAR(2), COI2 SMALLINT );
CREATE VIEW v1 AS SELECT col2 FROM tab1 WHERE col2 > 50 ;
CREATE VIEW V2 AS SELECT COI2 FROM v1 WITH LOCAL CHECK OPTION
CREATE VIEW V3 AS SELECT COI2 FROM v2 WHERE COI2 < 200 ;
Which statement will fail?