MCQ Bank
A ______ LOOP statement in PL/SQL programming language repeatedly executes a target statement as long as a given condition is true.
- A) BASIC
- B) Case Statement
- C) FOR
- D) WHILE
________ loop is use to repeat the set of operations. Control variable is initialized with end value. Value is decreased every time by one.
- A) Do while
- B) While
- C) Numeric for
- D) Reverse for
How many types of PL/SQL Loops are there?
- A) 1
- B) 4
- C) 2
- D) 3
____________ loop should be executed at least once. No direct implementation is provided in PL/SQL. It can be implemented using simple loop.
- A) While
- B) For
- C) Nested
- D) Do while
What is the datatype of the counter used in FOR Loop?
- A) Any data type other than DATE
- B) INTEGER
- C) Any Data type
- D) INTEGER OR Character datatype
Where is the control transferred while using a CONTINUE statement?
- A) First statement after the end of the loop
- B) Last iteration of the current loop
- C) Next iteration of the current loop
- D) First iteration of the current loop
Label appear at the ________ of the LOOP statement.
- A) beginning
- B) end
- C) anywhere
- D) Cannot say
What is the initial value of index for a reverse for loop?
- A) Upper bound-Lower bound/2
- B) Lower bound
- C) 1
- D) UPPER bound
When does a FOR Loop end?
- A) When the index reaches the UPPER bound or is terminated early using EXIT statement
- B) When lower bound is greater than UPPER bound or is terminated early using EXIT statement
- C) Only when the index reaches the UPPER bound
- D) When lower bound and upper bound are equal
Loop within a loop is called _____________ loop.
- A) While
- B) Do while
- C) Nested
- D) For
Sequence of statements is enclosed between the LOOP and the END LOOP statements.
- A) FALSE
- B) Can be true or false
- C) Cannot say
- D) TRUE
BEGIN FOR i IN 1 .. 5 LOOP IF i = 3 THEN CONTINUE; END IF; DBMS_OUTPUT.PUT_LINE('Iteration # ' || i); END LOOP; END; Output for this piece of code :
- A) Iteration # 1 Iteration # 2 Iteration # 5
- B) Iteration # 1 Iteration # 4 Iteration # 5
- C) Iteration # 1 Iteration # 2 Iteration # 4 Iteration # 5
- D) Iteration # 2 Iteration # 4 Iteration # 5
The counter in PL/SQL FOR Loop is by default incremented by _____________.
- A) 2
- B) 1
- C) NULL
- D) 0
FOR i IN 1..tbl_roast.COUNT LOOP lv_tot_num := lv_tot_num + tbl_roast(i); END LOOP; In the above code fragment, which of the following holds the value of the current iteration number?
- A) COUNT
- B) i
- C) tbl_roast
- D) lv_tot_num
The label in the LOOP statement should be enclosed by?
- A) double dollar sign
- B) double angle brackets
- C) single dollar sign
- D) single angle brackets
Program will run indefinitely and will result in abnormal termination.
- A) If there is no exit condition written
- B) If variable is defined more than one time
- C) Condition is wrong
- D) Loop is not written
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABIAAAAKICAIAAACHSRZaAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAADLbSURBVHhe7d3ddew6kibQsqedkDFtiN7Li3kYA9oCWTDvPW60A3dCGRAGAn/E/EOSzL2XlgoMgABTOueu+FbqqP71DwAAAEMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYAAAAIMIYNznf/kjBAAAW+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuY8ABgAAm+meuUnkrtkPAABgmY6Zm3S5q34AAADLdMzcpMtd9QMAAFimY+YmXe6qHwAAwDIdMzfpcld+AAAAqzTN3KpLX/EBAACs0jRzqy59xQcAALBK08ytpC8AALiSvplbCWAAAHAlfTO3EsAAAOBK+mbuIIABAMA19M3cQfoCAIBraJ25gwAGAADX0DpzBwEMAACuoXXmPtIXAABspnvm279eoZwNAABvQxP8Xkr0mSjTY5WzJ8o0AACcjmb35Eqm+VGq+1ae9UepAgDA8eluz6aklh+lemTllfwoVQAAOCDt7EmUdHJRSmdUXuFFKQEAwHHoYo+tZJGLUnoP5TVflBIAAOye5vWoZI/KlwIAgKPQth6PvDHLlwUAgP3TsB7JDRkj1n99fZWLi7rDdKta+fj4+Pz8zHGIcVRyHGuqKNbNS6kxW29vuVbc+OcmuaBcAADAzmhVD+O2aBG31OyU6ibT3dqpdra9bOuZiHLc1ltdvc1y14p7M3fFIGRxKk5cehgAAHgtfeoxrISKqEcayQXT94Wy2GaeqHSDqp2KPXO3+Jz716kcpKV6Na1vqcxql9Xx7L1RnK0DAMBraVKPYSVOxFTmq0hK02VZaX9mr65ZWpyD7/eYLu8y5WD2rsxmOZ7ulrp63LL0Dlis7JSJH21lOtv5cwEAAIynST2A7yyyHCfaqemyWlkZVN1UJqUYt9EuBq02gHVm620UvFbcXka/x7Mup/2xBgAABtOhHsNKlminpstqpb71VCsri3Mw/dwOQhfMctCp9ZX3vjZqj1g6rvpzAQAAjKdJPYaIE0uJoq1P17SVfPepVqZxqFZyTVzGIIv1rnbDsFSv2vp6BouVnTLxo61MZ1uXu9cWAADAS2hSD2MpVLTF6YKukpkqx10cinFUcpxr8p9+5Q8Z1rvaDdsd2nqrq7enXCueJB+mDmbFiUsPAwAAr6VPPZLZaNFW1mdDhJ+2kpepzUVxGZ9zNutZyUHVZbZOreeg2lKZNfu0Mc5BytlyAQAAO6NVPR4Zo1XfCvNlAQBg/zSsRyVvpI/LD1X6UgAAcAja1mPL7JFK6T2U13xRSgAAsHua15MoWeSilM6ovMKLUgIAgOPQxZ5NSSc/SvXIyiv5UaoAAHBA2tmTK6nlR6nuW3nWH6UKAADHp7t9LyXTTJTpscrZE2UaAABOR7PLtxJ9xipnAwDA29AEcxc5CgAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9cxcBDAAAttM9c4vIXbPKNAAAMEfHzC1K3poo0wAAwBwdM7coeWuiTAMAAHN0zNyi5K2JMg0AAMzRMXOLkrd+K3MAAMACTTM3KqmrUSYAAIAFmmZuVFJXo0wAAAALNM3cqKSuH6UKAAAs0zdzoxK8fpQqAACwTN/M7Ur2uiglAABgmb6Z25XsJX0BAMA2WmduV+KXAAYAANtonbldiV8CGAAAbPOrdS7dNMAzlf/iAAC8nz6AlRHAc/jvDADwzgQwYCj/nQEA3pkABgzlvzMAwDsTwICh/HcGAHhnAhgwlP/OAADvbDGAxbj19fVVJn5PfXx81KkYf35+5jjEOCo5jjUxrrdkcUWsz8WhO7qMfmTlsrDX1dtHjcscVFm5LOzlglRKFw/ZsDU7VYsxaL8UoZ3qZL0V9+ZXPmdn16ybvWXjPvWb/qhz96N7vHo5rU/lVHxryvXkWzwrv5WxuP3rFqJSRj/aSizubonLVvvnOdQ/MFPtyu6uLeKsMgIAeD99j1hGv8fRYMVlbbOmUzmOQTvVXrZdWrSAbRc41R7XjkPdsOoqK5exSW0or92neviGrdk1tRiDelxqp3Kwolu85ZYtNu7TnX6VRz3qk3SP9+cr7ertn/B2vKRb0/7Nmp7YVmJlXLZ/hLr18bdyZbbTzq6vnLp2PQDAmfzqhFaaqmz7ctxNtfXo4bIdjM8x/vOWWW1PGdq+cHrj+s5Ll9fuUz18w9bsmvaI+LLMtsh/bh5fw5DjXNzeG1PxOdQvewyyEmoxxjkI8Rg5NS22T5iimHJcN687h6V7Q9TLaGHZtJibT4tlNBFT0y/CRnFLGV3Uy65edfV4wvbEeIzu1XVitn4rU/edbbWVHE8rrVqJPdttYxyfQ33UdkE7jjU5WLFlDQDAWf3qhNrGaNok1Uo7FQ1Z23vVViwHdWV2jSEv1208OnWVlct41NraXrtP9fANW7NrajEHcWJtgrupFe1dqb03X0UsaIu5vivmIL6PORs3tsUcxNT0G91uMj1u4731VcTn3GSp2J4y3XBq9qlSXHbKxIK6YGllV58uWz9iZXZlq/rFqV+u0K1vv4DdsukXp13cjreYPicAwPv41Qm1jdG0SaqVGLRqgxvj+JytWIzbdi3Espj6vuGvNxnau1KtrEyl6WUVp9dz4zIHVVeZLkjfG/14yIat2TW1uD7oZL1aqbRTdRwvrX11af2W2WI1+N7Z4opr16+YfYZWV58uW3+AldmYmsqp+NuXf0/rIJQVP5b+PF87/tNViwEATuZXJ7TeUdVKOxUdW1effu5E/zdbr6aztbIyldYvq2v3qR6+YWt2TS3WQXzNo1duK39uPl0we287jiPiMkyb8joIbbGVxapW2qm22MpiVSvt1A3FFdeuXzH7DK2uPl22/gArsytbxaBVizmof6KqOhWuHf/pqsUAACfzqxNa6aimQavq6tm4ryeE7rIT99amP0Rgq91h1yaGrrLxoGv3qR6+YWt2TS22s7H5yndkarpg9t7pstlTZm+Z3tsac+96ccXK+rjslIkFdcHSyq6e38py8ftP+6yYrW9hhfU/BlmJNe2e9cR2fbemnbp2/KerFgMAnMyvTmipo8omL5u20E3Vvi3r+QZX9oh1Zds1dq3eVHtcO87L9t4Y16lUT0zdZXXtPtXDN2zNrqnFbjaOWJqaWnme9t62mOvj83RlfCtztn2G9e/vdJNw7b31VbTLZotxS46jWDdfMftUt6m3L+3T1eMJo1JfQh0v6dbHy6wvcHpiVur3K8U4b+nW169kN26X1XEePR1vMX1OAID38asT6jqtVu3GQildTBu1uIxBFrOSYuX3DT+d8bps6XJxe3TI/VM3FaJYRhfdZeu2fbp666oNZ+W9rSzW2RykPC7H30t/y3oVDXf23FVd0y6u49nXEuMchPzutM8Qlr5lIadi0K7feO/ssnJ9MS3GZT5bVyyjiXZqZdkW9falfab1eNT6EqYvfypfWmq/rXFZRj+ycm09tH9g2mWzC9rxdM+pLWsAAM7qVyekMTqxt/rmvvDF1qOP/gVff/52th3XJLbi6F8ZAIB7/OqEBjdGcdxUmTu18lJ/K3NPk2+zlIuzG/D1XFKPvvMZvv9MTJS5IVb+wLTv1HXv2m35Mzb4hQAA7MqvTkhjBDyb/84AAO9MAAOG8t8ZAOCd7T2A6dXgZPylBgDe2a4D2MfPr84DTsNfagDgnS0GsBh/Xv4fvUL7j+xTFMtoVSxb2STFVBn9lrd0s0uLgaPwtxgAeGeL8SbG+QvNpimoinqnTPyIypZNymjO+ixwOP5SAwDv7Fcn1DZGS+OrrG8SlVap/rZUBw7KX2oA4J396oTaxmhpfJUtm6xvfvPRwD75Sw0AvLNfndBSXlpqmKLeKRM/2sp0Ni3V0/oscDj+UgMA7+xXJ7SUl25umO7f5OajgX3ylxoAeGe/OqGlvDRtmDa2UOubbNHdddsmwH74WwwAvLODxZvPz88yAo5JAAMA3tnBAlj+UnvguAQwAOCdHSyAAUfnvzMAwDsTwICh/HcGAHhnfQCDK/xn+d/b/J/yv7yd8l8cAID3oxPiarWBjgCWg9tEAMuPcg0AAGen9+U6bfp6VACTwQAAeBMaX67zwAAWZDAAAN6KrpfrZADL9PXYAJYfZQIAAM5Iv8sVure/7g9goQtg8VEmAADgdDS7XKF7++tJASw+yhwAAJyLTpcrTAPY/Rmsi17tR1kBAABnocflCs8IYKHLXe1HWQEAAKegweUKEcC69BUfZe4OXeiqH2UaAADOQo/LFZ4UwILoBQDAO9DpstVs+oqPMn0fAQwAgHeg02WrpwawUHOXDAYAwFlpc9mqy131o0w/lAAGAMApaXPZZOntr/goKx5NBgMA4Hz0uGwS+auMLp6XuyoBDACA89HjsslKAPv498fXf3+Vi3/+iXFUysUdBDAAAM5Hj8smKwGsS1xdHruZAAYAwPnocfnbnz9/+Plfn/HRDlKEsVjcxrPIZlHJj/WcJoABAHA+elz+tuUfgGWxnapJLIJWHdfclUksi0tkMAAATkaDy9+2BLCIWFFv3/5ql9Xxx78/tv+MogAGAMDJaHD525YAFrp6XLYfpfrzc4nx8WcME8AAADgZDS5/6NJXaNNUq6svLUtbfgQxyGAAAJyJ7pY/3BzA2n8DVn8PR6zJN74EMAAA3pDulj/cHMBC/rRh+4++MnflRy2uEMAAADgT3S1/2B7AnkQGAwDgNLS2rHl5+goCGAAAp6G1ZY0ABgAAD6S1ZV5Er06pC2AAAHArrS3zSupqlPrwABZkMAAAzkFfy7ySuhrfxVekryCAAQBwDvpa5pXU1fguCmAAAHAHfS3zSur6UYoCGAAA3EFfy7wSvH6U4osCWJDBAAA4AU0t80rw+lGKAhgAANxBU8u8ErwuSkkAAwCA+2hqmVey10UpCWAAAHAfTS3zSva6KCUBDAAA7qOpZV7JXhel9NIAFmQwAACOTkfLvJK9fmceAQwAAO6ho+WXkroaZeLV6SsIYAAAHJ2OlqKPWz/KtQAGAAB309HSR68q66FcCmAAAHAfHe1ba/PVilz28gAWZDAAAA5NO/umMlKVi20igF17y8MJYAAAHJp29u1cktft3/c7b7+TAAYAwKFpZ9/IA7PTA7e6igAGAMChaWffwpPy0pO2XSGAAQBwaNrZkxuQkQYcUQlgAAAcmnb2tEbmojDsOBkMAIDj0sue0LAsNDXgaAEMAIDj0sueyoD8s8VTH0MAAwDguPSyJ/HUzHObJz2SAAYAwHHpZQ/vSTnnUR7+eAIYAADHpZc9sIdnm+d54KMKYAAAHJde9pAemGf+lGelUmp8fHxEPT5/fX2V0rKlTa4lgwEAcFAa2YN5VIbZ6PPzM8JVuZiIqVgQg/VlnftfggAGAMBBaWQP4+bcEndFQMrbV96nmg1RUQzlYiI2LKPf4y0uj3PjHz8BDACAg9LIHsA9WSXEvZmsIn1N94liRKyox+dpPIsbQ+6wEt5md94i7rrhRgEMAICD0sju3W3BptXuMN0tKuvvcdXcFRksB51MXyvx7E9xeygXGwhgAAAclEb2AK7NJ5323uk+EZxW3gFrLT3D+ptj62LPpW1XCGAAAByURvYwbssqob1rZYcIYEvvcaWle29+qttuTDIYAABHpIs9mBtyS7v+5nu/vr7W49l23y/g7vgkgAEAcES62EO6KsO0K7fflSJ3XY4qv8Zj1vY9c6tycR8BDACAI9LFHtgD88yzPfxRBTAAAI5IF3t4D882j/WkxxPAAAA4Il3sSTwp59zjqY8kgAEAcES62FN5aubZbsxjyGAAAByOFvaExuSfWSOPFsAAADgcLexpjcxCYfBxQQADAOBwtLAnNyAXDThilgAGAMDhaGHfwpMy0pO23UgAAwDgcLSwb+SBeemBW91MAAMA4HC0sG/nzux05+0PJIABAHA4Wtg3dUOOuuGWpxLAAAA4HC3sW6uZaj3M1GW7IoABAHA4Wli+89VSmNln9EoCGAAAh6OFpSSZLmt1lzskgAEAcDhaWH4lmcxdoVzvmAAGAMDhaGE5apIRwAAAOBwtLAIYAAAMooXlwElGBgMA4Fj0rwhgAAAwiP713R06wwhgAAAci/713QlgAAAwjP713QlgAAAwjP713QlgAAAwjP71rR09wAhgAAAci/71rQlgAAAwkv71rQlgAAAwkv71fZ0gvQhgAAAci/71fQlgAAAwmP71fQlgAAAwmP71fQlgAAAwmP71Ta1Hl5j9n6+vcnGx26gzfbADPTwAAO9GY/qm1jNJzP7fj49ycbHbDDN9sAM9PAAA70Zj+o7+DCSx4H++vtoY094S9WnIeZXpaznQwwMA8G4EsHc0DS2dXBAppf4sX72lFruQ8yrT13KghwcA4N30zSunN00sU3XNyiBs2erZps+w8szt4umNAADwbHrQt7MleNQ19Z2i3WaY6TMc6OEBAHg3etC3syV4tGvyx/Z2m2Gmz3CghwcA4N3oQd/LxtTRLYsYUysZaWJQ3196rekrOtDDAwDwbvrmlXObxpVZ3bL2TaSQkWYnAWb6ig708AAAvJu+eeXcpnHl6M73igAAODHN6/lFRMmUcsqsIoABAHAgmtfzywDWfpSJUzjZywEA4Nw0r+fXRq/2o0wf3GleCAAA70Dzen5t6Go/yvTxnem1AABwbjrX82tDV/0oc6dwspcDAMCJ6VzPr81d9aPMncLJXg4AACemcz2/NnflR5k4i/O9IgAAzkrnen5t9MqPMnEW53tFAACclc71/NrodcqscsoXBQDAKelcz+/c6SsIYAAAHIXO9fwEMAAA2Amd6/mdO30FAQwAgKPQuZ6fAAYAADuhcz2/c6evIIABAHAUZ+5c/8VF5JOzym+0AAYAwFGcPICVEWckgAEAcDgCGEclgAEAcDgCGEclgAEAcDgCGEclgAEAcDjvGMCi3vr6+ioTv6c+Pj7qVIw/Pz9zHGIclRzHmhjXW7K4Itbn4tAdXUY/snJZ2Ovq7aPGZQ6qrFwW9nJBKqWLh2zYmp2qxRi0X4rQTnWyHupYAAMA4CjO3Lm2zXqrrWccmg0bOZXjGLRT7WWbVSKYtTltqj2uHYe6YdVVVi5jk5r9rt2neviGrdk1tRiDelxqp3IwVacEMAAAjuLMnetS797VMwjluJtq65GsMizF5xj/ecusNq2F2OfmnLN0ee0+1cM3bM2uaY9oI19op3Iw1U7JYAAAHMKZ29al3n1an233M2jlOOoxzssc1JURG7KSl+s2Hp26ysplm16u3ad6+Iat2TW1mIM4sabTbmpWOyWAAQBwCGduW5d692m9bfdbNVbFOD5nJolx5ISspFgWU983ND9SOKu9K9XKylSaXlaz0aXqKtMF6XujHw/ZsDW7phbXB52sh3YsgAEAcAhnblvbBr01rddKO9WmrBxMP3ciic3Wq+lsraxMpfXL6tp9qodv2JpdU4t1EF/zmnKzsrJ5OyWAAQBwCGduW5d6964+DVpVV8+3udYTQnfZad9ZCvnWWY7roOoqGw+6dp/q4Ru2ZtfUYjsbm698R1rtlAAGAMAhnLltXerd23r2+jUUdVM1aWQ93+DKn0usK2NNVkJ7y6z2uHacl+29mUPKxUU9MXWX1bX7VA/fsDW7pha72ThiaarVTglgAAAcwpnb1qXePeqtNk6U0kWbNOIyPsdlDLKYlZSBIbRBZUncnuvb/VPun7qpEMUyuuguW7ft09VbV204K+9tZbHO5iDlcTn+Xvpb1kM7FsAAADiEM7etbYPO+QhgAAAcjgD2FHH0VJk7tfJSfytzj9buLIABAHAIZ25bn9f6swcCGAAAhyOAcVQCGAAAhyOAbfL185sAc88bdp69ZeM+9Xd7POrc58nfn9H+ev3naV+aAAYAwCGcuW19YPaoW+XgUTtv3Kc7/SqPetSN4rj8NYkDzm2PEMAAADiEM7etj8oAnxc5zj3rzjGIqfgc6u9nz3eBUi3GOAchfw19Liuln+L0jaMophzXzevOYeneEPUyWlg2LebmSxtWsSbvzfVRyXErV84ekV+3cn2T9nYBDACAQzhz23pnf19FcmjTTqg7xyBzRSaWWsz1XTEHETxyNmNJLeYgpuq4ajeZHrfx3voq4nNuslRsT5luWMWyem89ZTqYfbx67z3qEUEAAwDgEM7ctrYN+j2m+9RKO1XHkV5CFzDWb5ktVoPvnS2um967vltbvFm7iQAGAMAhnLltfUiXH6b7zAaJdhwBLC5DjWF1tg5CW2xlsaqVdqottrJY1Uo7dUNx1udFrKnLZgetWszBPdpNBDAAAA7hzG3rQ7r8MN1nNkhMl63/bF6YLU6NuXe9OBUhMwNYjKf3zu5WrWy7XbuJAAYAwCGcuW19SJcfbvh5wlw/G8AiseRsvktWizmIqajnuJpuEq69t76KdtlsMW7JcRTr5lOxLO+NxfWU6WD28ersPdpNBDAAAA7hzG3rQ7r8EBGiyyHTmBHqOJJGjFNGlBDjHIRMLLmslH6K8bneUtWE067feO/ssnJ9MS3GZT5bVyyjH7kmxBenztZBbtuO43N9vDp1j3YTAQwAgEM4c9v6kC4/PXCr/Zt9sV0E3QMBDACAwzlz2/rA1PQ199N9ZzX7ddvhyxfAAAA4HAGMoxLAAAA4HAGMoxLAAAA4HAGMoxLAAAA4HAHsYfLficWh099XUX9hYKi/CTB0lyEq+XmqzuZg9sZ2ULVTnaw/ycj9BTAAAA7hzG3rswNAKyNWDUXtr1xvp7plMe5+uUX3zEuXKzd2t4SVqad69nHt/gIYAACHcOa2dWTeiDjUvfFVL9swFqJes1M8YUy1Uap75qXLlRu7W8LKVFqqh5iKB47PoX0VW8QtZfQc7f4CGAAAh3DmtvXZAaC1ctZ0qlZy0Ca0bvHS5cqN3S1hZepPcUvGvDiouz0uO2VilPZEAQwAgEM4c9s6MhKsnDWdqpWVQVq63DKo2qlO1le0a7asH6l9HgEMAIBDOHPbOjIwrJw1naqVOqg/T9gtXrpcubG7JaxM/am95Ybbn6p9HgEMAIBDOHPbOjIwRApq/w1Y+wN77Q8Khu7fgOUg5LLumZcuV26sm1ezx23U3tLdHpedMjFKe6IABgDAIZy5bR0ZCTICZdCKz5F5ah7rpuo4dE8Yd3WVpcuVG/P0HIcYLx23RXvLDbc/VX0e6QsAgKM4c+c6ODBkuErtu2EhQ1HU2zgUolJGF7lDubhYuly/sX2S7rhOredgqp1aWfYS9XkEMAAAjuLMneveAgOPJYABAHA4AhhHJYABAHA4AhhHJYABAHA4AhhHJYABAHA4AtiD1UO70+NyKqeWfmfGkliTv9Kj+1UfUSmjH20lFne3xGWr+wUheUq5+K1d2d01UjxzDgQwAACO4syda23QR6qHLp3e1SO9RCUzTDte0q1p88/0xLYSK+OyzVTd+shmK7OddnZ95fPUcwUwAACO4syd60uCQT106fSu3r2D1KWgqZjt3viql9MT20qOp5VWrcSe7bYxjs+hPmq7oB3HmhwMUM8SwAAAOIozd64jw0BVD106vatPl60/9srsylYRnDLXtXmvW1/XhG5Z1qMy3bAbj1QfRgADAOAozty5dgFjjHro0uldfbps/bFXZmNqKqfqm1R1EMqKH13oykG4djxMPVQAAwDgKM7cub42FSyd3tWny9Yfe2V2ZasYtGoxB9O3sOpUuHY8TD1UAAMA4CjO3Lm+NhUsnd7V2/edwueV/wYs7l05MStdvqontuu7Ne3UteNh8lDpCwCAAzlz8/rCVNAOOl09E1Qmona8pFvf5rHpiVmJBe2eMc5buvU1mHXjdlkd59HT8Uj5MAIYAAAHcubmtQsYY9RDl06f1jPARL2NPStiTSxO7bthcVlGP7JybT3EtnXndtnsgnY83fN58iwBDACAAzlz8zoyDFT10Jec/kDrz9/OtuOaxAbIcwUwAAAO5MzN60siUD30ztPj9qkyN8TKDxa279R179ot3fIM+QURwAAAOJAzN6+DEwuDCWAAAByOAMZRCWAAABzOyQMY5yZ9AQBwLPpX1kTIKaNdEsAAADgW/StrBDAAAHgg/St/2HMGE8AAADgW/St/22cGk74AADgcLSyb7DCDCWAAAByOFpat9pbBBDAAAA5HC8sVdpXBBDAAAA5HC8t19pPBBDAAAA5HC8vVdpLBBDAAAA5HC8stXp7BpC8AAI5IF8uNXpvBBDAAAI5IF8vtXpjBBDAAAI5IF8vtXhXApC8AAA5KI8tdXpLBBDAAAA5KI8u9xmcwAQwAgIPSyPIAIzOY9AUAwHHpZXmMYRlMAAMA4Lj0sjxMzWDPC2PSFwAAh6ad5ZEielWl9FACGAAAh6ad5ZFK9roopYcSwAAAODTtLA9TglejTDyI9AUAwNHpaHmMErl+K3MPIoABAHB0OloepqSu38rc3aQvAABOQFPLI5XU1SgTfymrl9cLYAAAnICmlgcrQapRJhZ0a7rLJH0BAHAO+lqeInNUKqWJldluSgADAOAc9LU8S4aoVEo/ZotTuUz6AgDgNLS2PFEmqFCuN0evVgSwa28BAIB90tfyXJf09P+V6vXuvB0AAPZAR8vTPTA7PXArAAAYTy/LEz0pLz1pWwAAeDZdLE8xICMNOAIAAB5L/8qDDc5Fg48DAIB76Fx5mBdmoRceDQAA2+lZeYCd5J+dPAYAACzRrXKXHWaeHT4SAAAkfSo32nnO2fnjAQDwnnSoXO1A2eZAjwoAwDvQm3KFYXkmD6pKtfHx8RH1+Pz19VVKy5Y2AQCAwXSlbPKqDBP56vPzs1z8iNyVxfgc4yz+6VUvAQAAKv0of7g5t8RdEZDy9i3vU82Ke8uo0RZnF6z4fhoxDACAF9GJsujOrBL35ttTkb66fS4b/1Imfov8FsrFnOnOG60cCgAAz6MHZd79+aTd4bbd1u/K9HXze2shbl8/AgAAHkv3yaI780l77w37/Pn218bfwDHr8sr84QcAYDQ9KH+4Oau0d3U7XLb8pUw0/gxgs3f9aek4AAAYQCfKJjfklnb9tfeGG25Z9/0CRC8AAF5KP8oVrsow7crtd1V/3nLVk2xfDAAAz6Mr5WoHyjMHelQAAN6B3pQb7Tzb7PzxAAB4TzpU7rLDnLPDRwIAgKRP5QF2knl28hgAALBEt8rDvDD/vPBoAADYTs/Kgw3OQoOPAwCAe+hceYoBuWjAEQAA8Fj6V57oSRnpSdsCAMCz6WJ5ugfmpQduBQAA4+llGeTO7HTn7QAAsAc6Woa6IUfdcAsAAOyTvpYX2JipNi4DAICj0N3yMiv5amUKAACOS4/Li3VZq7sEAIAz0emyC9+p6z9FLwAATk6/y15EACsjAAA4KS0veyGAAQBwelpe9kIAAwDg9LS87IUABgDA6Wl52QsBDACA09PyshcCGAAAp6flZS8EMAAATk/Ly14IYAAAnJ6Wl70QwAAAOD0tL3shgAEAcHpaXvZCAAMA4PS0vOyFAAYAwOlpedkLAQwAgNPT8rIXAhgAAKen5WUvBDAAAE5Py8tezAawj39/fP33V7n4558YR6VcAADA0Qhg7MVsAOsSV5fHAADgWAQw9mLpRxA//+szPtpBijAWt7TxLLJZVPJDTgMAYIcEMPZiKYCFnGoX1CQWQauOa+7KJJZFAADYD00qe7ESmSJixWz79le7uI4//v3hZxQBANgzAYy9WH/PqpuNy/ajVH9+LjE+xDAAAHZIAGMv2hw11c2uL/YjiAAA7JMmlb24KoC1/was/h6OWJNvfAlgAADskyaVvbgqgIX8acP2H31l7sqPWgQAgP0QwNiLacQCAICT0fLyevVtq/ajzAEAwIloc3m9LnrlR5kDAIAT0ebyel30yo8yBwAAJ6LN5fW66JUfZQ4AAE5Em8vrddErPsoEAACci06X1+vSV3yUCQAAOBedLq/Xpa/4KBMAAHAuOl12QfoCAOAdaHbZBQEMAIB3oNllFwQwAADegWaXXRDAAAB4B5pddkH6AgDgHeh32QUBDACAd6DfZRcEMAAA3oF+d7/+9W4igL2Z8p0GAOBtaAH3S4N+br6/AABvSAu4Xxr0c/P9BQB4Q1rA/dKgn5vvLwDAG9IC7pcG/dx8fwEA3pAWcL+WGvSot76+vsrE76mPj486FePPz88chxhHJcexJsb1liyuiPW5OHRHl9GPrFwW9rp6+6hxmYMqK5eFvVyQSuniIRu2ZqdqMQbtlyK0U52sh3YMAMCb0ALu11KD3tYzDs2GjZzKcQzaqfayzSoRzNqcNtUe145D3bDqKiuXsUnNftfuUz18w9bsmlqMQT0utVM5mFqZAgDgrLSA+7XUoHf1DEI57qbaeiSrDEvxOcZ/3jKrTWsh9rk55yxdXrtP9fANW7Nr2iPayBfaqRxMrUwBAHBWWsD9WmrQp/XZdj+DVo6jHuO8zEFdGbEhK3m5buPRqausXLbp5dp9qodv2JpdU4s5iBNrOu2mZq1MAQBwVlrA/Vpq0Kf1tt1v1VgV4/icmSTGkROykmJZTH3f0PxI4az2rlQrK1NpelnNRpeqq0wXpO+Nfjxkw9bsmlpcH3SyHtoxAABvQgu4X0sN+rReK+1Um7JyMP3ciSQ2W6+ms7WyMpXWL6tr96kevmFrdk0t1kF8zWvKzcrK5itTAACclRZwv5Ya9K4+DVpVV8+3udYTQnfZad9ZCvnWWY7roOoqGw+6dp/q4Ru2ZtfUYjsbm698R1orUwAAnJUWcL+WGvS2nr1+DUXdVE0aWc83uPLnEuvKWJOV0N4yqz2uHedle2/mkHJxUU9M3WV17T7Vwzdsza6pxW42jliaaq1MAQBwVlrA/Vpq0KPeauNEKV20SSMu43NcxiCLWUkZGEIbVJbE7bm+3T/l/qmbClEso4vusnXbPl29ddWGs/LeVhbrbA5SHpfj76W/ZT20YwAA3oQWcL806Ofm+wsA8Ia0gPv1wgY9jp4qc6dWXupvZe7RnrczAAC7pQXcLw36ufn+AgC8IS3gfmnQz833FwDgDWkB9+t5DfrXzy8GjCPaU9pfk5hytl0zxvTXgeRvtmif7X71lPEvMLzkUAAAXksLuF/Pa9Drzhlp6i8G7AJY1HM8PipMT4xKfc5HqaeMf4HhJYcCAPBaWsD9elKDHpmqRqw4orusn0Odikq+AZWDnA3199GX658NLwvn89LsLWXUPEDKYijXP7N5RE7Nbtg+bTsuKy6yGHI8u2y6+QPFzmUEAMDb0ALu15Ma9IgTbcaIcaasGGTSqAuinoMaQuKyPlXeFeoOYXZlVXeOz7kstMvqeHpvO5WbhKUN6zPEoI7X95wum32BDzR9HgAATk8LuF9PatCn22YlMkbGjDqoK9tbbihW229ZuXd2fdi+oFq/Zf3e+z1jTwAAdk4LuF9PatCn2+abP/k55ZpaaW+p4xi0ajEHoR2n2dk/i2l9fdi+oFq/JQatLD7QM/YEAGDntID79aQGfbptvuXVBrAYZzEv21vqePbxZldWf+4zW0zr68P2BdX6LdP1j/Xs/QEA2CEt4H49qUGPcPX182+oUgStOKvGrdBV2iep4zqb/9Qqx7Mrq3p0d0sWo1Jvmd47O7W0YQ7C0jjN7lnHsy/wgabPAwDA6WkB9+tJDXrkihotqulZs5kktOOMTDUFhaWVVb2lXF/iTVRCDrKYy3Kc6mVXn27YLlgap3rK0rK6eX2BDzR9HgAATk8LuF/Pa9C1/nvguwAA8Ia0gPv1vAb9ST9Tx1UEMACAN6QF3C8N+rn5/gIAvCEt4H5p0M/N9xcA4A1pAfdLg35uvr8AAG9IC7hfh2jQd/6Qe348AQwA4A1pAfdLALufAAYAwK5oAffrcAGs/r9mleuLaTEu8//yqyuW0URMfV7+j6HDtf9/XHFLGe3Pnp8NAIAn0QLu1yEa9PqQkaYyHbW/4362GLfkOIrT/0voqXZ99zWJy06ZOIJjPS0AAA+hBdyvQzTo9SHbp72huOLa9UdxptcCAMBGWsD9OkSDXh9yNiZtL664dv1RnOm1AACwkRZwvw7RoNeHnI1J24srVtbHZadMHMGxnhYAgIfQAu7XIRr0+pCz/9xrthi31H/TtfHfgJXRQb4mG53ptQAAsJEWcL8O0aC3DxmxKi5r0ErTYlxG9JoWy2iinVpZdjhnei0AAGykBdyvszbogkfydQAAeENawP0SwM7N1wEA4A1pAfdLg35uvr8AAG9IC7hfGvRz8/0FAHhDWsD9ekmDXg/tTo/LqZzK36iR8ncersvfiBiLu1+BGJUy+tFWYnF3S1y2Ys/29DylXPzWruzuGimeuYwAAHgbWsD9ekmDXg9dOr2rR3qJSmaYdrykW9Pmn+mJbSVWxmWbqbr1kc1WZjvt7PrK53nVuQAAvJAWcL9e0qDXQ5dO7+rdO0hdCpqK2e6Nr3o5PbGt5HhaadVK7NluG+P4HOqjtgvacazJwQAjzwIAYCe0gPv1kga9Hrp0elefLlt/7JXZla0iOGWua/Net76uCd2yrEdlumE3Hmn6egEAOD0t4H69pEGvhy6d3tWny9Yfe2U2pqZyqr5JVQehrPjRha4chGvHw7zkUAAAXksLuF+vTQVLp3f16bL1x16ZXdkqBq1azMH0Law6Fa4dD/OSQwEAeC0t4H69NhUsnd7V2/edwueV/wYs7l05MStdvqontuu7Ne3UteNhXnIoAACvpQXcr9emgqXTu3omqExE7XhJt77NY9MTsxIL2j1jnLd062sw68btsjrOo6fjkaavFwCA09MC7tdLGvR66NLp03oGmKi3sWdFrInFqX03LC7L6EdWrq2H2Lbu3C6bXdCOp3s+z8izAADYCS3gfr2kQa+HHj0erD9/O9uOaxIb4OhfYQAAbqAF3K+XNOj10DtPj9unytwQKz9Y2L5T171rt3TLMwz+ggAAsAdawP3SoJ+b7y8AwBvSAu6XBv3cfH8BAN6QFnC/okHn3Mp3GgCAt6EFZC8EEgAATk/Ly14IYAAAnJ6Wl70QwAAAOD0tL3shgAEAcHpaXvZCAAMA4PS0vOyFAAYAwOlpedkLAQwAgNPT8rIXAhgAAKen5WUvBDAAAE5Py8teCGAAAJyelpfXi+g1VeYAAOBEtLm8Xolcv5U5AAA4EW0ur1ci129lDgAATkSby+uVyPVbmQMAgBPR5vJ6JXI1ygQAAJyLTpfXK6mrUSYAAOBcdLq8XkldjTIBAADnotNlF0rwuiglAAA4Hc0uu1Cy10UpAQDA6Wh22YWSvS5KCQAATkezyy6U7CV9AQBwavpddqHELwEMAIBT0++yCyV+CWAAAJyafpdn+d//8R9XfUT66ip/fpSTAADgIAQwnuWqgJSLb7gFAAAORADjWbYHpHblbXcBAMAhCGA8y8aANF12840AALBzAhjPsiUgLa25514AANgtAYxn+TMgrS+483YAANghAYxnuTNfhft3AACAXRHAeJaVgLQ9Oz1kEwAA2AkBjGdZCkjXBqdH7QMAAC8ngPEsswHpttT0wK0AAOCFBDCeZRqQ7olMj90NAABeQgDjWbqAdH9eeviGAAAwmADGs7QBqR3/a6JM/CVWLu0JAACHIIDxLDUgdUlpe+Lq5I1L2wIAwP4JYDxLBqRpTFoKYFH//PyMz+Hr66tU//nn4+MjK/E5K0s7AwDAzglgPEsEpNmMVHNUJ+qRtWLQZq2IZBnGMoZlMSxtDgAAeyaA8SxLASlyVKfWcxDWi0kAAwDgcH51tPBAS29SdTmquiqALW0OAAB7Nt8Kw/0yIE1j0v0BbGlnAADYuflWGO5XA1KXlK4KYNN/A7a0LQAA7J8AxrO0AakdR47q1HoOQjtufwvi0p4AAHAIAhjP0gWk+/PSwzcEAIDBBDCeZRqQ7olMj90NAABeQgDjWWYD0m2p6YFbAQDACwlgPMtSQLo2OD1qHwAAeDkBjGdZCUjbs9NDNgEAgJ0QwHiW9YC0JT7dvwMAAOyKAMaz/BmQ7sxXAhgAAIcjgPEsWwLS0pp77gUAgN0SwHiWjQFpuuzmGwEAYOcEMJ5le0BqV952FwAAHIIAxrNcFZBy8Q23AADAgQhgPEsEpGd/lJMAAOAgBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIBBBDAAAIAh/vnn/wE/PugzrW9cKQAAAABJRU5ErkJggg== Output for this flowchart :
- A) Inside the loop: n = 0 Inside the loop: n = 1 Inside the loop: n = 2 Inside the loop: n = 3 Inside the loop: n = 4 Inside the loop, after CONTINUE: n = 5 Inside the loop: n = 5 Inside the loop, after CONTINUE: n = 6 Inside the loop: n = 6 Inside the loop, after CONTINUE: n = 7 When out from the loop: n = 7
- B) Inside the loop: n = 0 Inside the loop: n = 1 Inside the loop: n = 2 Inside the loop: n = 3 Inside the loop: n = 4 Inside the loop, after CONTINUE: n = 5 Inside the loop: n = 5 Inside the loop, after CONTINUE: n = 6
- C) Inside the loop: n = 0 Inside the loop: n = 1 Inside the loop: n = 2 Inside the loop: n = 3 Inside the loop: n = 4
- D) Inside the loop: n = 0 Inside the loop: n = 1 Inside the loop: n = 2 Inside the loop: n = 3 Inside the loop: n = 4 Inside the loop: n = 6 Inside the loop, after CONTINUE: n = 7 When out from the loop: n = 7
The set of rows the cursor holds is referred to as the __________.
- A) active set
- B) simple set
- C) inactive set
- D) complex set
A _____ is a pointer to this context area.
- A) records
- B) trigger
- C) cursor
- D) packages
What is the maximum number of exception handlers processed before the PL/SQL block is exited, provided an exception occurs?
- A) None
- B) All exceptions that apply
- C) All exceptions that are referenced in the block
- D) One