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

Oracle General (1803)
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,

2239

what is normalisation?what are its uses?

2338

How many memory layers are in the shared pool?

1 5102

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

2178

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?

2877

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

2322

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

2179

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?

2044

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

2163

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

2112

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

2067

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

2401

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

2968

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?

2151

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.

1998

Un-Answered Questions { Oracle }

If you are working Microsoft excel, which type of file you used .excel or .csv?

685

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

Explain the wait events in statspack report 'enqueue'?

622

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2337

What are a collation and state the different types of collation sensitivity?

1252

What is a nested table and how is it different from a normal table?

1115

How to lock and unlock a user account in oracle?

1166

what are bitmap indexes? How does they work?

2311

How to use subqueries with the in operator using oracle?

1143

Explain the use of compress option in exp command.

1073

Where is the multi connections are used in ORACLE DATA INTEGATOR?

674

How to get a list of all user accounts in the database?

1134

What is path setting for dll?

How to turn on or off recycle bin for the instance?

1133

key flexfield structure

2235

For More Un-Answered { Oracle } Questions Click Here