View Mode
Q: 1
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
Options
Q: 2
Examine this DECLARE section: 1Z0-149 question Which two lines are valid? (Choose two.)
Options
Q: 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: 1Z0-149 question 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?
Options
Q: 4
Which is the correct method to implement a local subprogram in an anonymous block?
Options
Q: 5
Examine these statements: 1Z0-149 question Which is true?
Options
Q: 6
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.)
Options
Q: 7
Examine the SH.PRODUCTS table: 1Z0-149 question A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH: 1Z0-149 question Now, examine this block of code: 1Z0-149 question Which error message(s) does it display on execution by user SH?
Options
Q: 8
Examine this row of data from the EMPLOYEES table: 1Z0-149 question Now, examine this block of code which executes successfully: 1Z0-149 question What is the value of v_commission?
Options
Q: 9

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

Options
Q: 10
Which is true about EXIT and CONTINUE statements?
Options
Question 1 of 20 · Page 1 / 2

Premium Access Includes

  • Quiz Simulator
  • Exam Mode
  • Progress Tracking
  • Question Saving
  • Flash Cards
  • Drag & Drops
  • 3 Months Access
  • PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE