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?

Which statement is correct about using the TAKEOVER HADR command?

Refer to the Exhibit

Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving
log file 1. what will happen when DB2 attempts to create log file 101?

A database named FINANCE must be available to users 24x7x365.
Which command should be used to create a backup image of the FINANCE database
without having a significant impact on running applications?