Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 1:

  Which three are true about PL/SQL subprograms? (Choose three.)

  A. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
  B. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
  C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
  D. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
  E. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated.
  F. Host variables can be referenced inside any PL/SQL subprogram.
  G. A PL/SQL procedure can invoke an external code block written in a different programming language.
  C. Subprograms are cached by default and shared among users, thereby reducing memory requirements.
  D. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
  G. A PL/SQL procedure can invoke an external code block written in a different programming language.

• Question 2:

  In which type of trigger can :OLD and :NEW identifiers be used?

  A. ROW
  B. AFTER SUSPEND
  C. AFTER STATEMENT
  D. BEFORE STATEMENT
  A. ROW

• Question 3:

  Examine these facts:

  Table EMP exists in schema USERA with columns SALARY and EMP_ID.

  EMP_ID is the primary key with values ranging from 1 to 100.

  USERA now executes these statements successfully:

  

  USERA then grants execute privilege on procedure MYPROC to USERB.

  USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.

  USERB now executes these statements:

  conn userB/userB@pdb1

  execute userA.myproc;

  Which is true?

  A. It results in an error because Authid Current_User is missing from MYPROC.
  B. It results in an error because Authid Definer is missing from MYPROC.
  C. It results in an error because USERB doesn't have select privilege on USERA.EMP.
  D. It executes successfully.
  D. It executes successfully.

• Question 4:

  Which two blocks of code display a numerical zero? (Choose two.)

  

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

  ---

  Explanation/Reference:

• Question 5:

  Examine these statements:

  

  Which two are true? (Choose two.)

  A. Neither table will have a row inserted and committed.
  B. Both tables will have a row inserted and committed.
  C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
  D. The bank_activity_proc will not compile because of the commit.
  E. Only one table will have a row inserted and committed.
  C. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
  E. Only one table will have a row inserted and committed.

• Question 6:

  Which two are true about implicit data type conversion? (Choose two.)

  A. RAW data types are always implicitly converted to a CLOB when used in a query.
  B. Collections can be implicitly converted to records.
  C. ROWIDS are always implicitly converted to a number when used in a query.
  D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
  E. Implicit data type conversion can negatively impact performance.
  D. Comparison between character value and a number value always implicitly converts the character value to the number data type.
  E. Implicit data type conversion can negatively impact performance.

• Question 7:

  Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

  A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
  B. The default value is NATIVE.
  C. If set to NATIVE, programs are stored in platform dependent machine code.
  D. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
  E. If set to NATIVE, programs are stored in a PL/SQL bytecode format.
  C. If set to NATIVE, programs are stored in platform dependent machine code.
  D. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

• Question 8:

  SERVEROUTPUT is enabled.

  Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

  

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

  ---

  Explanation/Reference:

• Question 9:

  Which three are true about the procedure overloading feature? (Choose three.)

  A. Each procedure can be a nested subprogram.
  B. Each procedure's formal parameters can differ in data type or name.
  C. Each procedure must use named notation to specify the corresponding actual parameters.
  D. Each procedure's formal parameters must differ in name.
  E. Each procedure can be a packaged subprogram.
  F. Each procedure must use positional notation to specify the corresponding actual parameters.
  G. Each procedure can be a standalone subprogram.
  B. Each procedure's formal parameters can differ in data type or name.
  E. Each procedure can be a packaged subprogram.
  F. Each procedure must use positional notation to specify the corresponding actual parameters.

• Question 10:

  Examine this code:

  ALTER SESSION SET plsql_warnings='ENABLE:ALL';

  /

  You compile this function:

  

  What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

  A. It fails compilation.
  B. There are no compilation warnings or errors.
  C. A severe compilation warning is generated.
  D. A performance compilation warning is generated.
  E. An information compilation warning is generated.
  D. A performance compilation warning is generated.

  ---

  Explanation/Reference: