Correct Answer: False
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle PL/SQL 9i Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle PL/SQL 9i MCQ Questions
Examine the Block given below: declare v_no number:=2; v_msg varchar2(20):='Goodbye'; begin case When v_no=1 then dbms_output.put_line('One!'); dbms_output.put_line('Another One!'); When v_no>1 then dbms_output.put_line('>1!'); dbms_output.put_line('Still>1!'); when v_msg='Goodbye' then dbms_output.put_line('Goodbye'); dbms_output.put_line('Adios'); else dbms_output.put_line('No Match'); end case; end; / What is the output of this block?
Which cursor allows passing values dynamically to a cursor?
Examine the code given below: CREATE OR REPLACE FUNCTION gen_email (first_name VARCHAR2, last_name VARCHAR2, id NUMBER) RETURN VARCHAR2 IS email_name VARCHAR2(19); BEGIN email_name := SUBSTR(first_name, 1, 1) || SUBSTR(last_name, 1, 7) ||[email protected] .; UPDATE employees SET email = email_name WHERE employee_id = id; RETURN email_name; END; Which of the following statements removes the function?
__________ is present in Oralce9i only.
Which statements is correct with regard to stored procedures?
The OLD and NEW qualifiers can be used in Row level system trigger.
The Technique employed by the Oracle engine to protect table data when several people are accessing is called: