Oracle Database: Advanced PL/SQL - 1z1-148 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two statements are correct about the collections before v3. DELETE is executed?

A. The value of v3 (31) (1) is "hello". B. The value of v3 (31) (1) and v3 (33) (3) are identical, C. The values of v3 (32) (2) and v1 (2) are identical. D. The value of v3 (31) (3) is 6. E. The values of v3(31) (2) and v3 (33) (2) are identical.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

Identify the two correct scenarios where a function can be optimized using the function result cache feature.

A. A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative. B. A function which calculates the factorial of a given number without accessing any table. C. A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE. D. A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION. E. A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

Examine this code:

Which two corrections must be applied for this anonymous block to execute successfully?

A. Define the function as stand-alone instead of in a package body. B. Change the INDEX BY clause from VARCHAR2 to PLS_INTEGER. C. Change RETURN p_tab.LAST to RETURN p_tab.COUNT. D. Declare the collection type at the schema level instead of the package. E. Declare the collection type inside the function. F. Modify the function return type to return a scalar, VARCHAR2.

Discussion 0

Correct Answer: B,F Vote an answer

Question 4

Which two can be used to find details of parameters for overloaded PL/SQL routines?

A. ALL_SOURCE B. ALL-DEPENDENCIES C. ALL_DESCRIBE D. ALL_ARGUMENTS E. ALL_PROCEDURES

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Examine this code:

Assuming the default edition is ORA$BASE, what is the result of the last execution of hello?

A. An exception is raised. B. Hello, edition 2.
Hello, edition 1. C. Hello, edition 1.
Hello, edition 2. D. Hello, edition 1. E. Hello, edition 2.

Discussion 0

Correct Answer: D Vote an answer

Question 6

Examine this block of code used to calculate the price increase for all the productivity by 1% and then by 2%.

What will be the outcome on execution?

A. It will go into an endless loop because the loop exist condition is missing. B. It will display the price increase by 1% only for all the products. C. It will display the price increase by 1% only for the first product. D. It will give an error because the calculated column in the cursor is not using a column alias in this block. E. It will give an error because PDT_REC is not declared.

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which two blocks of code execute successfully?

A. DECLARE
SUBTYPE new_one IS NUMBER (1, 0); my_val new_one; BEGIN my_val := -1;
END; B. DECLARE
SUBTYPE new_one IS NUMBER (2, 1); my_val new_one; BEGIN my_val :=12.5; END; C. DECLARE
SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9; my_val new_one; BEGIN my_val :=0; END; D. DECLARE
SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL; my_val new_one; BEGIN my_val :=2; END; E. DECLARE
SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string; BEGIN my_str := 'abc'; END;

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

Examine this declaration section:

Which two executable sections will display the message 'Summary is null'?

A. BEGIN1_emp := emp_typ ();IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND; B. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := EMPTY_CLOB ();1_emp := emp_typ (1_rec);IF
1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND; C. BEGIN1_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND; D. BEGIN1_rec := NULL;1_emp := emp_typ (1_rec);IF 1_emp (1).expr_summary IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END; E. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := NULL;1_emp :=emp_typ (1_rec);IF
1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;

Discussion 0

Correct Answer: A,E Vote an answer