Questions And Answers for PowerBuilder CPD Exam

Question

product_master table has 10 rows. The host variable 'p_desc' in the
Select product_description into :p_desc from product_master;
embedded SQL contains:

 [A] The product_description of the first row from the product_master table.
 [B] The product_description of the last row from the product_master table.
 [C] The product_description of all the rows from the product_master table.
 [D] PowerBuilder doesn't compile a embedded SQL statement unless the SQL statement has a WHERE clause.
 [E] Results are unpredictable

Click here to see the answer

Answer

The correct answer is: A

Click here to go to top of the page.