Which statement will fail?
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?
How many rows will be successfully inserted?
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?
Which statement is correct about informational constraints?
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?
Which two plug-in types does the DB2 database system provide? (Choose two.)
What are three authorization categories in DB2?
What are three authorization categories in DB2? (Choose three.)
What are three system and database level authorizations available with DB2?
What are three system and database level authorizations available with
DB2? (Choose three.)
Which data type must be used to create a column to hold the necessary LBAC security data?
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 AU
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?
How does the DB2 Server identify the list of GSS-API plug-ins it supports?