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,

2117

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

2685

how many types of index?

Cap Gemini, TCS,

2 7160

if you update view? where we store the data?

Cap Gemini,

5 10856

if you ctreate table identity

2316

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

CTS, Wipro,

3 14040

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

IBM,

1874

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

Microsoft, Wipro,

4 11688

How can we find the size of a database?

2 5973

what is kernel?

Microsoft,

2 6678

what is shell?

Microsoft,

2 5861

what is the difference between dbms and rdbms?

Oracle,

3 7236

what is the difference between sql& oracle?

Oracle,

11 17363

what is trigger?

Oracle,

6 10452

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

IBM, Oracle,

11 35044

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle join syntax?

945

Explain what are the type of synonyms?

1059

Will you be able to store pictures in the database?

1065

How can you use check constraints for self referential integrity?

920

Can you tell me how to add new column in existing views?how?How is possible?

1373

How to check the server version in oracle?

1037

What do you understand by a database object?

990

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

What are a query and state the different types of queries and their uses?

945

Explain oracle’s system global area (sga).

1080

Is truncate autocommit in oracle?

1027

How do I learn what codesets are available in oracle?

999

What is MTTR advisor in Oracle?

1036

Describe an oracle table?

993

What is the sid in oracle?

904

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