SQL Interview Questions

Basic Questions

  • What is SQL?
  • What is RDBMS?
  • Basic SQL commands
  • SQL Joins
  • SQL Constraints
  • Unique, Primary and Foreign Key
  • DDL, DML, DCL and TCL
  • Truncate, Drop and Delete

Medium Questions

  • What are Indexes
  • What is a trigger in SQL Server
  • Use of “Having” keyword
  • Database Normalization
  • Can I update table by updating view?
  • Stored Procedure vs Function

Advanced Questions

  • SQL Injection
  • ACID Principles
  • Transactions in SQL Server
  • Database performance improvement techniques
  • Table Partitioning
  • Different Isolation levels in Database
  • Difference between a temp table and table variable in SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s