Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

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?

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

990

For More Un-Answered { Oracle } Questions Click Here