Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 31:

  Which is true about counter variables in a FOR loop?

  A. It must explicitly be declared.

  B. It can be modified in the body of the loop.

  C. It cannot be NULL.

  D. It is accessible outside the body of the loop.

  Correct Answer: C

• Question 32:

  Which two are true about packages? (Choose two.)

  A. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

  B. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

  C. Package specifications can be compiled without their bodies.

  D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

  E. A package definition must have a specification and body.

  Correct Answer: AC

• Question 33:

  User ORA41 executes these statements successfully:

  Now, examine this statement which is executed successfully by user ORA61 after a successful login:

  EXECUTE ora41.update_emp_proc(100,25000);

  Which two are true? (Choose two.)

  A. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

  B. No update happens even though the procedure executes successfully.

  C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

  D. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

  E. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

  Correct Answer: CD

• Question 34:

  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.

  Correct Answer: CD

• Question 35:

  Sequence S and table PRODUCTS exist in your schema.

  Examine the table description:

  

  Now, examine this block of code:

  

  Which two lines each result in a compilation error? (Choose two.)

  A. line 1

  B. line 6

  C. line 8

  D. line 2

  E. line 3

  F. line 7

  Correct Answer: AB

• Question 36:

  Which three are true about anonymous blocks and subprograms? (Choose three.)

  A. Named subprograms cannot be called from other packages.

  B. PROCEDURE subprograms can accept parameters.

  C. A FUNCTION subprogram must return one or more values.

  D. Anonymous blocks cannot use packaged variables.

  E. Named subprograms are stored in the database server.

  F. Anonymous blocks must always start with the Declare keyword.

  G. FUNCTION subprograms must be called and passed through one or more parameters.

  Correct Answer: BCE

• Question 37:

  Examine these statements which execute successfully:

  

  Which anonymous block executes successfully?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 38:

  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.

  Correct Answer: DE

• Question 39:

  Which three are true about DDL triggers? (Choose three.)

  A. They cannot include the WHEN clause.

  B. They must be created in an enabled state.

  C. They can be fired when a table is truncated.

  D. They fire only when a DDL statement is executed by the owner of the trigger.

  E. They can be fired either before or after a DDL statement executes.

  F. They can be fired when a privilege is granted to a user.

  G. They must be created in a disabled state.

  Correct Answer: CDE

• Question 40:

  Which is true about the PLSCOPE_SETTINGS parameter?

  A. It is deprecated in Oracle 12c.

  B. It can be used to obtain information about all identifiers when compiling a procedure.

  C. It can be used to control execution of specific portions of the PL/SQL code conditionally.

  D. It can be used to control a user's privileges on PL/SQL objects at run time.

  Correct Answer: B