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

if you ctreate table identity

2430

why can't we assign not null constraint as table level constraint

CTS, Wipro,

3 14372

How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.

1 6944

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

IBM,

1988

what is Oracle10g? Please refer some sites...

1 4419

What is the maximum size of a row in oracle 9i?

Baidu, HCL, Yashu Systems,

4 10582

What is the maximum size of a oracle9i database?

Baidu, HCL, TCS,

1 6899

How can you find the size of a database?

Baidu, HCL,

5 11944

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

Microsoft, Wipro,

4 12032

How can we find the size of a database?

2 6180

in fun why return single value?

UST,

1 4288

what is different between inline query,subquery& corelated query?

Quest,

8 107037

what is kernel?

Microsoft,

2 6906

what is shell?

Microsoft,

2 6096

what is the difference between dbms and rdbms?

Oracle,

3 7505

Un-Answered Questions { Oracle }

How can we delete duplicate rows in a table?

1041

what is the dual table in oracle?

1045

What are the different responsibilities of a dba?

780

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

1164

What are data pump export and import modes?

1117

How do I learn what codesets are available in oracle?

1081

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

1995

Explain the use of tables option in exp command.

1172

Explain self joins in oracle?

1063

What privilege is needed for a user to create tables in oracle?

1000

How would you change old and new values in an insert, delete and update triggers?

1082

How to use group functions in the select clause using oracle?

1136

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2390

How can you determine if an index needs to be dropped and rebuilt?

605

What are bind variables and why are they important?

594

For More Un-Answered { Oracle } Questions Click Here