Oracle General Interview Questions
Questions Answers Views Company eMail

How to synchronize 2 schema's objects?

Virtusa,

1674

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

2239

how many types of index?

Cap Gemini, TCS,

2 6157

if you update view? where we store the data?

Cap Gemini,

5 9337

if you ctreate table identity

1831

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

CTS, Wipro,

3 12616

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

IBM,

1459

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

Microsoft, Wipro,

4 10217

How can we find the size of a database?

2 5109

what is kernel?

Microsoft,

2 5665

what is shell?

Microsoft,

2 4932

what is the difference between dbms and rdbms?

Oracle,

3 6165

what is the difference between sql& oracle?

Oracle,

11 14261

what is trigger?

Oracle,

6 8316

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

IBM, Oracle,

11 31551


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the different oracle database objects?

573


What is Segment Advisor in Oracle?

653


What are the set operators union, union all, minus & intersect meant to do?

547


How to write numeric literals in oracle?

595


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2161






How to define a specific record type?

601


Explain what are synonyms used for?

588


How to manage transaction isolation level?

545


What is index in Oracle?

577


Does oracle database need java?

508


How to create a table index in oracle?

643


What are the uses of Database Trigger ?

1086


How to upsert (update or insert into a table)?

525


Explain the use of indexes option in imp command.

555


Explain alias?

690