HCL SQL Interview Questions

Hello sir I am preparing for the HCL SQL Interview so can you please provide me the
SQL DBA interview questions+ HCL ??

[sumit]

As per your need here I are the SQL DBA interview questions+ HCL

1. What is SQL Server Architecture?
2. What is page?
3. What is extent?
4. What are the different types of extents?
5. What is the difference between those two extents?
6. Which pages are available in extents?
7. What is fill factor?
8. How to take backup of DB when the db is in Log shipping by taking that backup without changing LSN?
9. How to change port number for sql server
10. Is it possible to change port for mirroring after configuring mirroring?
11. What is the major difference between Merge replication and Transactional replication?
12. How to resolve conflicts in merge replication?
13. What is quorum in clustering?
14. What happened when quorum gone?
15. Is it possible to start service when quorum is gone?
16. How to take backup of 400GB DB with in less time?
17. How to find what are the driver’s available in our machine?
18. What is check point?
19. Is it posible to raise chaeckpoint our self?
20. What is the difference between procedure and function?
21. How to call procedure?
22. What is the advantage of recompile statement in procedure?
23. How to know the current connected connections?
24. How to set maximum connections?
25. How to start sql service without raising checkpoint?
26. Have you work on cmd prompts?
27. What is transaction?
28. Can you say syntax of transaction?
29. What is difference between cascade drop of table?
30. What happened if we issue drop table command?
31. What are the several recovery models?
32. Why log shipping is not supported in simple recovery model?
33. What is the default port for mirroring?
34. How to change default port for sqlserver?
35. What is resource governor?
36. What is heart beating in clustering?
37. Which cable is used for heart beat, Is it cross cable or plain cable?
38. What are the different types of indexes?
39. What are the limits for cluster and non cluster indexes? ANS: 1- 255
40. Why we have only one cluster index for table?
41. What is the importance of statistics?
42. Scenario: My server running fast upto the yester day, today onwords slows, As a DBA what you have to do?
43. How to find what are the queries that are running in particular SPID?
44. How to find sql server version?
45. What is another port number for sqlserver?
46. I have backup and I want to restore upto particular time only?
47. How to create user, how to assign read and write permissions only for that user?
48. What is Super admin, who is having total rights in system level? Ans: SA
49. What is full form of SA? Ans: System Administrator
50. What are the different locks?
51. What are different isolation levels?
52. What is serelizable?
53. What is exclusive lock?
54. I have done some schema change (Add column for table) in merge replication for an article, is it applied for subscriber?
55. Can you list some system tables?
56.Difference between shrink and truncate?
Truncate cannot remove empty space
Shrink can remove empty space, so space may recollect