Oracle PL/SQL Questions 1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row ch...
1_ORACLE1_ORACLEinterview questions and answers 21. How do I determine thetime zone for the database? Answer: SELECT, DBTIMEZONE,FROM, DUAL; 22. Explain the usefulnessof GLOBAL_NAMES as TRUE Answer: GLOBAL_NAMESindicates the way to connect to the database. If this parameter is set to ...
These were some of the oracle interview questions and their answers to help you pass your interview. These can serve as the foundation for your Oracle interview preparations. We hope this list was helpful. All the best for your interviews. If you are looking for more such articles on intervie...
10:: What is SQL*Loader? SQL*Loader is a product for moving data in external files into tables in an Oracle database. To load data from external files into an Oracle database, two types of input must be provided to SQL*Loader : the data itself and the control file. The control file...
Ultimately, answering interview questions for Oracle can be intimidating, but you can nail them with some preparation. Use all of the tips and information above to your advantage. That way, when you’re tackling the Oracle interview questions, you can be sure to impress. ...
Oracle Apps DBA Interview Questions – III 1. How to determine Oracle Apps 11i Version ? Ans : select RELEASE_NAME from fnd_product_groups; You should see output like RELEASE_NAME---11.5.10.2 2. How to find Database version ? Ans : SQL> select * from v$...
Oracle DBA Job Interview Questions and Answers 1:: When using Oracle export/import what character set concerns might come up? How do you handle them? Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters...
12.What is Bit-map index?Explain with Example.(80 % Asked in PL SQL Interview Questions) Answer: 1.If Table contains the distinct values which are not more than 20 distinct values then user should go for Bit map indexes. 2.User should avoid the indexing on each and every row and do ...
Oracle Interview Questions and Answers 1. What is considered to be the easiest way to create an Oracle database? Using the Oracle Database Configuration Assistant Using the Oracle-supplied database creation procedures Using the SQL CREATE DATABASE ...
How does workflow determines whom to send the PO for approval? Can you create PO number in iProcurement? What functions you do from iProcurement What is the difference between purchasing module and iProcurement module? Oracle Application Payables Interview Questions ...