C2090-320試験の本番では、限られた時間内に問題を解き切る時間配分の感覚も問われます。PassTestのDesktop Test EngineならIBM DB2 11 Fundamentals for z/OSの本番環境を再現した模擬試験に取り組めるため、当日の緊張を和らげる練習ができます。

IBM C2090-320 試験概要:

IBM C2090-320 試験シラバストピック:

IBM C2090-320 試験 Q&A まとめ

IBM DB2 11 Fundamentals for z/OS 認定 C2090-320 試験問題：

問題 #1

Your current authorization ID is DBA.
Only one of your secondary authorization IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP INDEX AAA". Which of the following statements must precede th$ DROP statement so that it drops the index?

A. SET CURRENT PATH = 'DB2';
B. SET CURRENT SCHEMA = 'DB2':
C. SET CURRENT RULES = 'DB2';
D. No preceding statement is needed

問題 #2

Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

A. TABLE
B. TABLESPACE
C. PAGE
D. PARTITION

問題 #3

Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?

A. No
B. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1
C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
D. Yes

問題 #4

DB2 native SQL procedures execute in which DB2 address space?

A. IRLM
B. DBM1
C. DIST
D. WLM stored procedure

問題 #5

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned secondary index
B. Data-partitioned secondary index
C. Data-partitioned partitioning index
D. Non-partitioned index

解説：