{"id":1584,"date":"2007-07-20T06:12:06","date_gmt":"2007-07-20T09:12:06","guid":{"rendered":"http:\/\/blog.decade.com.br\/?p=1584"},"modified":"2011-10-03T14:09:27","modified_gmt":"2011-10-03T17:09:27","slug":"question-12","status":"publish","type":"post","link":"https:\/\/blog.decade.com.br\/?p=1584","title":{"rendered":"QUESTION: 12"},"content":{"rendered":"<p align=justify>\nWhich statement is true when writing a cursor FOR-LOOP?<\/p>\n<p align=justify>\n<strong>A:<\/strong> You must explicitly FETCH the rows within a cursor FOR-LOOP.<br \/>\n<strong>B:<\/strong> You must explicitly OPEN the cursor prior to the cursor FOR-LOOP.<br \/>\n<strong>C:<\/strong> You must explicitly CLOSE the cursor prior to the end of program.<br \/>\n<strong>D:<\/strong> You do not explicitly OPEN, FETCH or CLOSE a cursor within a cursor FOR-LOOP.<br \/>\n<strong>E:<\/strong> You must explicitly declare the record variable that holds the row returned from the cursor.<\/p>\n<p align=justify>\nANSWER: <strong>A<\/strong><\/p>\n<p align=justify>\nEXPLANATION: <strong>Answer D is correct because when using a cursor FOR-LOOP you don&#8217;t need explicitly OPEN, FETCH or CLOSE a cursor (by definition of a cursor FOR-LOOP).<\/strong><\/p>\n<p align=justify>\nINCORRECT ANSWERS:<\/p>\n<p align=justify>\n<strong>A:<\/strong> You don&#8217;t need explicitly FETCH the cursor within a cursor FOR-LOOP.<br \/>\n<strong>B:<\/strong> You don&#8217;t need explicitly OPEN the cursor within a cursor FOR-LOOP.<br \/>\n<strong>C:<\/strong> You don&#8217;t need explicitly CLOSE the cursor within a cursor FOR-LOOP.<br \/>\n<strong>E:<\/strong> You don&#8217;t need to declare the record variable to hold the row from the cursor if you use a cursor FOR-LOOP.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Which statement is true when writing a cursor FOR-LOOP? A: You must explicitly FETCH the rows within a cursor FOR-LOOP. B: You must explicitly OPEN the cursor prior to the cursor FOR-LOOP. C: You must explicitly CLOSE the cursor prior to the end of program. D: You do not explicitly OPEN, FETCH or CLOSE a [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,13,8],"tags":[],"class_list":["post-1584","post","type-post","status-publish","format-standard","hentry","category-1z0-001","category-oca-plsql-developer","category-oracle"],"_links":{"self":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1584"}],"version-history":[{"count":0,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1584\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.decade.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}