| IBM 000-543 test certifies that the successful | | | | Click the Exhibit button. |
| candidate has important knowledge, skills, and abilities | | | | CREATE TABLE store(sid INTEGER, info XML); |
| necessary to design, build, execute, and deploy DB2 | | | | INSERT INTO store VALUES (1, |
| 9.7 database applications. | | | | ' |
| This IBM 000-543 test material has been published on | | | | Grocery A |
| now.A part content of this 000-543 test material is | | | | Mango1.20 |
| Database Objects (11%) | | | | Apple0.50 |
| Demonstrate knowledge of naming conventions of | | | | Ice Cream6.00 |
| DB2 objects | | | | '); |
| Describe when to use SQL routines, functions and | | | | Given the statements shown in the exhibit, a user |
| modules | | | | executes the query shown below: |
| Demonstrate knowledge of data types | | | | XQUERY for $store in |
| Which condition will prevent a developer from using the | | | | db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := |
| DB2 Call Level Interface in an application? | | | | $store/items/fruit, $count := fn:count($items)return |
| A. The developer must control the cursor names to | | | | $count |
| comply with company naming standards. | | | | What is the output? |
| B. An SQL precompiler is not available to the | | | | A. 2 |
| developer. | | | | B. 2 |
| C. The application must create an external scalar | | | | C. 1 |
| function with the CREATE FUNCTION statement. | | | | D. $count |
| D. The DECLARE CURSOR statement needs to be | | | | Answer: D |
| used. | | | | You have created a stored procedure |
| Answer: D | | | | (MULTIRESULTS()) on the server which will return |
| The statement below was used to create a cursor | | | | multiple resultsets. While developing a PHP application |
| named CSR1: | | | | using the IBM_DB2 extension, you want to call the |
| DECLARE csr1 DYNAMIC SCROLL CURSOR FOR | | | | storedprocedure. The code shown below will execute |
| SELECT * FROM employee; | | | | the stored procedure: |
| After fetching all of the rows in the result set | | | | $stmt = db2_exec($conn, 'CALL multiResults()'); |
| associated with cursor CSR1, which two statements | | | | How can you fetch all of the result sets from $stmt? |
| can beused to fetch the data starting at the end of | | | | A. Call db2_fetch_object($stmt) for the first result set; |
| the result set? (Choose two.) | | | | call db2_next_result($stmt) for more result sets. |
| A. FETCH LAST | | | | B. Call db2_next_result($stmt) for each result set. |
| B. FETCH PRIOR | | | | C. Call db2_fetch_object($stmt) for each result set. |
| C. FETCH RELATIVE | | | | D. Call db2_next_result($stmt) for each result set; call |
| D. FETCH OFFSET | | | | db2_fetch_object($stmt) for each row in the resultset. |
| Answer: BC | | | | |