Questions database developer

Technical Round Database Interview Questions

• 1) What are the different types of Trace flags which we used for detecting the Deadlock?
• 2) What are the different types of database backups?
• 3) How do you perform the Error handling in SQL Server?
• 4) What is the ACID property in SQL Server?
• 5) What are the best practices in Database programming?
• 6) What are the different isolation level in SQL Server
• 7) What is the default isolation level in SQL Server
• 8) What is dirty read in SQL Server
• 9) What are the Serializable isolation level in SQL Server
• 10) What are the Rank functions in SQL server
• 11) What is Replication in SQL Server
• 12) What is the stuff function in SQL Server?
• 13) What is the Difference between Stuff command and Replace command in SQL Server
• 14) What is the merge command in SQL Server?
• 15) What is the Pivot/Unpivot table in SQL Server?
• 16) What is Derived table in SQL Server?
• 17) What is the Output clause in SQL Server?
• 18) What is the temporary tables in SQL Server?
• 19) What are the different types of database in SQL Server?
• 20) What is CTE in SQL Server?
• 21) What are the benefits of using CTE SQL Server
• 22) What are cursors in SQL Server?
• 23) What are Views in SQL Server?
• 24) What are Triggers in SQL Server?
• 25) What are magic tables in SQL Server?
• 26) What are the difference between Stored Procedure and SQL triggers in SQL Server?
• 27) If no rows are affected by the SQL query, will after trigger will execute?
• 28) How can we improve the performance of an stored procedure?
• 29) What are the heap table in SQL Server?
• 30) Where we need to use table variable and where we should use temporary tables?
• 31) What is log shipping in SQL Server?
• 32) What is fragmentation in SQL Server?
• 33) What is the difference between logical and physical fragmentation?
• 34) In which database temporary tables are created?
• 35) What is the difference between Except command and Intersect command?
• 36) What is the BCNF in SQL Server?
• 37) What is database collation?
• 38) Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record set as shown in the below figure.
• 39) Suppose we have to design a database in which employees can work on multiple projects. There are many designation defined in the organization to which each employee can belongs. Example:
  Software engineer, Team lead, Project Manager, Project lead, QC engineer, QC Lead, QC manager etc. An employee can belong to one designation at a time.
• 40) Suppose we have a table named  have only one column say “character name”. It contains 10 rows. First 5 rows contain “Vivek Johari” and the next 5 rows contain “Abhinav Golwalkar” ... write a SQL Query which can return the result in the form Desired Result (alternate names in output).
• 41) Suppose we have a table (Studentid int identity(1,1), Student name nvarchar(150)). Given data includes gaps in Studentid. Write a query which returns the student ids that were 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?
• 5) Have you any experience of DBA activity?
• 6) How big your database size?
• 7) How you optimize database (overview)?
• 8) What best practices you follow in your company?
• 9) Any tools your company uses for database designing?
• 10) Do your company follow Agile methodology?
• 11) 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 (notice period or possibility of early joining)?
• 15) Do you want to ask any question from us?

Question - In which database temporary tables are created?
1) User database (where temporary table are defined)
2) Master database
3) TempDB (Correct Answer)
4) Model Database
5) None of the above

ACID Rules:
This article will tell about the ACID Rules in SQL Server. A:

- (Atomicity) – Atomicity states the principle of All or none. This means that either all the SQL Statements within the transaction will be executed or no SQL statement will…

ACID Rules This article will tell about…