Oracle 1Z0-144 Actual Free Exam Questions & Community Discussion
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?
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?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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?
Which type of composite data type would you choose to fulfill the requirement?
Correct Answer: A
Vote an answer
Examine the following code that you plan to execute:
What correction should be performed in the above code?
What correction should be performed in the above code?
Correct Answer: A,B
Vote an answer
Examine the following snippet of PL/SQL code:
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has
200 rows.
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as 'ST_CLERK' and salary greater than 3000.
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has
200 rows.
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as 'ST_CLERK' and salary greater than 3000.
Correct Answer: E
Vote an answer
View the Exhibit and examine the structure of the employees table.
Examine the following block of code:
What is the outcome when the above code is executed?
Examine the following block of code:
What is the outcome when the above code is executed?
Correct Answer: B
Vote an answer
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.)
What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)
Correct Answer: A,C
Vote an answer
View the Exhibit and examine the structure of the EMP table.
You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)
You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)
Correct Answer: A,B
Vote an answer
0
0
0
10