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 4227

difference between oracle8i and oracle9i

NIIT,

4 10293

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

KH, Thermotech,

3 23179

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16765

What is TNS File

Thermotech,

7 32242

What is flashback Query ? And Use ?

Thermotech,

4 9544

What is Trace File ?

Thermotech,

4 26366

What is forall Statement ?

Thermotech,

2 6045

Tell me New Feature of Oracle 10g?

Thermotech,

5 11227

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 7576

What is the diff between Oracle and SQL Server

1 4728

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 16688

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

2232

which statement is running fastly ie insert or delete?

Oracle,

13 19394

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 5621

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why does oracle 9i treat an empty string as null?

1130

What is an oracle recycle bin?

1066

How to put more than 1000 values into an oracle in clause?

1090

How to use select statement to count the number of rows in oracle?

1096

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

1119

What is the difference between hot backup and cold backup in oracle?

1078

How to use fetch statement in a loop?

1070

what are the default admin accounts in Oracle 10g ?

1024

Explain the use of full option in exp command.

1179

Whether any commands are used for months calculation? If so, what are they?

1140

How to count duplicated values in a column in oracle?

1107

What is set verify off in oracle?

1165

Explain oracle left join with an example?

1064

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2340

How to export your connection information to a file?

1180

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