Online Access Free C2090-541 Practice Test

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?

• A.SYSIBM.DB2SECURITYLABEL
• B.SYSPR0C.DB2LBACU\BEL
• C.SYSPR0C.DB2SECURITYU\BEL
• D.SYSIBM.DB2LBACLABEL

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

• A.by using the SRVSUPP_GSSPLUGIN_LIST registry variable
• B.by using the SRVSUPP_GSSPLUGIN_LIST database manager configuration parameter
• C.by using the SRVCON_GSSPLUGIN_LIST registry variable
• D.by using the SRVCON_GSSPLUGIN_LIST database manager configuration parameter

Which two tasks can DB2 Workload Management do? (Choose two.)

• A.Audit users, who did what and when.
• B.Automatically change DB2dbm and db configuration.
• C.Limit the number of disruptive database activities that can run concurrently
• D.Stop the execution of activities that exceed defined boundaries.

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?

• A.3
• B.1
• C.7
• D.5

Which statement is true about unique constraints?

• A.There can be multiple unique constraints per table.
• B.There can be only one unique constraint key per table
• C.A foreign key can only reference a unique constraint.
• D.A unique constraint is identical to a unique index.