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

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1928

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2119

Explain how you would restore a database using RMAN to Point in Time?

2141

How does Oracle guarantee data integrity of data changes?

2382

Which environment variables are absolutely critical in order to run the OUI?

2114

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 3583

Why does Oracle not permit the use of PCTUSED with indexes?

2417

What would you use to improve performance on an insert statement that places millions of rows into that table?

1 3706

What would you do with an in-doubt distributed transaction?

1974

What are the commands youd issue to show the explain plan for select

2 5276

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2147

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1913

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 8956

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 4014

Un-Answered Questions { Oracle }

What is a system tablespace?

1067

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1422

2147

Please explain joins in oracle?

1059

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2946

How can I create database in oracle?

1011

how to load the data with one flat file and one rdbms table using joins?

598

What do you understand by the term 'normalization'?

667

How to convert numbers to characters in oracle?

1027

What is an oracle database schema?

1117

What is memory advisor in Oracle?

1073

What is a static data dictionary in oracle?

1108

explain what is odi?why is it different from the other etl tools.

610

What are the uses of a database trigger?

992

How to create a new tablespace in oracle?

979

For More Un-Answered { Oracle } Questions Click Here