pass4sure ibm 000-703

By PassGuide-IBM Study Guide | Oct 12, 2008
Visited 141 times, 1 so far today

db2 udb v8.1 familu application development : 000-703 Exam
Test Information:
• Number of questions: 63
• Time allowed in minutes: 75
• Required passing score: 57%

Related certifications:
• IBM Certified Application Developer — DB2 Universal Database V8.1 Family

Exam Topics Include:
• Database objects and Programming Methods
• Data Manipulation
• Embedded SQL Programming
• ODBC/CLI Programming
• Java Programming
• Advanced Programming
• User Defined Routines
Product Description

Exam Number/Code: 000-703

Exam Name:db2 udb v8.1 familu application development

“db2 udb v8.1 familu application development”, also known as 000-703 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 126 questions to your 000-703 Exam preparation. In the 000-703 exam resources, you will cover every field and category in IBM certifications helping to ready you for your successful IBM Certification.

Exam Details

Job Role Description / Target Audience An IBM Certified Application Developer is an intermediate or advanced level application developer specializing in creating applications that run on any of the DB2 platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows, z/OS, s/390, and iseries. This individual has strong skills in all common programming tasks as well as strong skills in one or more of the specialty areas: embedded SQL programming, ODBC/CLI programming, or Java programming. To attain the IBM Certified Application Developer

Question: 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
Answer: B Question: 2
Given the code:

EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1;
Under which of the following situations will the above cursor be implicitly closed? A. When a CLOSE statement is issued
B. When a COMMIT statement is issued
C. When there are no rows in the result set
D. When all rows are FETCHed from the result set
Answer: B Question: 3
To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?

A. Binder
B. Precompiler
C. Stored Procedure Builder
D. Application Development Center
Answer: B Question: 4
An ODBC/CLI application has the following pseudo code:

SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc )
SQLConnect( hDbc, “CERTDB”, SQL_NTS, “user1″, SQL_NTS, “passwd”, SQL_NTS ) SQLAllocHandle( SQL_HANDLE_STMT, hDbc, &hStmt )
SQLExecDirect( hStmt, “SET CURRENT SQLID db2cert”, SQL_NTS )

Assuming all of the above calls execute successfully, which of the following fully qualified SQL
statements is equivalent to:

SQLExecDirect( hStmt, “SELECT * FROM user1.table1 t1, table2 t2 WHERE t1.col1=t2.col2″, SQL_NTS )

A. SQLExecDirect( hStmt, “SELECT * FROM user1.table1 t1, table2 t2 WHERE
t1.col1=t2.col2″, SQL_NTS )
B. SQLExecDirect( hStmt, “SELECT * FROM user1.table1 t1, user1.table2 t2 WHERE
t1.col1=t2.col2″, SQL_NTS )
C. SQLExecDirect( hStmt, “SELECT * FROM user1.table1 t1, db2cert.table2 t2 WHERE
t1.col1=t2.col2″, SQL_NTS )
D. SQLExecDirect( hStmt, “SELECT * FROM db2cert.table1 t1, db2cert.table2 t2 WHERE
t1.col1=t2.col2″, SQL_NTS )
Answer: C Question: 5
Given the EMPLOYEE table definition: CREATE TABLE employee (
workdept CHAR(30), salary INTEGER
)
Which of the following is a correct usage of parameter markers in a JDBC program?

A. String sql = “UPDATE employee SET salary = salary * ? WHERE workdept = ?”; Statement stmt = con.createStatement(sql);
B. String sql = “UPDATE employee SET salary = salary * ? WHERE workdept = ‘?’”; Statement stmt = con.createStatement(sql);
C. String sql = “UPDATE employee SET salary = salary * ? WHERE workdept = ?”;
PreparedStatement ps = con.preparedStatement(sql);
D. String sql = “UPDATE employee SET salary = salary * ? WHERE workdept = ‘?’”; PreparedStatement ps = con.preparedStatement(sql);
Answer: C Question: 6
Given the following code:
BEGIN ATOMIC
UPDATE country SET cities = :count WHERE CURRENT OF C1; INSERT INTO country VALUES (:col1, :col2, :col3);
INSERT INTO country VALUES (:col4, :col5, :col6); INSERT INTO country VALUES (:col7, :col8, :col9); INSERT INTO country VALUES (:col10, :col11, :col12);
COMMIT;
END
Given that all statements succeed except the following: INSERT INTO country VALUES (:col7, :col8, :col9);
How many rows will be affected in table COUNTRY?

A. 0
B. 3
C. 4
D. 5
Answer: A Question: 7
The following commands are issued against a data source containing table user2.org: CREATE ALIAS user1.org FOR sample.org
CREATE TABLE org.sample ( c CHAR(1))

*pass4sure ibm 000-703 Questions and Answers : 126 questions
* Updated: October 4th , 2008
* Price: $159.99 $99.99

Free down:Testking ibm 000-703
Free down:Pass4sure ibm 000-703