Oracle 1Z0-144 Exam Dumps 2021

NEW QUESTION 1
View Exhibit1 and examine the structure of the DO table.

View Exhibit2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

• A. The assignment in line 7 is not vali
• B. The SQL does not support the Boolean data typ
• C. A null value cannot be applied to the bind arguments In the using clause in line 10
• D. The names of bind variables must be the same as the using clause bind arguments in line 10

Answer: A

NEW QUESTION 2
Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

• A. A procedure can contain a return statement without a valu
• B. A function can return multiple values using a single return clause,
• C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
• D. A function can contain zero or more parameters that are transferred from the calling environmen

Answer: A

Explanation: Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm (using the return statement)

NEW QUESTION 3
View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

• A. MY_PROC2 is not recompile
• B. MY_PROC1 is recompiled but remains unchange
• C. MY_PROC2 is recompiled but remains unchange
• D. MY_PROC1 is recompiled without the debugging cod

Answer: AD

NEW QUESTION 4
Which two statements are correct about the usage of parameters in functions? (Choose two.)

• A. Functions can have only in mode parameter
• B. Functions called in SQL statements cannot have out or in out mode parameter
• C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
• D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous block

Answer: BD

NEW QUESTION 5
View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?

• A. The exception raised in the code is handled by the exception handler for the PAST_DUE exceptio
• B. It does not execute because you cannot declare an exception with a similar name in the subbloc
• C. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subbloc
• D. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

Answer: D

NEW QUESTION 6
You execute the following block of code:

Which statement is true about the outcome?

• A. Both Output statements show different value
• B. Both output statements show exactly the same value
• C. It gives an error because the nested blocks are not labele
• D. It gives an error because the V_CUSTOMER variable have different types in the nested blocks

Answer: A

NEW QUESTION 7
View the Exhibit and examine the structure of the SALGRADE table.

Examine the following code:

What is the outcome?

• A. It is created successfull
• B. It gives an error because the return clause condition is invali
• C. It gives an error because the usage of the host variables is invali
• D. It gives an error because the data type of the return clause is invali

Answer: B

NEW QUESTION 8
View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

• A. call in line 6
• B. call in line 7
• C. call in line 8
• D. call in line 9

Answer: CD

NEW QUESTION 9
Examine the following code that you plan to execute:

What correction should be performed in the above code?

• A. The PROC2 procedure code should be defined in the package bod
• B. The PROC3 procedure should be declared in the package specificatio
• C. The PROC3 procedure header should be declared at the beginning of the package bod
• D. The variable x must be declared in the package body and removed from the specification,

Answer: AB

NEW QUESTION 10
Which two statements are true about the continue statement? (Choose two.)

• A. The PL/SQL block execution terminates immediatel
• B. The CONTINUE statement cannot appear outside a loo
• C. The loop completes immediately and control passes to the statement after end loo
• D. The statements after the continue statement in the iteration are executed before terminating the LOO
• E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop

Answer: BE

NEW QUESTION 11
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.)

• A. JONES executes the procedure with definer's right
• B. JONES executes the procedure with invoker's right
• C. SCOTT should grant only the execute privilege for the procedure to JONE
• D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

Answer: AC

NEW QUESTION 12
Examine the following package specification:

Which statement is true?

• A. g_comm has a value of 15 at 9: 06 AM only for Jones
• B. g_comm has a value of 10 at 9: 03 AM for both Jones and smith
• C. g_comm has a value of 15 at 9: 03 AM for both Jones and smith
• D. g_comm has a value of 20 at 9: 06 AM for both Jones and smith

Answer: A

Explanation:
Package variable state is scoped at the session level. So the only user who can see G_COMM=15 will be Jones

NEW QUESTION 13
Which two statements are true about statement-level and row-level triggers? (Choose two.)

• A. A row trigger fires once even if no rows are affecte
• B. A statement trigger fires once even if no rows are affecte
• C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itsel
• D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itsel

Answer: BC

NEW QUESTION 14
You create the following table and execute the following code:

Which statement is true about the outcome of the above code?

• A. It executes successfully and all the rows are update
• B. It gives an error but saves the inserted rows and the update to the first ro
• C. It gives an error but saves the inserted rows; however, no rows are update
• D. It gives an error and all the data manipulation language (DML) statements are rolled back

Answer: A

NEW QUESTION 15
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?

• A. SCOTT’S session displays 5, and then 0, greets session displays 0.
• B. SCOTT’S session displays 5, and then 0; green's session displays 5.
• C. SCOTT’S session displays 5, and then 5 again, green's session displays 0.
• D. SCOTT’S session displays 5, and then 5 again; green's session displays 5.

Answer: B

NEW QUESTION 16
View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
EMPLOYEES

DEPAERTMENT

EMP_BY_DEPT

Examine the following code:

What is the outcome on execution of the above code?

• A. It executes successfully but the output statements show different value
• B. It executes successfully and both output statements show the same value
• C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLEC
• D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL

Answer: A

NEW QUESTION 17
View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?

• A. It gives an error because the return type is not vali
• B. It gives an error because the record type is not defined within the function
• C. It gives an error because the function call in DBMS_OUTPU
• D. PUT__LINE is not valid
• E. It executes successfully and displays the names and salaries of all employees who earn the highest salar
• F. It executes successfully but does not display the names and salaries of all employees who earn the highest salar

Answer: D