Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

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

2066

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

2252

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

1 4303

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 14436

how do u setup a replication site?

2031

what is a Nested Loop join?

2173

when do u go for hash partitioning?

1 3835

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16982

how do get database name at sql prompt?

3 7213

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

2376

does the query needs a hint to access a materialized view?

1905

what is analyze command ? what kind of statistics does it generate?

2 5097

how do u know the total no of rows in a table?

6 9260

what are archived logs?

2259

what are bitmap indexes? How does they work?

2302

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to display employee records who gets more salary than the average salary in the department?

1126

How to set a transaction to be read only in oracle?

1137

What is a initialization parameter file in oracle?

1081

What is concurrency in oracle?

1057

How many types of auditing in Oracle?

1086

Explain rename?

1043

What are the differences between interval year to month and interval day to second?

1062

What is a snapshot log?

1049

Is there any function in oracle similar like group_concat of mysql?

1105

Can multiple cursors being opened at the same time?

1115

What is ordinary table in oracle?

1238

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2227

How do we get field detail of a table?

1125

What is a database schema in oracle?

1150

What is a sub query? Describe its types?

1071

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