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?

2018

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

2199

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

1 4224

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

2 14311

how do u setup a replication site?

1980

what is a Nested Loop join?

2104

when do u go for hash partitioning?

1 3747

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

CSC,

2 16818

how do get database name at sql prompt?

3 7073

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

2325

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

1857

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

2 4999

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

6 9077

what are archived logs?

2197

what are bitmap indexes? How does they work?

2235

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I reset a sequence in oracle?

1096

How to specify default values in insert statement using oracle?

1102

Is there a combination of "like" and "in" in sql?

1055

What is the difference between PFILE and SPFILE in Oracle?

1060

How do I recompile a procedure in oracle?

962

What is an oracle wallet?

942

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2323

What is a nested table and how is it different from a normal table?

1044

What are the built-in functions used for sending Parameters to forms ?

3384

Difference between open_form and call_form in oracle.

1158

what is the difference between data migration and production migration.

2343

What is the difference between post-database commit and post-form commit?

1190

Where are the settings stored for each instance in oracle?

1105

Explain oracle insert into command?

1110

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1997

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