Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 41:

  Examine this table definition in the SH schema.

  

  A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: CD

• Question 42:

  Which three statements are true about passing parameters to subprograms? (Choose three.)

  A. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

  B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

  C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

  D. The actual parameter must be a variable when calling a subprogram with an OUT parameter.

  E. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

  F. OUT parameters returning values to calling subprograms act like constants in the called subprogram.

  G. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

  Correct Answer: BCD

• Question 43:

  Examine this code:

  

  What will be the outcome?

  A. It will execute successfully and will display the user-defined error message.

  B. It will result in an error as the range of the error code can only be from "-20000 to - 20999."

  C. It will result in an error as the range of the error code can only be from "-1000 to -2000."

  D. It will result in an error as the range of the error code can only be from "-2000 to -2999."

  Correct Answer: B

• Question 44:

  Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

  A. The actual parameters must be specified in the same order as the formal parameters are declared.

  B. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.

  C. Only trailing optional parameters can be omitted in the invocation call.

  D. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

  E. Any optional parameters can be omitted in the invocation call.

  Correct Answer: AE

• Question 45:

  Which two are true about collections and RECORD types? (Choose two.)

  A. A variable of RECORD type can contain fields of another RECORD type or any collection type.

  B. Only associative arrays and nested tables can have elements of RECORD type.

  C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

  D. Collections and RECORD types are always dense.

  E. All collections and RECORD types can be stored in table columns.

  F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

  Correct Answer: BF

• Question 46:

  Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

  A. Function based indexes remain usable when replacing the function on which the index depends.

  B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.

  C. This clause can be used only for procedures and functions.

  D. A function definition can be modified without dropping and re-creating it.

  E. Object privileges to execute a replaced function are retained by those users who had the privileges.

  Correct Answer: DE

• Question 47:

  Examine the structure of the ora1.depts table:

  

  Now, examine these statements issued by user ora1 which execute successfully:

  Create or replace view dep_vu as select * from depts;

  Alter table depts add dep_email varchar2(20);

  Finally, examine this block of code executed by user ora1:

  

  Which is true?

  A. DEP_VU must be manually recompiled to successfully run this code.

  B. It will run successfully producing a result of 4.

  C. It will result in an error because table depts has been altered.

  D. It will run successfully producing a result of 5.

  Correct Answer: B

• Question 48:

  Examine these statements issued by user SH which execute successfully:

  

  DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; / Now, examine this anonymous block executed by SH:

  

  Which is true about the anonymous block?

  A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

  B. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

  C. It will fail at lines 6 and 7.

  D. It will fail only at line 7.

  Correct Answer: D

• Question 49:

  Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

  A. PACKAGES

  B. VARIABLES

  C. ANONYMOUS BLOCK

  D. TRIGGER BODY

  E. DATABASE LINKS

  Correct Answer: AE

• Question 50:

  Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

  A. It can be used in the declaration of object types.

  B. It must be specified in the heading of a package specification.

  C. The check is enforced by this clause for direct access and access through dynamic SQL.

  D. It can be used for individual procedures and functions declared in a package specification.

  E. It must be specified in the heading of a package body.

  Correct Answer: AD

  https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm