Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 111:

  Which two statements are true about the DBMS_ LOB package?

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

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lob.htm#BABDDFDH

• Question 112:

  Which two statements are true about associative arrays and varrays? (Choose two.)

  A. Only varrays must start with the subscript 1.
  B. Only varrays can be used as column types in database tables.
  C. Both associative arrays and varrays must start with the subscript 1.
  D. Both associative arrays and varrays can be used as column types in database tables.
  A. Only varrays must start with the subscript 1.
  B. Only varrays can be used as column types in database tables.

• Question 113:

  Which two queries' results cannot be cached? (Choose two.)

  A. queries having the GROUP BY clause
  B. queries having the ORDER BY clause
  C. the query on dictionary and temporary tables
  D. queries having SYSDATE and SYS_TIMESTAMP SQL functions
  C. the query on dictionary and temporary tables
  D. queries having SYSDATE and SYS_TIMESTAMP SQL functions

• Question 114:

  When do you use static SQL as a technique for avoiding SQL injection?

  A. when the WHERE clause values are unknown
  B. when the code contains data definition language (DDL) statements
  C. when all Oracle identifiers are known at the time of code compilation
  D. when the SET clause values are unknown at the time of code compilation
  C. when all Oracle identifiers are known at the time of code compilation

• Question 115:

  Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?

  A. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
  B. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
  C. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
  D. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.
  D. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.

  ---

  Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm

• Question 116:

  Examine the structure of the TEXT_TAB table. Name Null? Type

  TEXT_ID NUMBER

  DOC1 CLOB

  DOC2 CLOB

  You issue the following INSERT commands:

  INSERT INTO text_tab VALUES (1, 'This is line 1',null);

  INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2');

  Then you execute the following block of the PL/SQL code:

  DECLARE

  vc1 VARCHAR2(1000):= 'This is the preface';

  lb1 CLOB;

  lb2 CLOB;

  BEGIN

  SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1;

  SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2;

  lb2 := vc1|| lb1;

  UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1;

  END;

  /

  What is the outcome?

  A. It executes successfully.
  B. It gives an error because VARCHAR2 should be explicitly converted to CLOB.
  C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB().
  D. It gives an error because the concatenation operator cannot be used with the CLOB data type.
  A. It executes successfully.

• Question 117:

  Examine these two columns:

  

  Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

  A. 1-c, 2-b, 3-e, 4-a, 5-d
  B. 1-b, 2-d, 3-c, 4-e, 5-a
  C. 1-c, 2-a, 3-b, 4-e, 5-d
  D. 1-c, 2-d, 3-b, 4-e, 5-a
  E. 1-e, 2-a, 3-c, 4-b, 5-d
  D. 1-c, 2-d, 3-b, 4-e, 5-a

  ---

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_PARALLEL_EXECUTE.html#GUID-A31C2E84-91CC-4D35-AAFE-4E7E6609C963

• Question 118:

  Which two statements are true about REF CURSOR types? (Choose two.)

  A. REF CURSOR types cannot be defined inside a package.
  B. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions.
  C. A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a user- defined record.
  D. Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.
  B. SYS_REFCURSOR can be used to declare cursor variables in stored procedures and functions.
  C. A REF CURSOR return type can be declared using %TYPE, or %ROWTYPE, or a user- defined record.

• Question 119:

  Examine the following settings for a session:

  PLSQL_CODE_TYPE = NATIVE

  View the Exhibit and examine the PL/SQL code.

  You compile the program with the following attributes:

  SQL> ALTER PROCEDURE proc1 COMPILE PLSQL_OPTIMIZE_LEVEL = 1;

  Which statement is true about the execution of the PROC1 procedure in this scenario?

  

  A. The FUNC1 function would be called inline because PRAGMA INLINE forces a specific call to be inlined.
  B. The FUNC1 function would be inlined because the value set for the PLSQL_CODE_TYPE parameter is set to NATIVE.
  C. The FUNC1 function would be called inline irrespective of the value set for the PLSQL_OPTIMIZE_LEVEL parameter.
  D. The FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL parameter is set to a lower value.
  D. The FUNC1 function would not be called inline because the value for the PLSQL_OPTIMIZE_LEVEL parameter is set to a lower value.

• Question 120:

  Examine this code:

  

  Users of this function may set different date formats in their sessions.

  Which two modifications must be made to allow the use of your session's date format when outputting the cached result of this function?

  A. Change the RETURN type to DATE.
  B. Change AUTHID to CURRENT_USER.
  C. Use the TO_CHAR function around SYSDATE, that is, 1_date := TO_CHAR (SYSDATE).
  D. Change the data type of 1_date to DATE.
  E. Set NLS_DATE_FORMAT to `DD-MM-YY' at the instance level.
  F. Set the RESULT_CACHE_MODE parameter to FORCE.
  A. Change the RETURN type to DATE.
  B. Change AUTHID to CURRENT_USER.