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

Oracle General Interview Questions

Questions Answers Views Company eMail

How to synchronize 2 schema's objects?

Virtusa,

2173

why dont we assign not null constraint as table level constraint.

2735

how many types of index?

Cap Gemini, TCS,

2 7271

if you update view? where we store the data?

Cap Gemini,

5 11134

if you ctreate table identity

2368

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

CTS, Wipro,

3 14210

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

IBM,

1930

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

Microsoft, Wipro,

4 11850

How can we find the size of a database?

2 6073

what is kernel?

Microsoft,

2 6800

what is shell?

Microsoft,

2 5954

what is the difference between dbms and rdbms?

Oracle,

3 7381

what is the difference between sql& oracle?

Oracle,

11 17846

what is trigger?

Oracle,

6 10698

what is the difference between first normal form & second normal form?

IBM, Oracle,

11 35466

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the difference between online and offline backups?

1052

How to list all tables in your schema?

1053

Does facebook use oracle?

1029

Explain user account with reference to oracle.

977

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4166

Explain the use of constraints option in exp command.

1044

What are the components of logical database structure in oracle database?

1086

What are the limitations of check constraint?

1024

Is rowid unique in oracle?

998

What happens to the current transaction if the session is ended?

1096

What is a read only transaction in oracle?

1027

What is meant by recursive hints in oracle?

1084

How to use "in" parameter properly?

1063

How oracle handles dead locks?

1064

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1843

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