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?

2122

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

1950

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

2100

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

1 4513

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

1 2671

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

Infosys,

2332

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

2202

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.

2053

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

2365

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

1975

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.

2179

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

2183

How does Oracle guarantee data integrity of data changes?

2454

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

2170

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

1 3652

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3378

Can we use bind variables in oracle stored procedure?

983

How do you find current date and time in oracle?

1099

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2295

How to load excel data sheet to oracle database

1072

Difference between the “verify” and “feedback” command?

1424

What is a procedure in oracle?

1279

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1989

1) Does oracle have any table which contain all the exceptions and it's code internally?

1801

What are transaction isolation levels supported by oracle?

1112

How to use subqueries with the exists operator in oracle?

1066

How to filter out duplications in the returning rows using oracle?

1064

What is the relation of a user account and a schema?

1173

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1706

is there a tool to trace queries, like profiler for sql server?

1192

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