1) Types of joints in sql server 2) DML and DDL commands
Ms Sql Database Administrator Interview Questions
20 ms sql database administrator interview questions shared by candidates
Standard interview and technical questions.
Tell me the 10 differences between Sql 2016 and Sql 2014? -WTH is this.. Tell me all the different kinds of indexes and what they mean? You need definitions for these.
Create Table ,join query
SQL dba architecture and high Availability questions.
SQL statements
Interview process was a phone screen and a two part onsite interview which was very grilling at some points. Overall I decided not to take the offer based on the compensation package not being competitive enough as my current package and my job counter offered me to stay. Overall the process was excellent from the first call to the final interview and offer. I would consider in the future and look at their openings and benefits if I'm ever in the market again.
Detail what occurs during a DBCC CHECKDB command. In hind site this was rediculous because the DBA who interviewed me had turned off all database consistancy check jobs on all customer servers because he didn't understand what the previous DBA had done. It would up being an example of customers paying for something they weren't getting.
experice on high transaction enironment
What was your role and responsibilities in privious company.
Viewing 11 - 20 interview questions
See Interview Questions for Similar Jobs
Ms Sql DeveloperMs Sql Server Database AdministratorDatabase Administrator DbaSql Database AdministratorPostgresql Database AdministratorInfrastructure SpecialistLead Database AdministratorSql DbaSenior Sql Database AdministratorSenior Database AdministratorOracle Database Administrator DeveloperSql Server Database Administrator DeveloperSql Database EngineerSql Server Database AdministratorMs Sql Server DatabasebeheerderMs Sql DatabasebeheerderTeradata ArchitectDatabase Architect