Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Oracle Interview Questions
Questions Answers Views Company eMail

What is the difference between alert log file and tarce file ?

TCS,

2166

what is normalisation?what are its uses?

2267

How many memory layers are in the shared pool?

1 5012

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2117

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2825

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2266

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2127

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1986

How do you tell what your machine name is and what is its IP address?

2089

How would you go about verifying the network name that the local_listener is currently using?

2043

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2001

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2351

What is the recommended interval at which to run statspack snapshots, and why?

2914

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2066

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1945


Un-Answered Questions { Oracle }

What is the function of Redo Log in Oracle?

1210


Which database is best to learn?

564


How to drop an existing view in oracle?

941


What is the difference between PFILE and SPFILE in Oracle?

1058


What are roles in oracle?

565


Have you attend the client meetings?

609


What is the use of the drop option in the alter table command?

594


What are ddl statements in oracle?

1073


What is catalog in Oracle?

1354


what is oracle forms?

1102


How to use "in out" parameter properly?

1044


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2521


How would you best determine why your MVIEW couldnt FAST REFRESH?

1889


What is the page protect in reports?

1


Will you be able to store pictures in the database?explain.

990