{"id":209793,"date":"2018-09-14T11:26:51","date_gmt":"2018-09-14T11:26:51","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/14\/dbm-405-week-6-quiz\/"},"modified":"2018-10-24T08:59:47","modified_gmt":"2018-10-24T08:59:47","slug":"dbm-405-week-6-quiz","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/dbm-405-week-6-quiz\/","title":{"rendered":"DBM 405 Week 6 quiz"},"content":{"rendered":"<p>1.\u00a0TCO 3 &#8211; Which of the following is not a new procedure in ULT_FILE.\t2.\u00a0TCO 3 &#8211; Prior to which version of Oracle did the UTL_FILE package have to be explicitly compiled into the database as it was not part of the installation?\t3.\u00a0TCO 3 &#8211; Oracle built-in or supplied packages refer to __________.\t4.\u00a0TCO 3 &#8211; If an application needs to write data to an external file, which package would be the most helpful?\t5.\u00a0TCO 3 &#8211; Which of the following processes only needs one parameter passed to it?\t6.\u00a0TCO 3 &#8211; The name of the Oracle script that invokes each of the scripts that create the individual Oracle-Supplied packages is _________.\t7.\u00a0TCO 3 &#8211; An exception of INVALID_PATH returned when trying to read a file that is external to the database would indicate which one of the following?\t8.\u00a0TCO 3 &#8211; Briefly discuss how you could use the DBMS_OUTPUT package to debug processing that was taking place inside a loop.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u00a0TCO 3 &#8211; Which of the following is not a new procedure in ULT_FILE. 2.\u00a0TCO 3 &#8211; Prior to which version of Oracle did the UTL_FILE package have to be explicitly compiled into the database as it was not part <a href=\"https:\/\/www.benedictsol.com\/blogs\/dbm-405-week-6-quiz\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-209793","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=209793"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209793\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=209793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=209793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=209793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}