000-703全称はDB2 udb v8.1 familu application Developmentで、 IBM certifications I 000-703(DB2 udb v8.1 familu application Development)問題testpassportのITエンジニアと IBM製品の専門家によって作り上げて、最も新しい本試験題を含めています。この科目は126 の本試験の問題です。無料デモダウンロードすることができます。

V9.5概要、導入と移行
DB2 9.5概要、パッケージングとライセンス サポートされるプラットフォーム サポートされるクライアント/サーバーの組み合わせ IBM Data Server Driver for ODBC, CLI and .Net
インスタンス作成における変更点 フィックスパック適用における変更点 V9.5への移行 廃止された機能、変更された機能 Non-rootユーザーによる導入 .

以下はTestPassPortの000-703試験無料デモです。

http://pdf.testpassport.jp/000-703.pdf

1.Given the following code: EXEC SQL EXECUTE IMMEDIATE :sqlstmt Which of the following
values must sqlstmt contain so that all rows are deleted from the STAFF table?
A.DROP TABLE staff
B.DELETE FROM staff
C.DROP * FROM staff
D.DELETE * FROM staff
Correct:B
2.Which of the following CLI/ODBC functions should be used to delete rows from a DB2 table?
A.SQLDelete()
B.SQLExecDirect()
C.SQLBulkDelete()
D.SQLExecuteUpdate()
Correct:B
3.An ODBC/CLI application executes the following batch SQL: SQLExecDirect( hStmt, “SELECT
c1 FROM t1; SELECT c2 FROM t2;” SQL_NTS ); Which API is used to discard the first result set
and make the second available for processing?
A.SQLFetch()
B.SQLRowCount()
C.SQLMoreResults()
D.SQLCloseCursor()
Correct:C
6.Given an ODBC/CLI program with a single connection, two threads and the following actions
which complete successfully: Thread 1: INSERT INTO mytab VALUES (1) Thread 2: INSERT INTO
mytab VALUES (2) Thread 1: COMMIT Thread 2: INSERT INTO mytab VALUES (3) Thread 1:
ROLLBACK Thread 2: COMMIT How many records will be inserted and retained in the table
MYTAB?
A.0
B.1
C.2
D.3
Correct:C
8.Using Read Stability isolation level, Application A updates row X and does NOT issue a COMMIT.
Using Uncommitted Read isolation level, Application B attempts to read row X. What is the result
of Application B’s attempt to read row X?
A.Application B will receive a lock timeout error.
B.Application B will wait until Application A completes its unit of work.
C.Application B will receive the version of row X that exists after Application A’s update.
D.Application B will receive the version of row X that existed prior to Application A’s update.
Correct:C
9.Which of the following JDBC interfaces has methods that permit the use of parameter markers?
A.ResultSet
B.Statement
C.Connection
D.CallableStatement
Correct:D
10.Which of the following will retrieve results that will only be in lower case?
A.SELECT NAME FROM EMPLOYEE WHERE NAME=’ali’
B.SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)=’ali’
C.SELECT UCASE(NAME) FROM EMPLOYEE WHERE LCASE(NAME)=’ali’
D.SELECT NAME FROM EMPLOYEE WHERE NAME IN (SELECT NAME FROM EMPLOYEE WHERE
LCASE(NAME)=LCASE(’ALI’))
Correct:A