Oracle Oracle Certifications 1Z0-148 Questions & Answers

• Question 141:

  Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.)

  A. Use bind arguments.

  B. Validate all input concatenated to dynamic SQL.

  C. Use dynamic SQLs constructed using concatenation of input values.

  D. Use subprograms as part of packages instead of stand-alone subprograms.

  Correct Answer: AB

• Question 142:

  Examine the following settings for a session:

  PLSQL_CODE_TYPE = NATIVE

  PLSQL_OPTIMIZE_LEVEL = 3

  Which statement would be true in this scenario?

  A. The compiler would automatically inline subprograms.

  B. The compiler would inline the code for external subroutines.

  C. The compiler would inline the code even if the INLINE pragma is set to NO.

  D. The compiler would not inline the code unless the INLINE pragma is set to YES.

  Correct Answer: A

• Question 143:

  Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)

  A. OPEN can be used to open only internal LOBs in the indicated mode.

  B. FILEOPEN can be used to open only external LOBs in the indicated mode.

  C. OPEN can be used to open internal and external LOBs in the indicated mode.

  D. FILEOPEN can be used to open internal and external LOBs in the indicated mode.

  Correct Answer: BC

• Question 144:

  Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type

  NAME VARCHAR2(30)

  SIGNATURE VARCHAR2(32)

  TYPE VARCHAR2(18)

  OBJECT_NAME NOT NULL VARCHAR2(30)

  OBJECT_TYPE VARCHAR2(13)

  USAGE VARCHAR2(11) USAGE_ID NUMBER LINE NUMBER COL NUMBER USAGE_CONTEXT_ID NUMBER Identify two scenarios in which information is stored in the USAGE column. (Choose two.)

  A. an assignment made to VARIABLE

  B. declaration of a variable or formal parameter

  C. an identifier passed to a subprogram in IN OUT mode

  D. execution of the GOTO statement or raise of an exception

  Correct Answer: AB

• Question 145:

  The database instance was started up using the automatic memory management feature. No value was

  set for the RESULT_CACHE_MAX_SIZE parameter.

  Examine the following initialization parameter settings for your database:

  MEMORY_TARGET = 500M

  RESULT_CACHE_MODE = MANUAL

  You execute a query by using the result_cache hint. Which statement is true in this scenario?

  A. The query results are not stored because no memory is allocated for the result cache.

  B. The query results are stored and 0.5% of the memory target is allocated to the result cache.

  C. The query results are stored and 0.25% of the memory target is allocated to the result cache.

  D. The query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.

  Correct Answer: C

• Question 146:

  Identify three guidelines for the DBMS_ASSERT package. (Choose three.)

  A. Prefix all calls to DBMS_ASSERT with the SYS schema name.

  B. Embed DBMS_ASSERT verification routines inside the injectable string.

  C. Escape single quotes when you use the ENQUOTE_LITERAL procedure.

  D. Define and raise exceptions explicitly to handle DBMS_ASSERT exceptions.

  E. Prefix all calls to DBMS_ASSERT with a schema name that owns the subprogram that uses the DBMS_ASSERT package.

  Correct Answer: ACD

• Question 147:

  Which two statements are true about the extproc process? (Choose two.)

  A. It loads the dynamic library.

  B. It is started by the server process.

  C. It converts the C output back to PL/SQL.

  D. A single extproc process serves all user sessions.

  Correct Answer: AC

• Question 148:

  The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session. Examine the section of code given:

  FUNCTION p2 (p boolean) return PLS_INTEGER IS ...

  FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS

  ... ...

  PRAGMA INLINE(p2, 'YES');

  x := p2(true) + p2(3);

  ...

  Which statement is true about the INLINE pragma procedure calls?

  A. Only the call to the P2 function with BOOLEAN as the argument is inlined.

  B. INLINE pragma affects both the functions named P2 and is called inline.

  C. Only the call to the P2 function with PLS_INTEGER as the argument is inlined.

  D. None of the functions are inlined because inlining is not supported for overloaded functions.

  Correct Answer: B

• Question 149:

  Match the following external C procedure components with their descriptions:

  1.

  External procedure a. a process that starts the extproc process

  2.

  Shared library b. a session-specific process that executes the external procedure

  3.

  Alias library c. schema object that represents the operating system (OS) shared library

  4.

  The extproc process d. operating system file that stores the external procedure

  5.

  Listener process e. a unit of code written in C

  A. 1-e; 2-d; 3-c; 4-b; 5-a

  B. 1-c; 2-d; 3-e; 4-b; 5-a

  C. 1-e; 2-c; 3-d; 4-b; 5-a

  D. 1-a; 2-d; 3-e; 4-c; 5-b

  Correct Answer: A

• Question 150:

  Which two statements are true about the context of an application? (Choose two.)

  A. It is attached to a session.

  B. It is owned by the user SYS.

  C. A user can change the context of his or her application.

  D. The PL/SQL package associated with the context must exist before the context is created.

  E. The predefined attributes in the USERENV application context can be changed as per the requirements.

  Correct Answer: AB