Free Oracle 1Z0-149 Exam Dumps Questions & Answers

Which three are valid PL/SQL variable names? (Choose three.)

• A.  Number_of_days_between_March_and_April
• B.  printer_name#
• C.  #printer_name
• D.  leap$year
• E.  yesterday's_date
• F.  v_fname
• G.  1to7number

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

• A.  15000
• B.  10000
• C.  2500
• D.  5000

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. 
• B. 
• C. 
• D. 
• E. 

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.  It will run successfully producing a result of 4.
• B.  It will result in an error because table depts has been altered.
• C.  It will run successfully producing a result of 5.
• D.  DEP_VU must be manually recompiled to successfully run this code.

Which is the correct method to implement a local subprogram in an anonymous block?

• A. 
• B. 
• C. 
• D.