The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).Which two blocks of code execute successfully when invoked by user SH? (Choose two.)
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?
Examine this code:ALTER SESSION SET plsql_warnings='ENABLE:ALL';/You compile this function:What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?
Which is true about the PLSCOPE_SETTINGS parameter?
Which three statements can process a dynamic multi-row query? (Choose three.)
Which is true about counter variables in a FOR loop?
