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,

2232

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

2797

how many types of index?

Cap Gemini, TCS,

2 7383

if you update view? where we store the data?

Cap Gemini,

5 11379

if you ctreate table identity

2428

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

CTS, Wipro,

3 14352

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

IBM,

1982

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

Microsoft, Wipro,

4 12009

How can we find the size of a database?

2 6168

what is kernel?

Microsoft,

2 6898

what is shell?

Microsoft,

2 6084

what is the difference between dbms and rdbms?

Oracle,

3 7497

what is the difference between sql& oracle?

Oracle,

11 18268

what is trigger?

Oracle,

6 10940

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

IBM, Oracle,

11 35831

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

interview questions with answer for cts

2635

How to commit the current transaction in oracle?

1179

What is the relation of a user account and a schema in oracle?

1126

What is bind variable in oracle 11g?

1095

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2518

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1991

Can you create a synonym without having a table?

1090

Write a syntax for update query in oracle?

1073

What is hash cluster in oracle?

1244

What are the predefined tablespaces in a database?

1140

Where are the settings stored for each instance in oracle?

1151

What is an Oracle index?

1698

What are the uses of linked server and explain it in detail?

1117

What are dml statements in oracle?

1130

What privilege is needed for a user to delete rows from tables in another schema?

1133

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