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 would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1897

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

4519

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

1 3517

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

1889

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

2250

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

1879

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?

2047

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

1 4439

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

1 2595

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.

1997

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

2323

Un-Answered Questions { Oracle }

What are the four Oracle system processes that must always be up and running for the database to be useable?

1012

Differentiate between transaction type and transaction source? : oracle accounts receivable

1115

How to run create database statement again?

1150

What happens to the current transaction if the session is ended?

1094

Can multiple columns be used in group by in oracle?

981

Explain how one can iterate through items and records in a specified block?

1117

what are knowledge modules?

635

What are transaction isolation levels supported by oracle?

1063

What is current record attribute property?

What do you mean by merge in oracle?

993

What is the string concatenation operator in oracle?

1173

What does dba stand for in technology?

542

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2290

What are the important tasks of common oracle dba?

556

What are the skills required for oracle dba?

648

For More Un-Answered { Oracle } Questions Click Here