SQL Interview Questions
Interview questions for SQL programmer is usually full of technical questions based on Microsoft SQL programming. Here are a few questions that could be expected to be asked during the interview.
- What are the two main sub languages of SQL?
- What is a Cartesian product? How is it different from cross product?
- Explain in brief Materialized View.
- Can you elaborate what is Raise_application_error?
- What is the maximum number of rows and columns that a table can have?
- Explain the difference between Delete Table and Truncate Table.
- Explain self join with the help of an example.
- Can Microsoft SQL create new databases? Can you explain how?
- Is it possible to delete records from a database in SQL?
- What do you mean by Raid?
- Name the different types of RAID configurations.
- What is the primary difference between UNIONALL and UNION?
- Explain in short, the three main types of MySQL.
- Can you tell what MOLAP, HOLAP and ROLAP mean?
- What steps are to be taken to secure an SQL server?
- How to determine the service pack that is installed on SQL server?
- Explain the two functions - FIRST() and LAST().
- Explain blocking. How can you troubleshoot blocking?
- What do you understand by lock escalation?
- What are the characteristics of cluster index?
- What keyword is used to sort the records in an ascending/ descending order?
- Is it possible to retrieve images from database? If yes, how would you do it?
- Can you explain what live lock is?
- Can you explain what dead lock means? How to resolve dead locks?
- What are cursors?
- What are the advantages and drawbacks of cursors?
- How do you explain reference cursors?
- What does the SQL PRIMARY KEY constraint do?
- How would you explain an extended stored procedure?
- What are attributes? State the advantages and disadvantages of attributes?
- Explain the use of LCASE() function.
- What is Data Definition Language (DDL) used for?
- What is normalization? Explain with the help of examples.
- What is denormalization? Explain with the help of examples.
- What is the difference between right join and left join?
- Chalk out the difference between SQL server and SQL.
- Can you state the advantages and disadvantages of using foreign key in Microsoft SQL?
- What is DBMS? What is RDBMS? What is the difference between the two of them?
- What are the functions of constraints?
- In SQL, what is the SELECT statement used for?
- What are Cascade Constraints? How do you use it?
- What does the keyword INNER JOIN mean? What is it used for?
- Explain Store Procedure.
- When do we use user defined datatypes?
- What does ACID stand for? What are its properties?
- How would you explain triggers? What is the maximum number of triggers one can have on a table?
- What are triggers used for?
- Can you explain Null and Three-Valued Logic (3VL)?
- How do we write INSERT INTO statement in SQL?
- Can you run SAP applications on SQL?
Thus, to become successful in this interview, display self confidence along with your technical SQL knowledge.
