View Mode
Q: 1
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
Options
Q: 2
Examine this DECLARE section: Oracle 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: Oracle 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: Oracle 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: Oracle 1Z0-149 question A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH: Oracle 1Z0-149 question Now, examine this block of code: Oracle 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: Oracle 1Z0-149 question Now, examine this block of code which executes successfully: Oracle 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