Our pass rate is high to 98.9% and the similarity percentage between our 1Z0-144 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle 1Z0-144 exam in just one try? I am currently studying for the Oracle 1Z0-144 exam. Latest Oracle 1Z0-144 Test exam practice questions and answers, Try Oracle 1Z0-144 Brain Dumps First.
Q21. Examine the following code:
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
A. Use the TO_DATE function in line 2.
B. Use the TO_DATE function in line 7.
C. Use the TO_NUMBER function in line 6.
D. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.
Q22. 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
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object');
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
Q23. You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information.
Which type of composite data type would you choose to fulfill the requirement?
B. Nested table
C. PL/SQL records
D. Associative arrays
Q24. Which two statements are correct about the usage of parameters in functions? (Choose two.)
A. Functions can have only in mode parameters.
B. Functions called in SQL statements cannot have out or in out mode parameters.
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 blocks.
Q25. 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
Q26. 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 affected.
B. A statement trigger fires once even if no rows are affected.
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 itself.
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 itself.
Q27. Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The CONTINUE statement cannot appear outside a loop.
C. The loop completes immediately and control passes to the statement after end loop.
D. The statements after the continue statement in the iteration are executed before terminating the LOOP.
E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
Q28. Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)
A. Add exception handlers whenever errors occur.
B. An exception handler should commit the transaction.
C. Handle named exceptions whenever possible instead of using when others in exception handlers.
D. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.
Q29. 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 enough.
This is my test string.-.
B. It displays only
Output buffer not long enough, and exits the anonymous block.
C. It displays only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message.
D. 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 procedure.
Q30. Examine the following partial code:
Which statement is correct about the unnamed block of code at the end of a package body?
A. It generates an error because all the blocks of code in a package body must be named.
B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.
C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.
D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.