2023 2024 EduVark > Education Discussion > General Discussion


  #1  
June 5th, 2016, 09:49 AM
Super Moderator
 
Join Date: Mar 2013
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.
Similar Threads
Thread
HCL AIX Interview Questions
HCL ASP.NET Interview Questions
RSM MBA Interview Questions
MBA HR Interview Questions
Questions For MBA Interview
MTS Interview Questions
HCL WPF Interview Questions
HCL PMO Interview Questions
SQL DBA Interview Questions in HCL
CTS MBA Interview Questions
NDA SSB Interview Questions
KVS PRT Interview Questions
Sas Sql Interview Questions
NDA Interview Questions
Interview Questions After Mba



Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5. The time now is 12:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.6.0

1 2 3 4 5 6 7 8