High value 1Z0-144 Exam Questions and Answers 2021

NEW QUESTION 1
Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

• A. Each fetch retrieves the first row and assigns values to the target variable
• B. Each fetch retrieves the next consecutive row and assigns values to the target variable
• C. They produce an error because you must close and reopen the cursor before each fetch -statemen
• D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an erro

Answer: B

NEW QUESTION 2
You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

• A. It should be an after trigge
• B. It should be a before trigge
• C. It should be a row-level trigge
• D. It should be a statement-level trigge
• E. It can be a before or an after trigge

Answer: AC

NEW QUESTION 3
Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

• A. The code executes successfully and gives the desired outpu
• B. The code generates an error because the EMP_RECORD variable is not declare
• C. The code generates an error because the cursor is not opened before the FOR loo
• D. The code generates an error because the loop does not have the exit when claus

Answer: A

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

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

• A. The output is x =
• B. It produces an erro
• C. The output Is x !=
• D. The output Is Can't tell if x and y are equal or no

Answer: A

NEW QUESTION 5
You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:

Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.)

• A. ON SCHEMA
• B. ON QRXABASE
• C. AFTER LOGOFF
• D. BEFORE LOGOFF

Answer: AD

NEW QUESTION 6
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 7
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

• A. Only HR
• B. SCOTT and HR
• C. Only SCOTT
• D. SCOTT, HR, and SYS

Answer: A

NEW QUESTION 8
Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

• A. It displays null if no employee with employee_id 123 exist
• B. It produces the ora-01403: no data found error if no employee with employee_id 123 exist
• C. It displays an error because the select into clause cannot be used to populate the PL/SQL record typ
• D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Foun

Answer: B

NEW QUESTION 9
Which statement is true about triggers on data definition language (DDL) statements?

• A. They can be used to track changes only to a table or inde
• B. They can be defined by all users in the database or only by a specific use
• C. They are fired only when the owner of the object Issues the DDL statemen
• D. They can be used to track changes to a table, table space, view, or synony

Answer: D

NEW QUESTION 10
Examine the following PL/SQL code:

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

• A. The program abruptly terminates and an exception is raise
• B. The program executes successfully and the output is No ROWS_FOUN
• C. The program executes successfully and the query fetches a null value in the V_LNAME variabl
• D. Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raise

Answer: A

NEW QUESTION 11
View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What would be the outcome when the code is executed?

• A. It executes successfull
• B. It gives an error because the SAL variable is not visible in the increase functio
• C. It gives an error because the increase function cannot be called from the RAISE_SALARY procedur
• D. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declaration

Answer: A

NEW QUESTION 12
View the Exhibit and examine the blocks of code that you plan to execute.
Which statement is true about the blocks of code?

• A. All the blocks execute successfully and the anonymous block displays 1 2 3 cant: 45 45 cnt: 45
• B. All the blocks execute successfully and the anonymous block displays 1 2 3 cut: 0 45 cart: 1
• C. The anonymous block gives an error because the function invocation in line 2 is not vali
• D. The procedure creation gives an error because the function invocation in line 1 is not vali

Answer: A

NEW QUESTION 13
Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)

• A. setting the UTL_FILE_DIR initialization parameter
• B. running the UTLMAIL.SQL and prvtmail.plb scripts
• C. setting the SMTP_OUT_SERVER initialization parameter
• D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
• E. granting read and WRITE privileges to control the type of access to files in the operating system

Answer: BC

NEW QUESTION 14
View the Exhibit and examine the code.

Why does the code give an error on execution?

• A. because the WORD_LIST variable is not visible in procedure wording
• B. because the lexicon variable is not visible in procedure ADD_ENTRY
• C. because the lexicon variable is not initialized in procedure wording
• D. because the WORD_LIST parameter in out mode cannot be of a record data type

Answer: A

NEW QUESTION 15
Which statements are true about PL/SQL procedures? (Choose all that apply.)

• A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itsel
• B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run tim
• C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performanc
• D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Jav

Answer: BD

NEW QUESTION 16
Which two statements are true about the exit statement encountered in loop? (Choose two)

• A. The PL/SQL block execution terminates immediately after the exit statemen
• B. The loop completes immediately and control passes to the statement after end loop
• C. The statements after the exit statement in the Iteration are not executed before terminating the LOO
• D. The current iteration of the loop completes immediately and control passes to the next iteration of the loo

Answer: BD

Explanation: Reference: http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm

NEW QUESTION 17
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