IBM C2090-320 問題集

質問 1：
Your current authorization ID is DBA.
Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table.
The appropriate SQL statement starts with "CREATE INDEX AAA ON...".
Which of the following statements must precede the CREATE statement so that you can create the index?
A. No preceding statement is needed
B. SET CURRENT SCHEMA = 'DB2';
C. SET CURRENT RULES = 'DB2';
D. SET CURRENT SQLID = 'DB2';
正解：D

質問 2：
While DSN is running, which of the following commands CANNOT be successfully executed?
A. -START DB2
B. -STOP DB2
C. -DISPLAY UTILITY
D. -TERM UTILITY
正解：C

質問 3：
DB2 native SQL procedures execute in which DB2 address space?
A. DIST
B. DBM1
C. WLM stored procedure
D. IRLM
正解：C

質問 4：
Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?
A. SYSIBM.SYSCHECKDEP
B. SYSIBM.SYSPENDINGDDL
C. SYSIBM.SYSPENDINGOBJECTS
D. SYSIBM.SYSDEPENDENCIES
正解：B

質問 5：
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?
A. STOSPACE
B. COPY
C. BACKUP SYSTEM
D. REORG
正解：C

質問 6：
Which of the following is a characteristic of a stand-alone utility?
A. It can only be executed using JCL
B. It can only be executed if no other utilities are running
C. It can only be executed in a non-data sharing environment
D. It can only be executed by a user with SYSADM
正解：A

質問 7：
The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two)
A. An application-period temporal table
B. A declared global temporary table
C. A bitemporal table
D. A system-period temporal table
E. A created global temporary table
正解：B,E

質問 8：
What is the proper sequence for running the steps of the program preparation process?
A. Link edit, precompile, compile, bind
B. Bind, precompile, compile, link edit
C. Precompile. bind, link edit, compile
D. Precompile. compile, link edit, bind
正解：C
解説: (Topexam メンバーにのみ表示されます)