Oracle Plsql interview questions.
1. What's nocopy
2. What's Context Switching
3. What's Advanced Queuing
4. Explain Merge
5. Explain Materialized view
6. Print the only alpha numeric data contains in a column.
Column contains numeric,alphanumeric,alpha characters data
7. Print a fourth Sunday of given month/sysdate
8. Get the data of given Date column by till date(sysdate) from beginning of date (calculate field)
9. Give an example of a anonymous code using bulk collection move data from one table to another table
10. While loading data from 1st row to 20000 rows if 500 th row gets error how to over come remaining data loading.
11. What's Return statement.
12. Given string contains 'A123A456A987A' count how many times 'A' occured.
13. How do you return multiple rows/records data from function.
14. How many files are there while executing control file data
15. Load data from one table to another table (without using loop)
16. What's pragma autonomous transaction.
17. I have a partitioned one table example
Partition1 contains 0......1000
Partition2 contains 1001 ..... 2000
Partition3 contains 2001 ..... 3000
if i have updated a 600th row/record what happens my partition ?
18. What's Global temporary table.
19. What's Procedure overloading
20. One column containing numeric data. I need to print the data of even records count and odd records count
