Online Access Free C2090-546 Practice Test

Which DB2 authority is required to manage workload objects for a database?

• A.SECMAINT
• B.DBADM
• C.WLMMAINT
• D.WLMADM

Given the following DDL statements:

What is the end result of the CREATE INDEX statement?

• A.TBSP11 and TBSP12 will each contain one local index since the local indexes will physically reside in the same table space as the related data.
• B.TBSP21 will contain one index because NEW_IDX is not partitioned and will automatically go into the first index partition listed in the create table statement.
• C.TBSP21 and TBSP22 will each contain one local index.
• D.INDEX_TS will contain one non-partitioned index since the create index command is missing the PARTITION keyword.

Which category is used to audit the running of SQL statements?

• A.CONTEXT
• B.EXECUTE
• C.SQLMAINT
• D.OBJMAINT

Which two workload management thresholds support priority aging by providing a remapping action? (Choose two.)

• A.CONCURRENTDBCOORDACTIVITIES
• B.SQLROWSREADINSC
• C.ACTIVITYTOTALTIME
• D.REMAPACTIVITY
• E.CPUTIMEINSC

If the following statements are executed:

Which operation will be captured by the ASP_1 audit policy?

• A.SELECT * FROM staff
• B.DROP TABLE old_tab
• C.CREATE TABLE tab_1 (col1 INT, col2 DATE)
• D.CREATE INDEX idx_1 ON tab_1 (col1)