Oracle Oracle Database 1Z0-148 Questions & Answers

• Question 1:

  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.

  Correct Answer: DEF

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

• 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.

  Correct Answer: BE

• Question 3:

  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

  Correct Answer: BE

• 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

  Correct Answer: D

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

• Question 5:

  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

  Correct Answer: B

• 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.

  Correct Answer: B

• Question 7:

  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

  Correct Answer: D

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

• Question 8:

  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

  Correct Answer: CE

• 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

  Correct Answer: D

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

• Question 10:

  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.

  Correct Answer: A