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

This post is in continuation of Part 1
  • How will you minimize downtime during a migration will least human effort ? (Mirroring)
  • What is listener?
  • How does listener comes to know which is secondary and which is primary ?(IP SUBNETS)
  • Can we take backups in Always on Secondaries ?
  • What all types of backups can you take in always on secondaries ?(COPY ONLY else it breaks log chain)
  • Why replication when logshipping is available?(Load balancing vs disaster recovery respectively)
  • How many server instances are required for setting up mirroring?(2 without witness (manual failover),3 with witness (automatic failover)
  • Can we set up automatic failover in mirroring without witness server instance?
  • Can you please explain steps for installing mirroring ?
  • Can you please explain steps for installing logshipping?
  • Why do people upgrade and update sql server instances when they have to pay more money for licensing cost even if they are not using new features that are made available?(bug fixes,performance improvement,improvements in query optimizer, cardinality estimator(2012 vs 2014),security patches)
  • How do you make sure databases and server instances are healthy during health checks?
  • Have you seen error log what are the first few lines in it what does they say ?
  • What is recovery ? what happens during it ?
  • What happens when sql server is not cleanly or cleanly shutdown and then brought up ?
  • What are th different phases of database status during the time it is coming up?
  • What is capacity management ?
  • How do you manage space issues ? (Moving files ,shrinking logs,delete obsolete files and old backups as per backup strategy)
  • How do you convince clients to add more disk space?(Filegroup reports,autogrowth analysis during last 6 months or 1 year)
  • What happens when you failover in always on ?
  • What happens when you failover in windows failover cluster?
  • How do you patch a cluster? How do you install SP or CU in nodes with minimum downtime ?
  • What do you know about company?
  • Why this company?
  • Where did you applied ?
  • Did you read about job description?(I got a call from there side without application)
  • What are your salary expectations?
  • Why are you leaving your last organization?
  • Why do you need DBA's when server and instances are being manages by cloud providers?(proper migration,behind the scene even cloud providers are having dbas to manage those instances,performance benchmarking and improvisations,doing things the right way)
  • How did you resolve performance issues?(ORM ,Bad plans,bad queries,stale indexes,index rebuilds/reorganize,update stats)
  • How good are you at scripting ?
  • How do you upload backups to S3 ?(powershell copy-s3object commandlets)
  • Can you upload backups to s3 without amazon cli?
  • Someone deleted replication jobs we dont have trace or anything enabled to capture this information,how will you find out who did it in case you can if its possible ?(I think the case here was an obsolete objects from old replication setup which was not cleanly removed which leads to deletion of distribution agents jobs due to some internal clash and information gets logged into sql agent history when this happens ,this also happens when agent jobs are deleted when they are under execution)I also tried suggesting fn_dblog() to read transaction log to find this informations.


Popular posts from this blog

Connecting Microsoft SQL Server using PHP

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

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