A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed).
Which BIND parameter setting can you use to accomplish this ?
A. DYNAMICRULES(DEFINEBIND)
B. DYNAMICRULES(BIND)
C. DYNAMICRULES(INVOKERUN)
D. DYNAMICRULES(RUN)
正解:B
質問 2:
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
A. Contains information about bound packages
B. Contains scheduled tasks for the administrative scheduler
C. Contains information about UDFs and stored procedures
D. Contains information about UDFs, BIFs and stored procedures
正解:C
質問 3:
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE.
Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
A. SELECT * FROM MYUSER.MYREMOTE.EMP;
B. CONNECT TO MYREMOTE;SELECT * FROM MYUSER.EMP;
C. CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;SELECT * FROM MYUSER.EMP_ALIAS;
D. SELECT * FROM MYUSER.EMP;
正解:B
質問 4:
To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table If D32 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?
A. CHECK PENDING
B. REBUILD PENDING
C. REORG PENDING
D. ADVISORY REORG PENDING
正解:A
質問 5:
What is the proper sequence for running the steps of the program preparation process?
A. Bind, precompile, compile, link edit
B. Precompile. bind, link edit, compile
C. Precompile. compile, link edit, bind
D. Link edit, precompile, compile, bind
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
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. SET CURRENT SQLID = 'DB2';
B. SET CURRENT RULES = 'DB2';
C. SET CURRENT SCHEMA = 'DB2';
D. No preceding statement is needed
正解:A
質問 7:
Given the following sequence of events:
1) COL1 in SCHEMA.TABLE has a value of 10
2) Update COL1 in SCHEMA.TABLE to 20 3)SetSAVEPOINTA
4) Update COL1 in SCHEMA.TABLE to 30 5)SetSAVEPOINTB
After issuing the statement:
ROLLBACK TO SAVEPOINT
What will be the value in COL1 of the SCHEMA.TABLE?
A. 20
B. 10
C. 30
D. An -880 SQLCODE will be issued when the statement is executed
正解:D
質問 8:
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?
A. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)
B. Bind your application with ISOLATION(UR)
C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
D. Bind your application with ISOLATION(CS)
正解:A
質問 9:
A view is considered read only if which of the following is TRUE?
A. The first EROM clause identifies only one table
B. The first SELECT clause specifies the DISTINCT option
C. The fullselect includes a column of a base table that is defined as implicitly hidden
D. The outer fullselect contains an ORDER BY clause
正解:D
Hara -
C2090-320に合格しました。また次回もここにお世話になりたいと思います。サラリーマンのわしにとっては最高や!!Pass4Testさん、誠にありがとうございました!!!