Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 4136

difference between oracle8i and oracle9i

NIIT,

4 10113

Explain 1st, 2nd, 3rd normalization form of data base

KH, Thermotech,

3 23001

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16562

What is TNS File

Thermotech,

7 31942

What is flashback Query ? And Use ?

Thermotech,

4 9379

What is Trace File ?

Thermotech,

4 26169

What is forall Statement ?

Thermotech,

2 5944

Tell me New Feature of Oracle 10g?

Thermotech,

5 11013

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

Thermotech,

4 7412

What is the diff between Oracle and SQL Server

1 4662

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 16487

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2181

which statement is running fastly ie insert or delete?

Oracle,

13 18893

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

Mind Tree,

2 5477

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1073

Explain the use of record option in exp command.

999

What is BBED in Oracle?

1150

Why do you create or replace procedures rather that drop and recreate.

1003

What are the differences between date and timestamp in oracle?

1044

What is literal?

1000

Where do we use decode and case statements?

1011

Why do we use bulk collect in oracle?

1058

How to delete a user account in oracle?

963

How to use "for" statements in oracle?

1072

How to load a large xml file?

1050

How to calculate date and time differences in oracle?

1038

How to install oracle database 10g xe?

1016

Differentiate between post-database commit and post-form commit?

1032

Explain do view contain data?

1004

For More Un-Answered { Oracle General } Questions Click Here