Validated 1Z0-144 Study Guides 2021

NEW QUESTION 1
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?

• A. The SQLERRM function
• B. The PRAGMA EXCEPTION_INIT function
• C. The RAISE_APPLICATION_ERROR procedure
• D. A user-defined exception used with a raise statement

Answer: B

Explanation:
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/exceptioninit_pragma.htm#LNPL S01315

NEW QUESTION 2
Examine the following block of code:

Which line in the above code would result in errors upon execution?

• A. line 5
• B. line 8
• C. line 2
• D. line 7

Answer: B

NEW QUESTION 3
Examine the following PL/SQL code;

The execution of the code produces errors. Identify the error in the code.

• A. The open cursor is missing
• B. The fetch clause is missing
• C. The exit when condition is missing
• D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statemen

Answer: B

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

SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?

• A. The execution fails because of the misplaced else claus
• B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
• C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is foun
• D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is foun

Answer: C

NEW QUESTION 5
Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)

• A. The function goes through only the parse and executes phase
• B. The function goes through the parse, bind, and execute phase
• C. The function goes through the parse, bind, execute, and fetch phase
• D. All the processing phases for the function are performed only at run tim
• E. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run tim

Answer: DE

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
ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

• A. It gives an error in line 3
• B. It gives an error in line 4
• C. It gives an error in line 6
• D. It executes successfully and displays the outpu

Answer: D

NEW QUESTION 8
Which two statements are true about PL/SQL exception propagation? (Choose two.)

• A. The exception reproduces Itself In successive enclosing blocks until a handler is foun
• B. Exception- can propagate across the remote subprograms that are called through database link
• C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exceptio
• D. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exceptio

Answer: AC

NEW QUESTION 9
View the exhibit to examine the PL/SQL code.

Which statement is true about the exception handlers in the PL/SQL code?

• A. All the exceptions in the code are trapped by the exception handle
• B. All the "no data found" errors in the code are trapped by the exception handle
• C. The PL/SQL program does not execute because an exception is not declared in the declare sectio
• D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of cod

Answer: B

NEW QUESTION 10
Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

• A. line 2
• B. line 3
• C. line 4
• D. line 5

Answer: BD

NEW QUESTION 11
In which of the following scenarios would you recommend using PL/SQL records?

• A. when you want to retrieve an entire row from a table and perform calculations
• B. when you know the number of elements in advance and the elements are usually accessed sequentially
• C. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
• D. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked

Answer: CD

NEW QUESTION 12
Examine the following code:

What is the outcome?

• A. The procedure is created successfully and displays the values 20 and 30 when it is calle
• B. The procedure gives errors because the parameters should be in out mod
• C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedur
• D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedur

Answer: C

NEW QUESTION 13
Examine the following PL/SQL code:

Which statement is true about the execution of the PL/SQL code?

• A. It executes successfull
• B. It generates a run-time exceptio
• C. It does not execute because of syntax error
• D. It executes successfully and generates a warnin

Answer: B

Explanation: Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm

NEW QUESTION 14
Which type of exceptions is qualified as no predefined Oracle server errors?

• A. the exceptions that are explicitly raised by the program and can be caught by the exception handler
• B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
• C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
• D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

Answer: C

NEW QUESTION 15
The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?

• A. It displays Output buffer not long enoug
• B. This is my test string.-.
• C. It displays only Output buffer not long enough, and exits the anonymous bloc
• D. It displays only This is my test strin
• E. - Because EXCEPTION should have been defined in the anonymous block to get the error messag
• F. It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedur

Answer: A

NEW QUESTION 16
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 17
Which two statements are true about database triggers? (Choose two.)

• A. Each trigger can be of any siz
• B. Each trigger can be of a maximum size of 32 K
• C. A trigger can contain a maximum of 32 lines of cod
• D. Triggers fired by DML statements cannot cascade simultaneousl
• E. Both DML and DDL statements can cascade any number of triggers,
• F. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers

Answer: BE

Explanation: Reference: http://www.dba-oracle.com/m_trigger.htm