1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

what is the difference between simple view and complex view?

 13 49759

what is the use of rank function?

 1 5041

How many different types of indexes we have in oracle?

IBM, TCS,

24 185636

what are pseudocolumns?

 4 9236

what is the use of composite key constraint?

 2 7549

what is a cartition product?

 4 10110

what is the use of ondelete cascade?

 3 7263

what is cartesian product?

 2 7374

What is the difference between column level constraints and table level constraints?

IBM, TCS,

14 82905

Can we create index on views?

CTS, Syntel, TCS,

19 120144

Can we create more than one index on particular column?

 1 5628

What is a cluster?

 2 4834

What is the difference between implicit index and explicit index?

TCS,

2 22751

What are virtual columns?

TCS,

2 5654

What is a materialised view?

 5 7127

Un-Answered Questions { Oracle }

How would you differentiate between cluster and grid?

1

Can I create users through internet explorer in oracle 10g?

573

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1473

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

1470

Describe the types of sub query?

555




Can i create more than one Master Repository in ODI?

305

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

16372

What does a senior database administrator do?

294

What is partitioned table in Oracle?

639

What is max rowid in oracle?

559

What is null value in oracle?

638

Does oracle partitioning improve performance?

552

Explain the purpose of forms_ddl.

1

Why should I use oracle database?

573

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1531

For More Un-Answered { Oracle } Questions Click Here