Database Questions - General syntax part I Job Interview Questions

by D. Lawton Published On 5/20/2011 |

Category: Interviewing

Tell-A-Friend |

Jobs |

Job Tools |

Career Surveys |

Discussions

Database Questions - General syntax part I interview questions have been compiled to prepare for you for your next job interview. Research these questions thoroughly and prepare accurate and concise answers.

What's the difference between a primary key and a unique key?
What are user defined data types and when you should go for them?
What is bit data type and what's the information that can be stored inside a bit column? Define candidate key, alternate key, composite key.
What are defaults? Is there a column to which a default can't be bound?
What is a transaction and what are ACID properties?
CREATE INDEX myIndex ON myTable(myColumn). What type of Index will get created after executing the above statement?
What's the maximum size of a row?
What is the maximum number of columns per table?
What is lock escalation?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What are constraints? Explain different types of constraints.
What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?
What is RAID and what are different types of RAID configurations?
What are the steps you will take to improve performance of a poor performing query?
What are the steps you will take, if you are tasked with securing an SQL Server?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What is blocking and how would you troubleshoot it? How would you restart SQL Server in single user mode?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is a join and explain different types of joins.
Can you have a nested transaction?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is the system function to get the current user's user id?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is a self join? Explain it with an example.
What is a Cartesian product? What causes it?
What is the difference of a LEFT JOIN and an INNER JOIN statement?
When a query is sent to the database and an index is not being used, what type of execution is taking place?
What are the different types of joins?
Explain normalization with examples.
What cursor type do you use to retrieve multiple recordsets?
Difference between a "where" clause and a "having" clause
What is the difference between "procedure" and "function"?
How will you copy the structure of a table without copying the data?