#1
June 5th, 2016, 09:49 AM
| |||
| |||
HCL SQL DBA Interview Questions
Hello sir I have an interview in HCL and I am here as I want to get the Interview Questions related to SQL DBA so will you please provide me the questions?? HCL Technologies Limited is a multinational IT services company, headquartered in Noida, Uttar Pradesh, India. It is a subsidiary of HCL Enterprise. As per your demand here I am providing you Interview Questions related to SQL DBA 1. What is the difference between sys.databases and sysdatabases 2. How can we know linked servers information?—Ans: select * from sys.servers 3. How to know all databases info that are in box? Ans: select * from sysdatabases 4. Are we run query on mirror server? 5. Are we run query on secondary server of log shipping? 6. What is default port for sqlserver? 1433(tcp/Ip), UDP:1434 7. What is dynamic port in sqlserver? 8. How to set default backup directory path? 9. How to add full text service after installation? 10. How to find orphan logins? 11. What is quorum? 12. What is the advantage of active & active two node clustering? 13. What are the reasons when a particular user account is not working? 14. What are the reasons for connection is slow? 15. What is the default time for remote connections? 600 16. What is auditing? 17. Which server role is assigned for backup? ANS: DB_BACKUPOPERATOR 18. I have 30GB Ram, How can we configure for production environment? Ans: Depends SLA 19. What are problems that you faced for log shipping? 20. What is the distribution database? 21. What does distribution database contains is it contains data? 22. What is fill factor? 23. How to shrink database? What are the steps? 24. How to move temp data base? 25. What are suggestible raid levels for mdf and log files?mdf-raid1, log – raid5 26. How many temp db’s are recommended as per Microsoft standards? 27. Have you used profiler? 28. Is it possible to save profiler data into table? Yes, in text file aslo 29. What are table partitions? 30. What is schema binding? 31. Can I create index on table partitions? 32. Can I get error while index is rebuilt? 33. I have 4 databases, in that having 4 users, those 4 users are mapped with some server roles, and those 4 users are there in one database. If I am deleting that major db, is remaining db users are working or not? Yes, they have access with reaming db’s. Those are called orphan logins 34. How to take resource data base backup? Last edited by Neelurk; May 29th, 2020 at 12:30 PM. |
|