1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

What is an Integrity Constrains ?

 3 5995

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

 2 6317

Describe the different type of Integrity Constraints supported by ORACLE ?

 2 7252

What is difference between UNIQUE constraint and PRIMARY KEY constraint ?

 3 5968

Describe Referential Integrity ?

 1 4481

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

 1 4886

What is self-referential integrity constraint ?

SunGard,

2 13532

What are the Limitations of a CHECK Constraint ?

 5 17447

What is the maximum number of CHECK constraints that can be defined on a column ?

 3 7777

In Oracle 9i what does "i" Stands for?

MBT,

36 51676

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 12079

Can we create more than one constraint to column ?

 6 9226

what is the difference between simple view and complex view?

 13 49668

what is the use of rank function?

 1 4989

How many different types of indexes we have in oracle?

IBM, TCS,

24 185424

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain user account with reference to oracle.

522

What to do if dba lost the system password?

587

How to check the oracle tns settings?

564

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609

How to write a query with a left outer join in oracle?

595




How do you bind variables in oracle?

532

What is hot backup and logical backup?

594

What is a tns file?

493

What is a dynamic performance view in oracle?

592

How to do paging with oracle?

563

what is the scenario where you take the database to NoArchivelog mode?

1820

How to shutdown your 10g xe server?

607

How to import one table back from a dump file?

578

What do database buffers contain?

557

What are dml statements in oracle?

608

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