Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 1:

  You create this package and procedure:

  

  Which two blocks will execute without errors? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  B. Option B
  E. Option E

• Question 2:

  Which two statements are true about inlining PL/SQL subprograms? (Choose two.)

  A. PLSQL_OPTIMIZE_LEVEL must be set to 3 to inline external subroutines.
  B. Programs making use of large helper subroutines are good candidates for inlining.
  C. PRAGMA INLINE must be specified.
  D. Only local subroutines can be inlined.
  E. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.
  B. Programs making use of large helper subroutines are good candidates for inlining.
  E. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.

• Question 3:

  Which three statements are correct when using collections? (Choose three.)

  A. Associative arrays may be used when you need to process information of unknown volume.
  B. Nested tables should be used when the index values are non-sequential.
  C. Use associative arrays when you need numeric and string indices.
  D. Varrays should be used when you need to pass the collection as a parameter.
  E. Do not use nested tables when you need to delete elements.
  F. Nested tables may be used when there is no predefined upper bound for index values.
  D. Varrays should be used when you need to pass the collection as a parameter.
  E. Do not use nested tables when you need to delete elements.
  F. Nested tables may be used when there is no predefined upper bound for index values.

  ---

  explanation:

  Reference: https://docs.oracle.com/cd/B14117_01/appdev.101/b10807/05_colls.htm

• Question 4:

  For which type of PL/SQL program units is PL/Scope unable to collect data?

  A. triggers
  B. package STANDARD
  C. package DBMS_STANDARD
  D. wrapped PL/SQL program units
  E. user-created PL/SQL program units
  D. wrapped PL/SQL program units

  ---

  explanation:

  Reference: https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm#g1010526 (see note)

• Question 5:

  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

  ---

  explanation:

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

• Question 6:

  Examine this function that is using the RESULT_CACHE clause:

  

  After executing the function twice, passing 100 and 150 as input parameters, the LOCATIONS table is updated for LOCATION_ID = 100. Which statement is correct if the function is called again, passing 150 as the input parameter?

  A. The function is executed again because the database checks for changes to the LOCATIONS table each time the function is called.
  B. The results are retrieved from the results cache because the LOCATIONS table was not updated for LOCATION_ID = 150.
  C. The results are retrieved from the results cache because not enough rows of the LOCATIONS table were modified to cause invalidation.
  D. The function is executed again because the result cache was invalidated when the LOCATIONS table was updated.
  B. The results are retrieved from the results cache because the LOCATIONS table was not updated for LOCATION_ID = 150.

• Question 7:

  Examine this code:

  

  Execute this PL/SQL block:

  

  Which is the correct category of SQL injection attack?

  A. First Order Attack
  B. Second Order Attack
  C. Incorrect type handling
  D. Lateral Injection
  B. Second Order Attack

• Question 8:

  You are connected as SCOTT who has an EMP table with this structure:

  

  Examine this code:

  

  Assuming the default edition is ORA$BASE, which is correct?

  A. The query will return records pertaining to department 30 with SAL and COMM values displayed as NULL.
  B. The query will return records pertaining to department 20.
  C. The query will return records pertaining to department 20 with SAL and COMM values displayed as NULL.
  D. The query will return records pertaining to department 30.
  A. The query will return records pertaining to department 30 with SAL and COMM values displayed as NULL.

• Question 9:

  Which data dictionary view includes information about the parameters of procedures and functions that you can call?

  A. ALL_PROCEDURES
  B. ALL_PACKAGES
  C. ALL_ARGUMENTS
  D. ALL_OBJECTS
  D. ALL_OBJECTS

  ---

  explanation:

  Reference: https://blogs.oracle.com/oraclemagazine/the-data-dictionary-make-views-work-for-you

• Question 10:

  With SERVEROUTPUT enabled, you successfully create the package YEARLY_LIST:

  

  Examine this code:

  

  You want to display the contents of CREATE_LIST.

  Which two lines need to be corrected in the PL/SQL block? (Choose two.)

  A. Line 6
  B. Line 5
  C. Line 7
  D. Line 2
  E. Line 3
  C. Line 7
  E. Line 3