Oracle 1Z0-144 Actual Free Exam Questions & Community Discussion
View the Exhibit to examine the PL/SQL code.
Which statement is true about the execution of the code?
Which statement is true about the execution of the code?
Correct Answer: C
Vote an answer
Which two statements are true about database triggers? (Choose two.)
Correct Answer: C,D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.
Correct Answer: A
Vote an answer
Which two statements are true about anonymous blocks and named subprograms?
(Choose two)
(Choose two)
Correct Answer: A,D
Vote an answer
Examine the following code:
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
Correct Answer: B
Vote an answer
View the Exhibit and examine the structure of the departments table in SCOTT's schema.
Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the
procedure.
Which two statements are true in the above scenario? (Choose two.)
Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the
procedure.
Which two statements are true in the above scenario? (Choose two.)
Correct Answer: B,C
Vote an answer
0
0
0
10