What is the purpose of the %ROWTYPE attribute in Oracle 11g?

• A) To check if a variable holds a record data type
• B) To convert a record variable into a string
• C) To automatically populate a record with data from a table row
• D) To define a new record type based on an existing table

Which of the following statements is true about cursors and records in Oracle 11g?

• A) You cannot use record variables with FOR loops iterating through a cursor
• B) Cursors directly store records, eliminating the need for record variables
• C) Record variables are required to hold data fetched from a cursor
• D) Cursors automatically close after fetching the first record

Which of the following is correct syntax to open the Cursor?

• A) SELECT cursor_name
• B) OPEN cursor_name
• C) UPDATE cursor_name
• D) INSERT cursor_name

Which of the following built-in packages is used for advanced exception handling in Oracle 11g(PL/SQL)?

• A) DBMS_ERROR
• B) PL/SQL.STANDARD_ERROR
• C) UTL_ERROR
• D) java.sql.SQLException

What is the name of the cursor written and maintained by a database user?

• A) User-defined cursor
• B) Implicit cursor
• C) User cursor
• D) Explicit cursor

BEGIN FOR l_index IN 1 .. 10 LOOP CONTINUE WHEN MOD (l_index, 2) = 0; DBMS_OUTPUT.PUT_LINE ('Loop index = ' || TO_CHAR (l_index)); END LOOP; END; / Output for this piece of code :

• A) Loop index = 1 Loop index = 3 Loop index = 5 Loop index = 7 Loop index = 9
• B) Loop index = 1 Loop index = 3
• C) Loop index = 5 Loop index = 7 Loop index = 9
• D) Loop index = 1

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

• 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: 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 Inside the loop: n = 6 Inside the loop, after CONTINUE: n = 7 When out from the loop: n = 7
• 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, after CONTINUE: n = 5 Inside the loop: n = 5 Inside the loop, after CONTINUE: n = 6

DECLARE no NUMBER := 0; BEGIN FOR no IN 1 .. 5 LOOP DBMS_OUTPUT.PUT_LINE('Iteration : ' || no); CONTINUE WHEN no = 4 DBMS_OUTPUT.PUT_LINE('CONTINUE WHEN EXECUTE Iteration : ' || no); END LOOP; END; / Output for this piece of code :

• A) Iteration # 1 Iteration # 2 Iteration # 3
• B) Iteration # 1 Iteration # 2 Iteration # 3 CONTINUE WHEN EXECUTE Iteration: 4 Iteration # 5
• C) Iteration # 1 Iteration # 3 CONTINUE WHEN EXECUTE Iteration: 4 Iteration # 5
• D) Iteration # 1 Iteration # 2 Iteration # 3 CONTINUE WHEN EXECUTE Iteration: 4

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 # 2 Iteration # 4 Iteration # 5
• B) Iteration # 1 Iteration # 2 Iteration # 4 Iteration # 5
• C) Iteration # 1 Iteration # 2 Iteration # 5
• D) Iteration # 1 Iteration # 4 Iteration # 5

DECLARE x NUMBER := 0; BEGIN LOOP -- After CONTINUE statement, control resumes here DBMS_OUTPUT.PUT_LINE ('Inside loop: x = ' || TO_CHAR(x)); x := x + 1; IF x < 3 THEN CONTINUE; END IF; DBMS_OUTPUT.PUT_LINE ('Inside loop, after CONTINUE: x = ' || TO_CHAR(x)); EXIT WHEN x = 5; END LOOP; DBMS_OUTPUT.PUT_LINE (' After loop: x = ' || TO_CHAR(x)); END; / Output for this piece of code :

• A) Inside loop: x = 0 Inside loop: x = 1 Inside loop: x = 2 Inside loop, after CONTINUE: x = 3
• B) Inside loop: x = 0 Inside loop: x = 1 Inside loop: x = 2 Inside loop, after CONTINUE: x = 3 Inside loop: x = 3 Inside loop, after CONTINUE: x = 4
• C) Inside loop: x = 0 Inside loop: x = 1 Inside loop: x = 2 Inside loop, after CONTINUE: x = 3 Inside loop: x = 3 Inside loop, after CONTINUE: x = 4 Inside loop: x = 4 Inside loop, after CONTINUE: x = 5 After loop: x = 5
• D) Inside loop: x = 0 Inside loop: x = 1 Inside loop: x = 2 Inside loop, after CONTINUE: x = 3 Inside loop: x = 3 Inside loop, after CONTINUE: x = 4