User talk:Piyush shobhane

From Oracle FAQ
Jump to: navigation, search

Please prepare systematic answers of these questions and mail me on piyush_shobhane@yahoo.com.

1) What is bulk bind? 2) Difference between lexical & bind variable. 3) What is sql loader? How it works? What are it's modes of operation? 4) What is PGA aggregate target? 5) Difference between union & union all. 6) Difference between constraint and trigger. 7) What is context switching? 8) What is materialized view? Refreshing policies & types of views. 9) What is bulk collect? 10) What is reference cursor? Implicit & explicit cursors and parameterized cursors? 11) Write a Query to find duplicate rows and delete them. 12) Use of connect by prior and it's syntax. 13) Difference between case & decode and scenarios to use it. 14) Difference between Bitmap index and B+ tree index. 15) Difference between external table, normal table and temporary table. 16) Oracle Architecture (Instance) 17) What are VARRAYS and Nested tables? 18) Dynamic sql and use of execute immediate in it. 19) What is Index Organized Table? What are advantages? 20) Concept of Table partitioning & partitioned indexes? 21) Difference between truncate, delete & trim. 22) What is exception and types of exceptions with example? 23) SQL tuning concepts. 24) What is PRAGMA and what are it's types? 25) Concept of UTL_FILE and UTL_MAIL packages in oracle? 26) What are external tables & directory object? 27) Concept of correlated sub queries. 28) What is Autonomous transaction and where it is used? 29) Difference between schema & user in oracle. 30) Which is the useful oracle supplies APIs & how they are used with example. 31) How would you determine the time zone under which a database was operating? 32) What command would you use to encrypt a PL/SQL application? 33) Name three advisory statistics you can collect. 34) When a user process fails, what background process cleans up after it? 35) What background process refreshes materialized views? 36) Give two methods you could use to determine what DDL changes have been made. 37) Differentiate between implicit & explicit cursors. What are cursor attributes? 38) What are locks? How it occurs & what are the types of locks? 39) What are different table spaces available? Name some default tablespaces. 40) What are Analytical Functions and how they are used? 41) What is normalization? What is normal form? 42) What is Explain plan? How to read the output of plan_table? 43) What is TKPROF utility? How it is useful? 44) What is Mutating table/trigger? 45) Concept of Virtual Private Database (VPD) 46) Gathering statistics and analyzing

Please send me 100$ per question and you will have very detailed and definitive answers.
Michel Cadot 16:26, 9 March 2012 (UTC)