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,

2181

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

2738

how many types of index?

Cap Gemini, TCS,

2 7284

if you update view? where we store the data?

Cap Gemini,

5 11148

if you ctreate table identity

2374

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

CTS, Wipro,

3 14220

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

IBM,

1933

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

Microsoft, Wipro,

4 11862

How can we find the size of a database?

2 6079

what is kernel?

Microsoft,

2 6803

what is shell?

Microsoft,

2 5957

what is the difference between dbms and rdbms?

Oracle,

3 7386

what is the difference between sql& oracle?

Oracle,

11 17877

what is trigger?

Oracle,

6 10708

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

IBM, Oracle,

11 35484

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is the maximum number of triggers that can be applied to a single table?

1024

what are the advantages of running a database in archive log mode?

2203

What the is the diff between local index and global index. give some example.

1639

What is an oracle database?

1035

What is the simplest tool to run commands on oracle servers?

1009

Is oracle a language?

946

how to do daily transactions with out sql* loader control file regesterd in apps?

1687

How many types of segments in Oracle?

1070

Explain the blob datatype?

1071

What is a trigger oracle?

1086

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2369

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

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??

1727

20. Using a set operator, display the client number of all clients who have never placed an order.

2187

What is system global area (sga) in oracle?

991

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