Online Access Free 1z0-148 Exam Questions

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

• A.A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
• B.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.
• C.A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
• D.A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
• E.A function which calculates the factorial of a given number without accessing any table.

The STUDENTS table with column LAST_NAME of data type VARCHAR2 exists in your database schema.
Examine this PL/SQL block:

Which two actions must you perform for this PL/SQL block to execute successfully?

• A.Add names_varray.EXTEND after the FOR ...LOOP statement.
• B.Replace the NAMES_VARRAY declaration with names_varray 1_name_type := 1_name_type ();
• C.Add name_rec name_cur%ROWTYPE; at the end of the DECLARE section.
• D.Replace the NAMES_VARRAY declaration with names_varray 1_name_type := null;
• E.Replace the FOR loop with FOR name_rec IN names_varray.FIRST .. names_varray.LAST LOOP.
• F.Replace the L_NAME_TYPE declaration with TYPE 1_name_type IS VARRAY (25) OF SYS_REFCURSOR;

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_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• C.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;
• 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 := 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;

Examine this code:

Examine this DML statement executed in the SCOTT schema:
UPDATE emp SET comm = 1000 WHERE deptno= 20;
What is the outcome after executing this statement?

• A.COMM is set to 1000 for all records in the EMP table where DEPTNO=20.
• B.COMM is set to 1000 for all records in the EMP table where DEPTNO = 30.
• C.The statement executes successfully but no rows are updated.
• D.The statement fails with error ORA-28115: policy with check option violation.

Examine this code executed as SYS:

Examine this code executed as SPIDER and the error message received upon execution:

What is the reason for this error?

• A.The user SPIDER needs to be granted the CREATE TABLE privilege and the procedure needs to be granted the DYNAMIC_TABLE_ROLE.
• B.The EXECUTE IMMEDIATE clause is not supported with roles.
• C.The procedure needs to be granted the DYNAMIC_TABLE_ROLE role.
• D.Privileges granted through roles are never in effect when running definer's rights procedures.