#1
May 7th, 2016, 11:57 AM
| |||
| |||
SQL DBA Interview Questions in HCL
Hi buddy I am going to appear in HCL Technologies Interview section for software engineer post and here looking for Interview Questions on SQL DBA related , so can you plz provide me here ??
|
#2
May 7th, 2016, 11:57 AM
| |||
| |||
Re: SQL DBA Interview Questions in HCL
As you said you will appear in HCL Technologies Interview section for software engineer post and here looking for Interview Questions on SQL DBA related , so here I am providing same for you 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 |