Friday, January 18, 2013

Potential Technical Interview Questions for a DBA or SQL Developer

**These are questions that a DBA or SQL developer may get asked

**Note: this is what I found on google or learned throughout coursework; I have only applied to and interviewed for web and application developer positions

What is the difference between optimistic and pessimistic locking?
What is a deadlock?
What is a delete statement?
What is a truncate statement?
What is a trigger?
What is a stored procedure?
What is an SQL injection?
Have you worked with _________ (ex Oracle, DB2)?
What is a self join (cartesian join)?
What is an index?
What is referential integrity?
What is a having clause?
What is a where clause?
What is the difference between data mining and data warehousing?
How do you prevent SQL injection?
What is the difference between a full (outer) join and inner join?
What is the difference between a left join and right join?
What is the difference between group by and order by?
What is a subquery?
What is the purpose for database normalization?
What is a constraint?
What is a primary key?
What is a foreign key?
How would you describe what a query is?

What is a view?



Back to Main Page

No comments:

Post a Comment