Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ;
CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ;
Which statement will fail?

Refer to the Exhibit.

Given the INSERT statements shown below:
INSERT INTO applicant VALUES (1 ,’M’ 54);
INSERT INTO applicant VALUES (2, ‘F’, 38);
INSERT INTO applicant VALUES (3, ‘M’, 21);
INSERT INTO applicant VALUES (4, ‘F’, 91);
INSERT INTO applicant VALUES (5, ‘C’, 50);
INSERT INTO applicant VALUES (6, ‘C’, 70);
INSERT INTO applicant VALUES (7, ‘C’, 95);
How many rows will be successfully inserted?

Which statement is correct about informational constraints?

Refer to the Exhibit.

In the exhibit, where would the authentication of the supplied userid and password from a remote
client take place?

Which two plug-in types does the DB2 database system provide? (Choose two.)

What are three authorization categories in DB2? (Choose three.)

What are three system and database level authorizations available with
DB2? (Choose three.)

A DBA wants to use Label Based Access Control (LBAC) to protect Individual
rows in a table.
Which data type must be used to create a column to hold the necessary LBAC
security data?

Which administrative authority is needed to run the audit stored procedures and table functions
such as the AUDIT_DELIM_EXTRACT stored procedure?

How does the DB2 Server identify the list of GSS-API plug-ins it supports?