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 to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 35724

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 73989

What are inner join and outer join?

3 25479

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 97091

what are Triggers?

TCS,

7 28448

what are stored procedures?

TCS, Wells Fargo,

7 26883

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 31498

what are views?

TCS,

8 34984

what is the difference between oracle 81,91,11i

i2, Oracle,

2 30975

How client makes connection with server in client/server architecture?

CA,

1 17713

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 6739

For web applications from which version of Oracle is suitable?

1 6154

What are the main diff. between oracle 7.3 and oracle 8i?

1 5624

What is Statement Auditing ?

2 5540

What are the use of Roles ?

3 6293

Un-Answered Questions { Oracle }

what does the no logging option do? Why would we use it?

552

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

601

how to send file attachment from oracle forms

2551

Explain an index segment?

1120

difference between global n context sensitive segments?

2677

can we use lexical perameter in oracle plsql if yes how

2315

How to change user password in oracle?

1029

What is an Oracle Data Block?

1067

Which profile required to access Models in Designer tool?

707

Are database administrators in demand?

566

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2094

does odi support web services?

563

What do you understand by redo log file mirroring?

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2186

What are the different responsibilities of a dba?

725

For More Un-Answered { Oracle } Questions Click Here