Part 3: List of Questions I have been asked in Interviews

  • How many synchronous and asynchronous nodes are possible in always on?
  • What is RRE lookup?
  • How do you resolve RRE lookup ?
  • What are different types of joins available in SQL server and visible in SQL server execution plans?
  • How many agents are there in replication? What are there names?
  • What is the work of distribution agent ?
  • Replication issues ? Primary key violation issues ? Row mismatched conflicts issues in replication?
  • How do you find out the replication issues errors?
  • How do you solve query timeout errors?
  • Have you worked on mirroring?
  • Have you worked on logshipping?
  • What is a listener?(always on )
  • Ola Hallengren's parameters ?
  • Sample size in Ola Hallengren's scripts?
  • What is the frequency that you are using for updating statistics?
  • Have you worked on SSIS ?
  • Like we have principal and mirror in mirroring ,publisher and subscriber in replication what do we have in terminology in always on ?
  • What is better index seek or index scans?
  • How do you validate that databases are healthy?
  • Have you seen error log completely? What are its contents when SQL server is restarted ?
  • How can you speed up the recovery ? Whats the name of the parameter that can help you in achieving this ?(something related to vlf)
  • What are the modes of database ? What happens when SQL server is shutdown and brought up no matter clean or during disaster (recovery process)
  • How do you do index maintenance ?
  • How do you plan for disk-space issues ?
  • Capacity planning ?
  • How will you convince client about adding more space ?(using auto-growth and file-group database has grown in last few months)
  • How do you solve query slow or timeout issues ?
  • Transaction log is not releasing space what could be the issue?(some active transaction keeping transaction log vlf as active due to which it will resist from releasing space)
  • What is rest API (as I had something in resume related to it)
  • Some questions about automation's(as I was a part of automation team as well in one of my previous company)
  • How many synchronous and asynchronous replicas can be possible in always on ?
  • What different types of joins are available in SQL server (nested ,hash etc)
  • Your expected ctc and current ctc?(though i was later informed that i didn't cleared the round may be as i asked amount which was not falling in there budget for this role)
  • What is row mismatch in replication ?(can be resolved by tablediff)
  • What is primary key violation in replication?(when row is already inserted in subscriber before it is inserted in publisher)

Comments

Post a Comment

Note:Please be gentle while commenting and avoid spamming as comment are anyways moderated thank you.

Popular posts from this blog

Enabling fixed Sidebar for blogger Contempo template for screen sizes smaller than 1440px

Image
Here is how to do it : Add this code in your blogger template(where to add this code is mentioned before 2nd code snippet of this post) ,now the value 1300px is the screen size for which I want the sidebar to be always visible for, you can reduce this value as you like, but be aware that reducing this value to much smaller digit will result in showing the overlapped sidebar instead of content body for your blog readers who are using much smaller screen devices such as mobiles which you might not want to happen so be wise : @media screen and (max-width: 1300px) {   .sidebar-container {     bottom: 0;     position: fixed;     top: 0;   }   .sidebar-container {     left: 0;     right: auto;   }   .sidebar-container.sidebar-invisible {     -webkit-transition-timing-function: cubic-bezier(0.4,0.0,0.6,1);             transition-timing-function: cubic-bezier(0.4,0.0,0.6,1);   }   .sidebar-container.sidebar-invisible {     -webkit-transform: translateX($(sidebar.width * -1));         -ms-
Read more

Adding copy to clipboard button to every google code prettify pre blocks in blogger

Image
It's a 2 part process: The script part to find all the pre blocks having code in it and append a copy button to it dynamically. The style part to place our copy button at the specified location(on top right of every code block in this case) The script part: <script> var pre = document.getElementsByTagName('pre'); for (var i = 0; i < pre.length; i++) {             var button = document.createElement('button');                     button.className = 'copy-button';                     button.textContent = 'Copy';                     var s = pre[i].innerText;                     button.setAttribute("data-clipboard-text",s);                     pre[i].appendChild(button);        } var clipboard = new Clipboard('.copy-button'); clipboard.on('success', function(e) {     console.info('Action:', e.action);     console.info('Text:', e.text);     console.info('Trigger:', e.trigg
Read more

Adding Home Older Newer Post Buttons in new Blogger templates such as Contempo

Image
Requirement: Add Home, Older, Newer Post Buttons in new Blogger templates such as Contempo. Solution: Hi for this jump to Blog widget in HTML editor of your template and find and replace code in includables with respective id's with the ones given below also change the order of buttons as shown below in postPagination includable as per your needs. Code given below shows button in this order   Older Posts Home Newer Posts Demo: Can be seen by clicking here and scrolling to end of page. Screenshot: Note: First page will display only Older posts button as there is nothing to go back when we are on landing or home page and the last page will display Previous posts button and the Home button as there is nothing left to go forward. Displays buttons in order provided here in frontend ,ID to search postPagination: <b:includable id='postPagination'> <div class='blog-pager container' id='blog-pager'> <b:include cond='data:new
Read more