Oracle Important Interview Questions
Ø What are two methods of Retrieving SQL?
Ø What Cursor type you use to Retrieve multiple record set?
Ø Explain Difference B/W Union & Union All ?
Ø Explain Difference B/W Truncate & Delete?
Ø Difference B/w Primary Key & Unique Key?
Ø Define Composite Key & Candidate Key?
Ø What is the Difference Between "Where" clause and "Having Clause?
Ø What structure do you implement to speed up the read data basetable?
Ø What are the advantages of Indexes?
Ø What is the syntax of statement to read data out of Table?
Ø What is a Join?
Ø What are the types of Joins?
Ø What is Self Join?
Ø What is Constraint?
Ø What is Normalization?
Ø What type of Index data structure do you use?
Ø What is Primary key?
Ø What is functional Dependency? How does it related to Database table design?
Ø What is Sub Query?
Ø What is Co-Related sub query?
Ø Difference B/W Sub query & Co-Related Sub query?
Ø What is View?
Ø What is Materialized View?
Ø What is the difference between View & Materialized View?
Ø What is Trigger?
Ø what are Cursors?
Ø Explain Advantages of Cursors?
Ø Types of Cursors?
Ø What are advantages of Stored procedure?
Ø Why do u use Group By Order By functionalities explain?
Ø what type of Join algorithms do u have?
Ø What are the advantages of Triggers?
Ø How do you Retrieve Top 5 Records from Table?
Ø How do you Find Duplicate Records?
Ø How do you improve performance of the Query?
No comments:
Post a Comment