Activedumpsnet Logo
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
Which is true about the PLSCOPE_SETTINGS parameter?
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?
Which three are true about PL/SQL subprograms? (Choose three.)
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.)
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?
Which three are true about DDL triggers? (Choose three.)
Which three statements are true about passing parameters to subprograms? (Choose three.)
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?