1z0-148 試験問題を無料オンラインアクセス

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:

Examine this code:

Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.DEF DEPT table?

• A.Change the IF condition in the anonymous block to CARDINALITY (1_dept) IS NULL.
• B.IN BRANCH2 execute GRANT INHERIT PRIVILEGES ON USER branch2 TO branch1;
• C.Change the IF condition in the anonymous block to 1_dept IS EMPTY.
• D.Add BEQUEATH CURRENT_USER to the EMP_COUNTS_VW view.
• E.Add AUTHID CURRENT_USER to the EMP_COUNT function.
• F.Add BEQUEATH DEFINER to the EMP_COUNT_VW view.

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.
Examine this PL/SQL package AS

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

• A.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• B.CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• C.CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• D.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• E.CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/

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

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

Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?

• A.1 and 3
• B.2 and 3
• C.2, 3 and 4
• D.2 and 4
• E.1 and 4

Which is the correct method for releasing unused money after deleting elements of a collection?

• A.Use the TRUNCATE method on the collection.
• B.Execute DBMS_SHARED_POOL.UNKEEP.
• C.Flush the shared pool using the ALTER SYSTEM command.
• D.Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.