IBM C2090-541 - Questions & Answers
Free preview · every answer includes a full explanation
Product page: https://prepkeys.com/c2090-541.html
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?
Click the Exhibit button 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?
Click the Exhibit button.
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?