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

Oracle General Interview Questions

Questions Answers Views Company eMail

How would you begin to troubleshoot an ORA-3113 error?

2077

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1907

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How would you extract DDL of a table without using a GUI tool?

1 4446

Youre getting high busy buffer waits - how can you find whats causing it?

1 2598

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

Infosys,

2267

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2157

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2001

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2323

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

1930

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.

2121

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

2141

How does Oracle guarantee data integrity of data changes?

2385

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

2116

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

1 3584

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to convert numbers to characters in oracle?

1029

What is the difference between a hot backup and a cold backup in oracle?

1013

How can we find out the current date and time in oracle?

1088

What is oracle sid?

947

Explain the dml?

974

What is a database schema in oracle?

1106

What is columnar storage what is the advantage?

1058

How to rename an existing table?

1123

How to execute a stored program unit?

1072

What is Reduced List of Values?

2160

How to create a table index in oracle?

1132

What happens in oracle commit?

1022

When do we use group by clause in a sql query?

1035

How do I learn what codesets are available in oracle?

1036

How can I see all tables in oracle?

1007

For More Un-Answered { Oracle General } Questions Click Here