100%(1)1 out of 1 people found this document helpful
This preview shows page 24 - 26 out of 70 pages.
Which of the following is the syntax to fetch from a cursor variable?You want to display all records in the database whose salary is above the salary of Alexander Hunold.Procedure can be stored in the database as a schema object.In PL/SQL Block Structure, which of the following are mandatory?PL/SQL stands forWhich of the following is CORRECT about sub-queries?Which of the following does NOT describes SELECT Statement in a PL/SQL.PL/SQL Provides a block structure for executable units of ________________.Evaluate the SQL commandSELECT employee_id, salary from employees where salary = ANY (SELECT salary FROM employees WHERE job_id = 'IT_PROG') AND job_id = 'ST_CLERK'Which of the following PL/SQL will execute successfully?In PL/SQL Block Structure, which of the following are OPTIONAL?Evaluate the following PL/SQL. At what line number is the error of the PL/SQL?
EXCEPTIONWHEN e_invalid THENDBMS_OUTPUT.PUT_LINE('No such department id.');END;Answer: 7What is the error trapping function that returns the numeric value of the error code?Fetch into a record when fetching from a cursor.Which of the following is the syntax to open a cursor varialFOR select_statement;Which of the following is the syntax to define a REF CURSOR type?Evaluate the following. What will be the output?