Oracle General Interview Questions
Questions Answers Views Company eMail

How are Indexes Update ?

1 4902

What are Clusters ?

Amdocs, Infosys,

5 9760

What is cluster Key ?

3 5484

What is Index Cluster ?

2 5320

What is Hash Cluster ?

2 5236

When can Hash Cluster used ?

1 4405

What is Database Link ?

2 5115

What are the types of Database Links ?

2 8915

What is Private Database Link ?

1 4098

What is Public Database Link ?

1 3932

What is Network Database link ?

1 5308

What is Data Block ?

2 9650

How to define Data Block size ?

2 5140

What is Row Chaining ?

Cognizant, CTS,

3 12020

What is an Extent ?

3 5827


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what happened to the global index when I truncate the data in one of the partition?

1753


What is columnar storage what is the advantage?

774


What is hot backup and logical backup?

847


Whether any commands are used for months calculation? If so, what are they?

875


How to insert a new row into a table in oracle?

881


What happens if you lost a data file?

833


What is oracle join syntax?

790


Can group functions be used in the order by clause in oracle?

797


How to use regular expression in pattern match conditions in oracle?

820


Is oracle an operator?

734


What is the difference between alert log file and tarce file ?

1893


How to join two tables in a single query using oracle?

794


Difference between cartesian join and cross join?

803


How would you best determine why your MVIEW couldnt FAST REFRESH?

1664


Can you assign multiple query result rows to a variable?

788