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 35708

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

BeBo Technologies, Wipro,

7 73967

What are inner join and outer join?

3 25465

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

Amdocs, CSC, TCS,

29 97055

what are Triggers?

TCS,

7 28432

what are stored procedures?

TCS, Wells Fargo,

7 26873

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

Green Info Solutions, TCS,

7 31483

what are views?

TCS,

8 34971

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

i2, Oracle,

2 30967

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

CA,

1 17708

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

2 6733

For web applications from which version of Oracle is suitable?

1 6152

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

1 5619

What is Statement Auditing ?

2 5531

What are the use of Roles ?

3 6291

Un-Answered Questions { Oracle }

How to check your oracle database 10g xe installation?

986

What are the main components of an oracle rac system?

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2258

Mention how oracle flex asm works?

What are the parameters that we can pass through a stored procedure?

1064

How to delete an existing row from a table in oracle?

1070

How to use "if" statements on multiple conditions?

1174

What is the disk migration? what is the steps involved in oracle disk migration?

1221

Is oracle a programming language?

985

What are the advantages of oracle?

1028

How to pass a parameter to a cursor in oracle?

1178

What is the most common database language that a db administrator needs to know?

575

how to remove the duplicate in odi?

627

Tell me step by step to enable Journalization?

633

Explain the dml?

981

For More Un-Answered { Oracle } Questions Click Here