Visual Basic and SQL Server interview questions

1. What is the difference between modal and modaless form in VB?
2. Why we need a MDI form? How can we make a form as a mdichild form?
3. Specify technical & functional architecture of your last 2 projects.
4. What are the objects in ADODB?
5. What are different types of cursors in ADODB?
6. What are different types of locks in ADODB?
7. What is disconnected recordset?
8. Besides Standard Exe what are other types of projects in VB?
9. What is the difference among Standard EXE, Active-X DLL, Active-X EXE?
10. A standard exe contains a registered Active-X DLL. Now some error arise in the application but not in the standard exe , it is in the Active-X DLL. How do you find it out in which line no the error is?
11. How can we find out that a recordset is blank (without using recordcount property)?
12. What is the difference between procedure and functions in VB?
13. What are the differences between stored procedure and functions in SQL Server 2000?
14. I want to develop a stand alone application which can communicate with the existing applications in the system. On which this application should be based on: Standard Exe,Active-X Exe,Active-X Dll.
15. can we call stored Procedure in Function in Sql Server 2000 and vice versa.
16. What is an extended Stored Procedure?
17. What is Trigger?
18. Suppose I made an after Trigger on Delete. Now I fire Delete * From tablename. will this trigger work? Now do I fire truncate from table name (instead of delete command). will this trigger work now? If yes or no then why?
19. What is a view? is View updatable?
20. What is the difference between having and where clause?
21. Why we need a group by clause?
22. What is a join and their types?
23. What is the difference between referencing and joining?
24. What is the difference between constraints and triggers?
25. What is the maximum size of form to hold the controls?
26. Write the correct order of execution of following form’s events: initialization, Load, Activate, Refresh , Paint
27. What is ACID Property of Transaction?
28. How do we call MS- Excel in VB?
29. What does option Explicit means?
30. What is an index?
31. What is normalization and its forms?
32. What does Query_unload event do in VB? Why we need Form _unload event?
33. What is a cursor in SQL Server 2000 and their types?
34. How do we get month name in SQL Server 2000, Oracle, MS Access?
35. How do we return a record set from a Stored Procedure in SQl server 2000?
36. What are the magic tables in SQL Server 2000?
37. What is Enum in VB?

There are 2 tables:
EMP : EmpId, Ename, Sal, DeptId
DEPT : DeptId, Dname

38. Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows “No Department”.
39. Write a query to find out those department names which has no employee.
40. Write a query to find out those employees whose salary is greater than their department’s average salary.
41. How do we get current date in SQL Server 2000, Oracle, MS Access?