You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement:FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;What will be the result of executing this statement?
Evaluate the following function code:Which statement is true regarding the above function?
Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?
What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?
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?
