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?

2078

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

1911

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 4454

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

1 2600

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

Infosys,

2275

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

2159

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.

2007

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

2325

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

1933

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.

2123

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

2145

How does Oracle guarantee data integrity of data changes?

2388

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

2119

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

1 3592

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I learn what codesets are available in oracle?

1038

How to delete a column in an existing table in oracle?

1071

How to join two tables in a single query using oracle?

997

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

1083

What is Undo Management Advisor in Oracle?

1098

How to export data with a field delimiter?

1039

Write a syntax for update query in oracle?

1034

What is an oracle and why it is used?

1150

How to manage transaction isolation level?

1006

How to select some columns from a table in oracle?

1093

What is the difference between online and offline backups?

1059

what are the advantages of running a database in archive log mode?

2203

What is the difference between substr and instr?

1037

How to delete an existing row from a table in oracle?

1072

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2179

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