Scenarios Interview Questions and Answers

Sponsers

Sponsers

Interview Questions

Java Programming Questions
Programming Questions
Oracle Questions
Testing Questions
Accounting Questions
Applications Questions
Clarify CRM Questions
Concepts Questions
Database Questions
Engineering Questions
General Questions
HelpDesk Questions
Mainframe Questions
Management Questions
Networking Questions
Operating System Questions
Data Warehousing Questions
Oracle Apps Questions
Peoplesoft Questions
SAP R/3 Questions
Siebel Questions
Testing Tools Questions
Web Designing Questions

Oracle Interview Questions» Scenarios

Scenarios Interview Questions

Answer

Between EXISTS and In which one is more performance friendly?	Answer
Which one is faster DELETE/TRUNCATE? Why?	Answer
Sponsers
What is the difference between snapshot & mat. view?	Answer
The round(23.59384,-2) is giving output as 0. Can any one explain ,why it was 0?	Answer
How does Oracle 10g(RAC) works?	Answer
what is materialised view?	Answer
What is Non-Schema Object?	Answer
Dispaly the employee who gets more salary than the average salary in their depart ment?	Answer
Which section of a PL/SQL block would most likely contain a RAISE statement?	Answer
What is Server Process ?	Answer
What is User Process ?	Answer
Name the ORACLE Background Process ?	Answer
When Does DBWR write to the database ?	Answer
When does LGWR write to the database ?	Answer
what is SGA? Where it is located? Why the system performance will be slow after loading th...	Answer
What does LGWR do ?	Answer
What is the function of checkpoint(CKPT)?	Answer
What is Shared SQL Area ?	Answer
why oracle is called kernel packagecomponents of oracle tablesql system variables local an...	Answer
What are the components of SGA ?	Answer
What is Cursor ?	Answer
What do Redo Log Buffers contain ?	Answer
What do Database Buffers contain ?	Answer
What is SGA ?	Answer
What constitute an ORACLE Instance ?	Answer
What is PGA ?	Answer
What is Shared Pool ?	Answer
What are the functions of SMON ?	Answer
What are the different types of PL/SQL program units that can be defined and stored in ORA...	Answer
If the entire disk is corrupted how will you and what are the steps to recover the databas...	Answer
How to do the scheduled task/jobs in Unix platform?	Answer
What are the differences you have seen while installing Oracle on NT and Unix platform ?	Answer
What are the differences between database designing and database modeling ?	Answer
If the large table contains thousands of records and the application is accessing 35% of t...	Answer
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE c...	Answer
All the users are complaining that their application is hanging. How you will resolve this...	Answer
If the SQL * Plus hangs for a long time, what is the reason.	Answer
Shall we create procedures to fetch more than one record.	Answer
How do you increase the performance of %LIKE operator.	Answer
How can you see the source code of the package ?	Answer

Question Page : 1 2

Ask Your Question
Your Name	:
Your Email	:
Your Question	:
Change Image
Enter Security Code Given Above

* Your answer or comment will be approved by web master before posting

Scenarios Interview Questions and Answers

Ask Your Question