Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 131:

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

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

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/security.htm

• Question 132:

  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. 2, 3 and 4
  B. 1 and 4
  C. 2 and 4
  D. 1 and 3
  E. 2 and 3
  C. 2 and 4

  ---

  Reference: https://docs.oracle.com/cd/E18283_01/appdev.112/e16760/d_result_cache.htm

• Question 133:

  Examine the structure of the TEST_DETAILS table: Name Null? Type

  TEST_ID NUMBER

  DESCRIPTION CLOB

  DESCRIPTION data was entered earlier and saved for TEST_ID 12.

  You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12:

  DECLARE

  clob_loc CLOB;

  buf CHAR(12);

  BEGIN

  SELECT description INTO clob_loc FROM test_details WHERE test_id = 12 ;

  buf := '0123456789';

  DBMS_LOB.WRITEAPPEND(clob_loc,DBMS_LOB.GETLENGTH(buf), buf);

  COMMIT;

  END;

  /

  It generates an error on execution.

  What correction should you do to achieve the required result?

  A. WRITEAPPEND must be replaced with APPEND.
  B. The BUF variable data type must be changed to CLOB.
  C. FOR UPDATE must be added to the SELECT statement.
  D. The GETLENGTH routine must be replaced with the LENGTH built-in function in WRITEAPPEND.
  C. FOR UPDATE must be added to the SELECT statement.

• Question 134:

  Which two types of query results cannot be stored in the query result cache? (Choose two.)

  A. subquery results
  B. results of a query having the SYSDATE function
  C. results of a query having the GROUP BY clause
  D. results of a query having the DATE data type in the WHERE clause
  A. subquery results
  B. results of a query having the SYSDATE function

• Question 135:

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

• Question 136:

  Examine the settings for a user session given below:

  RESULT_CACHE_MODE= FORCE

  What would be the implications of this setting on query execution? (Choose all that apply.)

  A. All query results are stored in the result cache if possible.
  B. Query results that are bigger than the available space in the result cache are not cached.
  C. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
  D. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.
  A. All query results are stored in the result cache if possible.
  B. Query results that are bigger than the available space in the result cache are not cached.

• Question 137:

  Examine the code in the following PL/SQL block:

  DECLARE

  TYPE NumList IS TABLE OF INTEGER;

  List1 NumList := NumList(11,22,33,44);

  BEGIN

  List1.DELETE(2);

  DBMS_OUTPUT.PUT_LINE

  ( 'The last element# in List1 is ' || List1.LAST ||

  ' and total of elements is '||List1.COUNT);

  List1.EXTEND(4,3);

  END;

  /

  Which two statements are true about the above code? (Choose two.)

  A. LAST and COUNT give different values.
  B. LAST and COUNT give the same values.
  C. The four new elements that are added contain the value 33.
  D. The four new elements that are added contain the value 44.
  A. LAST and COUNT give different values.
  C. The four new elements that are added contain the value 33.

• Question 138:

  Which two statements are true about the working of fine-grained access? (Choose two.)

  A. Security policies can be associated only with tables, but not with views.
  B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
  C. User statements are dynamically modified by the Oracle server through a security policy function.
  D. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
  B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
  C. User statements are dynamically modified by the Oracle server through a security policy function.

• Question 139:

  You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.)

  A. when the size for the memory allocated for the result cache is increased
  B. when the function is executed in a session frequently with the same parameter value
  C. when the database administrator has disabled the use of the result cache during application patching
  D. when a data manipulation language (DML) statement is executed in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function
  C. when the database administrator has disabled the use of the result cache during application patching
  D. when a data manipulation language (DML) statement is executed in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function

• Question 140:

  Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)

  A. DDL report for all objects dependent on a table
  B. DDL report for all the objects stored in a tablespace
  C. DDL report for all the invalidated objects in a schema
  D. data definition language (DDL) report for all the tables in a schema
  A. DDL report for all objects dependent on a table
  D. data definition language (DDL) report for all the tables in a schema