Database Interview Questions
- 0of 0 votes
Answers(SQL) What is a foreign key?
- Jason Yip July 22, 2008| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database Terminology & Trivia - 0of 0 votes
Answers(SQL) Explain normalization.
- Jason Yip July 22, 2008| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database Terminology & Trivia - 0of 0 votes
Answer(SQL) What are the different types of joins? Please explain how they differ.
- Jason Yip July 22, 2008| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
Answers(SQL) Explain cluster index.
- Jason Yip July 22, 2008| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswerWhat is a database
- Ijaz Ali shah February 07, 2008| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswersI have a following table with coloumn structure as shown below:
- Subhash April 23, 2007
FROM TO PRICE STARTDATE ENDDATE
Mum Ban 2000 1stjan07 31stjan07
Mum Goa 3000 1stjan07 31stjan07
Goa Del 5000 1stjan07 31stjan07
.. .. .. ... ..
Mum Ban 1000 1stFeb07 28thjan07
Mum Goa 3000 1stFeb07 28thjan07
Goa Del 5000 1stFeb07 28thjan07
Like this it will be for all other months
So write a query in SQL which will show the output as shown below:
Date TO FROM PRICE
1stjan07 Mum Bang 2000
1stjan07 Mum Goa 3000
1stjan07 Goa Del 5000
2ndjan07 Mum Bang 2000
2ndjan07 Mum Goa 3000
2ndjan07 Goa Del 5000
and like this
we have to arrange it like date wise?| Report Duplicate | Flag | PURGE
Kingfisher Analyst Database - 0of 0 votes
Answers1. Difference between clustered and non clustered index
- Srinivasan March 13, 2007
2. Difference between having and where
3. What is query optimization| Report Duplicate | Flag | PURGE
Morgan Stanley Software Engineer / Developer Database - 0of 0 votes
AnswerWhat is an index?
- M January 17, 2007| Report Duplicate | Flag | PURGE
Goldman Sachs Software Engineer / Developer Database - 0of 0 votes
AnswersYou have to design a database that can store terabytes of data. It should support efficient point queries. How would you do it ?
- Chandan December 25, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database Algorithm - 0of 0 votes
AnswersWhat's the difference between a primary key and a unique constraint?
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswerHow do you model a many-to-many relationship?
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswersDiscuss the usage of a foreign key.
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswersHow do you enforce referential integrity in SQL?
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswersWhat are some of the security concerns in web programming? Discuss some of the validations that need to be done in web programming.
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
AnswerHow do you pass information from page to another page in ASP.NET?
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - -1of 0 votes
AnswersIf I want to bind just one table to my list, do you use a DataAdapter or DataReader?
- Jason Yip December 22, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
Answersdescribe a project you worked on. How did you go about designing it. Why do you use stored procedures.
- Lee October 04, 2006| Report Duplicate | Flag | PURGE
Barclays Capital Analyst Database Experience - 0of 0 votes
AnswerWhere do you see query plan?
- Jason Yip August 31, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database - 0of 0 votes
Answer(SQL) What is an index?
- Jason Yip August 31, 2006| Report Duplicate | Flag | PURGE
Microsoft Software Engineer / Developer Database Terminology & Trivia - 0of 0 votes
AnswersInterviewer> If we have a table containing Emp_ID,Emp_Name and Dept_ID(Primary key) and another table having Emp_Name and Dept_ID (foreign key), how would u find the number of employees in each dept?
- Karthik Srinivasan April 21, 2006| Report Duplicate | Flag | PURGE
MarketRX Software Engineer / Developer Database - 0of 0 votes
AnswerInterviewer> Which member function of Sqldataadapter is used to fill the dataSet?
- Karthik Srinivasan April 21, 2006| Report Duplicate | Flag | PURGE
MarketRX Software Engineer / Developer Database - 0of 0 votes
AnswerInterviewer> How to find the number of records in a DataSet?
- Karthik Srinivasan April 21, 2006| Report Duplicate | Flag | PURGE
MarketRX Software Engineer / Developer Database Terminology & Trivia - 0of 0 votes
AnswerInterviewer> What's the difference between DataView and DataReader?
- Karthik Srinivasan April 21, 2006| Report Duplicate | Flag | PURGE
MarketRX Software Engineer / Developer Database - 0of 0 votes
AnswerInterviewer> What GroupBy in SQL do?
- Karthik Srinivasan April 21, 2006| Report Duplicate | Flag | PURGE
MarketRX Software Engineer / Developer Database Terminology & Trivia - 0of 0 votes
AnswersExplain how to write a stored procedure in SQL
- AP April 16, 2006| Report Duplicate | Flag | PURGE
Amazon Software Engineer / Developer Database - 0of 0 votes
Answersdatabase question like self joint with tables given by him
- sweety March 24, 2006| Report Duplicate | Flag | PURGE
Amazon Development Support Engineer Database - 0of 0 votes
AnswersDraw a basic ER diagram for Netflix.
- Jack February 27, 2006| Report Duplicate | Flag | PURGE
Microsoft Program Manager Database - 0of 0 votes
AnswersWhat did you use to connect perl to database ?
- Srihari January 12, 2006| Report Duplicate | Flag | PURGE
Bloomberg LP Software Engineer / Developer Database