Oracle Oracle Certifications 1Z0-149 Questions & Answers

• Question 51:

  Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

  A. a record declared in an anonymous block

  B. a record declared in a procedure

  C. an associative array indexed by PLS_INTEGER

  D. a record declared in a package specification

  E. a predefined PL/SQL-only data type like BOOLEAN

  F. an associative array indexed by VARCHAR2

  Correct Answer: CDF

• Question 52:

  Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

  A. PL/SQL code can be compiled and executed based on different versions of the operating system.

  B. PL/SQL code can be compiled and executed based on different versions of Oracle.

  C. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

  D. Conditional compilation is disabled by default.

  E. The PL/SQL compiler can conditionally include selected parts of a program.

  Correct Answer: BE

• Question 53:

  Examine this table in the SH schema:

  

  User SH executes this code:

  

  The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000. With which option must "---placeholder" be replaced?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  E. Option E

  Correct Answer: A

• Question 54:

  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.

  Correct Answer: D

• Question 55:

  Examine the SH.PRODUCTS table:

  

  A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH:

  

  Now, examine this block of code:

  

  Which error message(s) does it display on execution by user SH?

  A. Error in inner block

  B. Error in inner block Error in outer block

  C. Error in inner block Error in calling block

  D. Error in inner block Error in outer block Error in calling block

  Correct Answer: A

• Question 56:

  Examine this DECLARE section:

  

  Which line will cause an error upon execution?

  A. line 5

  B. line 3

  C. line 2

  D. line 4

  E. line 6

  Correct Answer: E

• Question 57:

  Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

  A. When using the RETURNING INTO clause, the data returned can be only single column or expression.

  B. The RETURNING INTO clause and bulk binds may not be used together.

  C. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

  D. The RETURNING INTO clause returns column values for rows affected by DML statements.

  E. The RETURNING clause can be used for remote or parallel deletes.

  Correct Answer: CE

• Question 58:

  Examine this DECLARE section:

  

  Which two lines are valid? (Choose two.)

  A. line 5

  B. line 6

  C. line 7

  D. line 4 E. line 3

  F. line 2

  Correct Answer: AF

• Question 59:

  Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

  A. CREATE

  B. DROP

  C. UPDATE

  D. SELECT

  E. DELETE

  F. ALTER

  G. INSERT

  Correct Answer: CDG

• Question 60:

  Which two are true about exception handling? (Choose two.)

  A. Internally defined exceptions can be handled only by the OTHERS exception handler.

  B. All declared exceptions are raised implicitly by the runtime system.

  C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

  D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

  E. Predefined exceptions are globally declared in the standard package.

  Correct Answer: CE