A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.What happens to the PL/SQL procedure after the online table redefinition?
Which two statements are true regarding hot patching? (Choose two.)
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set theSEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;What is the significance of this setting?
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
Why should you back up a duplicated tablespace after a TSPITR is complete?
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
