{"schemaVersion":"jobsearcher.job.v1","id":"4d949b94782438df6643d4fb","url":"https://jobsearcher.com/jobs/4d949b94782438df6643d4fb","canonicalUrl":"https://jobsearcher.com/jobs/4d949b94782438df6643d4fb","title":"SQL Server Database Engineer: Build Robust Data Systems","description":"Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the Deadlock?\r\n2) What are the different types of database backups?\r\n3) How do you perform the Error handling in SQL Server?\r\n4) What is the ACID property in SQL Server?\r\n5) What are the best practices in Database programming?\r\n6) What are the different isolation level in SQL Server\r\n7) What is the default isolation level in SQL Server\r\n8) What is dirty read in SQL Server\r\n9) What are the Serializable isolation level in SQL Server\r\n10)What are the Rank functions in SQL server\r\n11) What is Replication in SQL Server\r\n12) What is the stuff function in SQL Server?\r\n13) What is the Difference between Stuff command and Replace command in SQL Server\r\n14) What is the merge command in SQL Server?\r\n15) What is the Pivot/Unpivot table in SQL Server?\r\n16) What is Derived table in SQL Server?\r\n17) What is the Output clause in SQL Server?\r\n18) What is the temporary tables in SQL Server?\r\n19) What are the different types of database in SQL Server?\r\n20) What is CTE in SQL Server?\r\n21) What are the benefits of using CTE SQL Server\r\n22) What are cursors in SQL Server?\r\n23) What are Views in SQL Server?\r\n24) What are Triggers in SQL Server?\r\n25) What are magic tables in SQL Server?\r\n26) What are the difference between Stored Procedure and SQL triggers in SQL Server?\r\n27)If no rows are affected by the SQL query, will after trigger will execute?\r\n28) How can we improve the performance of an stored procedure?\r\n29) What are the heap table in SQL Server?\r\n30) Where we need to use table variable and where we should use temporary tables?\r\n31) What is log shipping in SQL Server?\r\n32) What is fragmentation in SQL Server?\r\n33) What is the difference between logical and physical fragmentation?\r\n34) In which database temporary tables are created?\r\n35) What is the difference between Except command and Intersect command?\r\n36) What is the BCNF in SQL Server?\r\n37)What is database collation?\r\n38) Suppose there are two\r\ntables A and B and we need to write 3 SQL queries which returns\r\ntherecord setas shown in the below figure.\r\n39) Suppose we have to\r\ndesign a database in which employees can work on multiple projects.There\r\nare many designation defined in the organization to which each employee\r\ncan belongs.\r\nFor\r\nexample, Software engineer, Team lead, Project Manager, Project lead,\r\nQC engineer, QC Lead, QC manager etc. An employee can belong to one\r\ndesignation\r\nat a time. It means at a time an employee can either be Software\r\nengineer or team lead or project manager but not software engineer as\r\nwell team lead at a same time.\r\nTrending Advantages of SQL Stored Procedure Also the projects can work on different technologies like .Net, SQL\r\nServer, Oracle, HTML5 etc. Every project has a start data and end date. A\r\nproject can work can include many technologies like .net, SQL Server ,\r\nJava script, HTML5 etc. Most of the time every project work include a\r\nfront end server technology like JAVA. Asp.net, uses Java script, HTML,\r\nCSS as client side technologies and SQL Server, oracle as back end\r\ndatabase server. So In this ways a project work can include many\r\ntechnologies as in above example, suppose a project can use Asp.net as\r\nserver end front end technology, java script, HTML, CSS, AJAX as client\r\nside technology and SQL server as back end database server.\r\nWhat should be the design the database schema (tables, their foreign keys, primary keys etc.?\r\n40) Suppose we have a table named tbl_charactername have only one column say \"charactername\".\r\nIt contains 10 rows. First 5 rows contains \"Vivek Johari\" and the next 5 rows contains \"Abhinav Golwalkar\" tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now we need a SQL Query which can return the result in the form Desired Result:- Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar\r\nQuery should work even if the table has 30 rows with first 15 contains \"vivek johari\" and next 15 contains \"Abhinav Golwalkar\" or 40 rowswith first 20 contains \"vivek johari\" and next 20 contains \"Abhinav Golwalkar\" etc. But output should contains \"Vivek Johari\" and\"Abhinav Golwalkar\" in alternate rows. 41) Suppose we have a table says tbl_students whose structure is given below:-\r\nCreate table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))\r\nSuppose it contains the following data:-\r\nStudentid Studentname 1 Vivek Johari 2 Chandra Singh 4 Avinash Dubey 6 Akhil 7 Sunny Rana 10 Saurabh\r\nAs one can see from the data that some rows are deleted from the table as some studentids are missing.\r\nSo write a query which gives the studentid which are deleted from this table Project Manager Round Questions:- 1) Give me your brief introduction. 2) What your current project and your role in it? 3) How is your team size? 4) what is thehierarchyin your organization?\r\n5) Have you any experience of DBA activity? 6) How big your database size? 7) How you optimize database (same technical question but this time PM just want to know just an overview)? 8) What best practices you follow in your company? 9) Any tools your company uses for database designing? 10) Do your company follow Agilemethodology?\r\n11) Any challenges you faces in your current project? 12) Why you want to change your current organization 13) Would you like to work on C#, web services, Java (in case of Oracle) if required? 14) How early you can join(want to know your notice period or possibility of early joining)? 15) Do you want to ask any question from us?\r\nDiscover more from Technology with Vivek Johari Subscribe to get the latest posts sent to your email.\r\nRelated Posts Query Query can be defined as a way to inquire the data from the database. It is used to extract […]\r\nBoth Primary key and Unique key enforce uniqueness of the column on which they are defined but still there are […]\r\nAlthough the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still […]\r\nIn Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to […]\r\n3 thoughts on \"Interview questions for database developer\" Hip Hip Hooray! I was always told that slightly slow in the head, a slow learner. Not anymore! It's like you have my back. I can't tell you how much I've learnt here and how easily! Thank you for blessing me with this effortlessly ingestible digestible content.\r\nWe are looking for some recommendations or best practices for creating or architecting a simple trigger. We have a table that will have data inserted periodically throughout the day. Upon completion of the insert (and possibly updates) we'll need two things to happen:\r\n1) We'll update data in a second table. This could be a simple update or possibly calling a stored procedure.\r\n2) We'll also need to initiate an e-mail\r\nI've done some simple triggers before but was not sure of the right structure for combining the two processes. Can I do that in one trigger? Please advise. This is for SQL2014. Look forward to a response.\r\nJ\r\nBut nice Article Mate! Great Information! Keep up the good work!\r\nJ-18808-Ljbffr","company":"Techmixing","rawCompany":"techmixing","city":"New Bremen","state":"OH","isRemote":false,"isActive":false,"createdAt":"2026-07-04T01:53:37.615Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"SQL Server Database Engineer: Build Robust Data Systems","description":"Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the Deadlock?\r\n2) What are the different types of database backups?\r\n3) How do you perform the Error handling in SQL Server?\r\n4) What is the ACID property in SQL Server?\r\n5) What are the best practices in Database programming?\r\n6) What are the different isolation level in SQL Server\r\n7) What is the default isolation level in SQL Server\r\n8) What is dirty read in SQL Server\r\n9) What are the Serializable isolation level in SQL Server\r\n10)What are the Rank functions in SQL server\r\n11) What is Replication in SQL Server\r\n12) What is the stuff function in SQL Server?\r\n13) What is the Difference between Stuff command and Replace command in SQL Server\r\n14) What is the merge command in SQL Server?\r\n15) What is the Pivot/Unpivot table in SQL Server?\r\n16) What is Derived table in SQL Server?\r\n17) What is the Output clause in SQL Server?\r\n18) What is the temporary tables in SQL Server?\r\n19) What are the different types of database in SQL Server?\r\n20) What is CTE in SQL Server?\r\n21) What are the benefits of using CTE SQL Server\r\n22) What are cursors in SQL Server?\r\n23) What are Views in SQL Server?\r\n24) What are Triggers in SQL Server?\r\n25) What are magic tables in SQL Server?\r\n26) What are the difference between Stored Procedure and SQL triggers in SQL Server?\r\n27)If no rows are affected by the SQL query, will after trigger will execute?\r\n28) How can we improve the performance of an stored procedure?\r\n29) What are the heap table in SQL Server?\r\n30) Where we need to use table variable and where we should use temporary tables?\r\n31) What is log shipping in SQL Server?\r\n32) What is fragmentation in SQL Server?\r\n33) What is the difference between logical and physical fragmentation?\r\n34) In which database temporary tables are created?\r\n35) What is the difference between Except command and Intersect command?\r\n36) What is the BCNF in SQL Server?\r\n37)What is database collation?\r\n38) Suppose there are two\r\ntables A and B and we need to write 3 SQL queries which returns\r\ntherecord setas shown in the below figure.\r\n39) Suppose we have to\r\ndesign a database in which employees can work on multiple projects.There\r\nare many designation defined in the organization to which each employee\r\ncan belongs.\r\nFor\r\nexample, Software engineer, Team lead, Project Manager, Project lead,\r\nQC engineer, QC Lead, QC manager etc. An employee can belong to one\r\ndesignation\r\nat a time. It means at a time an employee can either be Software\r\nengineer or team lead or project manager but not software engineer as\r\nwell team lead at a same time.\r\nTrending Advantages of SQL Stored Procedure Also the projects can work on different technologies like .Net, SQL\r\nServer, Oracle, HTML5 etc. Every project has a start data and end date. A\r\nproject can work can include many technologies like .net, SQL Server ,\r\nJava script, HTML5 etc. Most of the time every project work include a\r\nfront end server technology like JAVA. Asp.net, uses Java script, HTML,\r\nCSS as client side technologies and SQL Server, oracle as back end\r\ndatabase server. So In this ways a project work can include many\r\ntechnologies as in above example, suppose a project can use Asp.net as\r\nserver end front end technology, java script, HTML, CSS, AJAX as client\r\nside technology and SQL server as back end database server.\r\nWhat should be the design the database schema (tables, their foreign keys, primary keys etc.?\r\n40) Suppose we have a table named tbl_charactername have only one column say \"charactername\".\r\nIt contains 10 rows. First 5 rows contains \"Vivek Johari\" and the next 5 rows contains \"Abhinav Golwalkar\" tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now we need a SQL Query which can return the result in the form Desired Result:- Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar Vivek Johari Abhinav Golwalkar\r\nQuery should work even if the table has 30 rows with first 15 contains \"vivek johari\" and next 15 contains \"Abhinav Golwalkar\" or 40 rowswith first 20 contains \"vivek johari\" and next 20 contains \"Abhinav Golwalkar\" etc. But output should contains \"Vivek Johari\" and\"Abhinav Golwalkar\" in alternate rows. 41) Suppose we have a table says tbl_students whose structure is given below:-\r\nCreate table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))\r\nSuppose it contains the following data:-\r\nStudentid Studentname 1 Vivek Johari 2 Chandra Singh 4 Avinash Dubey 6 Akhil 7 Sunny Rana 10 Saurabh\r\nAs one can see from the data that some rows are deleted from the table as some studentids are missing.\r\nSo write a query which gives the studentid which are deleted from this table Project Manager Round Questions:- 1) Give me your brief introduction. 2) What your current project and your role in it? 3) How is your team size? 4) what is thehierarchyin your organization?\r\n5) Have you any experience of DBA activity? 6) How big your database size? 7) How you optimize database (same technical question but this time PM just want to know just an overview)? 8) What best practices you follow in your company? 9) Any tools your company uses for database designing? 10) Do your company follow Agilemethodology?\r\n11) Any challenges you faces in your current project? 12) Why you want to change your current organization 13) Would you like to work on C#, web services, Java (in case of Oracle) if required? 14) How early you can join(want to know your notice period or possibility of early joining)? 15) Do you want to ask any question from us?\r\nDiscover more from Technology with Vivek Johari Subscribe to get the latest posts sent to your email.\r\nRelated Posts Query Query can be defined as a way to inquire the data from the database. It is used to extract […]\r\nBoth Primary key and Unique key enforce uniqueness of the column on which they are defined but still there are […]\r\nAlthough the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still […]\r\nIn Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to […]\r\n3 thoughts on \"Interview questions for database developer\" Hip Hip Hooray! I was always told that slightly slow in the head, a slow learner. Not anymore! It's like you have my back. I can't tell you how much I've learnt here and how easily! Thank you for blessing me with this effortlessly ingestible digestible content.\r\nWe are looking for some recommendations or best practices for creating or architecting a simple trigger. We have a table that will have data inserted periodically throughout the day. Upon completion of the insert (and possibly updates) we'll need two things to happen:\r\n1) We'll update data in a second table. This could be a simple update or possibly calling a stored procedure.\r\n2) We'll also need to initiate an e-mail\r\nI've done some simple triggers before but was not sure of the right structure for combining the two processes. Can I do that in one trigger? Please advise. This is for SQL2014. Look forward to a response.\r\nJ\r\nBut nice Article Mate! Great Information! Keep up the good work!\r\nJ-18808-Ljbffr","datePosted":"2026-07-04T01:53:37.615Z","dateModified":"2026-07-04T01:53:37.615Z","hiringOrganization":{"@type":"Organization","name":"Techmixing","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"New Bremen","addressRegion":"OH","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"4d949b94782438df6643d4fb"},"url":"https://jobsearcher.com/jobs/4d949b94782438df6643d4fb"}}