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

if you ctreate table identity

2368

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

CTS, Wipro,

3 14203

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

1 6856

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

IBM,

1928

what is Oracle10g? Please refer some sites...

1 4345

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

Baidu, HCL, Yashu Systems,

4 10433

What is the maximum size of a oracle9i database?

Baidu, HCL, TCS,

1 6807

How can you find the size of a database?

Baidu, HCL,

5 11694

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

Microsoft, Wipro,

4 11844

How can we find the size of a database?

2 6065

in fun why return single value?

UST,

1 4201

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

Quest,

8 106699

what is kernel?

Microsoft,

2 6798

what is shell?

Microsoft,

2 5953

what is the difference between dbms and rdbms?

Oracle,

3 7381

Un-Answered Questions { Oracle }

how to dynamically change the page size of d2k reports?

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

570

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2065

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1769

Can we store pictures in the database and if so, how it can be done?

1029

Which files are vital that should be backed up?

599

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

1907

How can we find out the current date and time in oracle?

1086

How to get a list of all user accounts in the database?

1085

What is a package in oracle?

1096

You have taken a manual backup of a datafile using os. How rman will know about it?

549

How to connect the oracle server as sysdba?

1074

What is the usage of merge statement?

1142

What are the goals of dba?

550

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4566

For More Un-Answered { Oracle } Questions Click Here