Online Access Free 1z1-148 Exam Questions

Which two statements are true about the DBMS_ LOB package?

• A.DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
• B.DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
• C.DBMS_LOB.COMPARE can compare parts of two LOBs.
• D.Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.
• E.If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.

Which two statements are true with respect to fine-grained access control?

• A.It can be used to implement column masking.
• B.The DBMS_FGA package is used to set up fine-grained access control.
• C.It is implemented by end users.
• D.It implements security rules through functions and associates these security rules with tables, views or synonyms.
• E.Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

• A.When the database administrator disables the result cache during ongoing application patching
• B.When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
• C.When the maximum amount of server result cache memory that can be used for a single result is set to 0.
• D.When the function is executed in a session frequently with the same parameter value
• E.When the amount of memory allocated for the result cache is increased

In which situation will cached results become invalid?

• A.When a new session is opened to invoke the function which is already cached
• B.When a session executes an insert, update, or delete statement on a table or view that is queried by the result-cached function
• C.When the memory allocated to the server result cache is increased using the RESULT_CACHE_MAX_SIZE initialization parameter
• D.When a session on this database instance invokes the function with the same parameter values
• E.When the RESULT_CACHE_MODE parameter is set to FORCE.

Examine this statement:

Which result is expected after executing this anonymous block?

• A.60
• B.PLS-00382: expression is of wrong type
• C.PLS-00316: PL/SQL TABLEs must use a single index
• D.30
• E.ORA-06533: Subscript beyond count