This is updated post with all pre-interview questions discovered in recruiter's emails. Here is no questions asked on interview with pre-signed agreement do not share its details.
Set #1
Set #1
- What is the difference between a Matrix and Matrix with group report?
- Can you explain the difference between Group By and Partition By clauses?
- What are the analytical functions available in Oracle?
- What is the difference between Single and Correlated sub-queries?
- What is query to get first day of the last quarter?
- How can you tell if an UPDATE updated no rows, in SQL and PL/SQL?
- Difference between DELETE, TRUNCATE and DROP?
- Difference between Primary, Unique and Foreign keys?
- How to debug PL/SQL code?
- Explain the difference between implicit and explicit cursors?
- What are clusters?
- Explain some of the commonly used Predefined PL/SQL Exceptions
- What is a Materialized view?
- What is the Networkdblink?
- Predefined exceptions and explanation?
- Difference b/w view and meterialized view?
No comments:
Post a Comment