Oracle Interview Questions
Questions Answers Views Company eMail

when do u go for hash partitioning?

1 3071

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

CSC,

2 15650

how do get database name at sql prompt?

3 5845

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

1837

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

1468

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

2 4082

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

6 7149

what are archived logs?

1717

what are bitmap indexes? How does they work?

1719

what are the database links ?

2 3772

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

1 3211

what are different types of locks?

6 6691

master table and child table performances and comparisons in Oracle ?

1668

what are the different types of cursors? explain?

4 8461

what are different types of deletes?

1 2956


Un-Answered Questions { Oracle }

What are different types of receipt reversals ? Explain them : oracle accounts receivable

727


What is the load balancing advisory?

1


What is a matrix report and how many minimum groups are required to prepare the same?

551


Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?

1


What is the usage of synonyms?

591






How do I spool in oracle?

542


You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

285


Who is dba in dbms?

290


How to test null values?

678


What are summary column and placeholder column in reports?

1


What is rac?

1


What is the difference between internal & external schema?

317


How to speed up webrick?

595


What happens if the constraint name is left out of a constraint clause?

279


How can a single instance environment be converted into rac environment and how will they be different?

1