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

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

1996

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4573

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 3636

How would you best determine why your MVIEW couldnt FAST REFRESH?

1935

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2311

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1939

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

2129

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

1962

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

2107

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

1 4526

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

1 2677

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

Infosys,

2343

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

2213

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.

2062

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

2376

Un-Answered Questions { Oracle }

What is an Oracle Rollback Segment?

1169

What are dml statements in oracle?

1135

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2564

How to bring a tablespace online?

1149

How view is different from a table?

1093

Explain what are the characteristics of data files?

1143

What are record groups ? Explain the types of record group.

Does oracle partitioning improve performance?

1053

What is the meaning of database backup?

680

Why do we use bulk collect in oracle?

1112

How to list all indexes in your schema?

1148

How to get / select the nth row from the table?

What is blob data type in oracle?

1211

What is bulk copy or bcp in oracle?

1188

What are nested tables?

1228

For More Un-Answered { Oracle } Questions Click Here