Have you failed a job interview?
Send us your job interview questions and get correct answers.
Databases job interview questions
What is the purpose of T-SQL?
Databases JuniorExplain how a clustered index works?
DatabasesMS SQL ServerSQL Mid-levelWhat is database normalization and why do we do it?
DatabasesMS SQL ServerSQL Mid-levelDo you have any experience with database modeling?
DatabasesMS SQL ServerSQL Mid-levelWhat first steps would you take to troubleshoot a performance issue?
DatabasesMS SQL ServerSQL Mid-levelWhat versions of SQL Server have you worked with?
DatabasesMS SQL ServerSQL JuniorWhat theoretically performs better, a LEFT OUTER JOIN with IS NULL in the WHERE clause or WHERE EXISTS?
DatabasesMS SQL ServerSQL SeniorWhich high availability technologies have you worked with?
DatabasesMS SQL ServerSQL SeniorWhat is your least favorite part about SSIS?
DatabasesMS SQL ServerSQL SeniorWhat would you consider a good fragmentation percentage to reorganize an index? Rebuild?
DatabasesMS SQL ServerSQL SeniorWhat is Parameter Sniffing?
DatabasesMS SQL ServerSQL SeniorWhat are the differences between Clustered and nonclustered indexes?
DatabasesMS SQL ServerSQL Mid-levelWhat is the index fragmentation?
DatabasesMS SQL ServerSQL SeniorWhat is a View in SQL?
DatabasesMS SQL ServerSQL Mid-levelWhat are the three usual forms of database normalization and why are they important?
DatabasesMS SQL ServerSQL Mid-levelWhere do you start with creating indexes to speed up performance?
DatabasesMS SQL ServerSQL Mid-levelWhat are the INNER, OUTER, LEFT, RIGHT JOINS in SQL?
DatabasesMS SQL ServerSQL Mid-levelWhat do you do to optimize a query's performance in SQL?
DatabasesMS SQL ServerSQL Mid-levelWhat is a foreign key?
DatabasesMS SQL ServerSQL JuniorWhat is a primary key?
DatabasesMS SQL ServerSQL UnknownWhat is the difference between an inner join and outer join?
DatabasesMS SQL ServerSQL Mid-levelWhat is the difference between temp tables and table variables in SQL?
DatabasesMS SQL ServerSQL SeniorWhat is the meaning of ASC and DESC keywords in SQL server?
DatabasesQuality Assurance (QA) JuniorWhat is ORDER BY statement used for in Microsoft SQL server?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorWhat is WHERE statement good for in SQL server script?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorWhat is DISTINCT and what is good for?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorWhat is TOP and what is it good for in SQL server script?
DatabasesQuality Assurance (QA) JuniorUsing SQL query, how do you limit number of returned rows using TOP(x)?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorHow can you select rows from the database table using a script using SELECT?
DatabasesQuality Assurance (QA) JuniorHow do you insert rows using a script using INSERT in SQL?
DatabasesQuality Assurance (QA) JuniorWhat are 3 block notation, 2 block notation, 1 block notation and understand the difference?
DatabasesQuality Assurance (QA) JuniorWhat is a scheme?
DatabasesQuality Assurance (QA) JuniorHow to identify what is a current database in SQL server?
DatabasesQuality Assurance (QA) JuniorUsing Microsoft SQL Server Management Studio, what are the two options for identifying which is the currently selected database?
DatabasesMS SQL ServerQuality Assurance (QA)SQL JuniorUsing Microsoft SQL Server Management Studio, you are executing a query. What are the two options for selecting database against which the query will be executed?
DatabasesMS SQL ServerQuality Assurance (QA)SQL JuniorWhat is SQL query and SQL script?
DatabasesQuality Assurance (QA) JuniorUsing T-SQL script in Microsoft SQL Server database, how do you retrieve and show all rows from the table Customers that have CustomerName starting with 'P'?
DatabasesQuality Assurance (QA) JuniorUsing T-SQL script, how do you retrieve and show 10 rows with the greatest Id from the table in Microsoft SQL Server database?
DatabasesQuality Assurance (QA) JuniorHow do you retrieve and show all rows from the table in Microsoft SQL Server database using T-SQL script?
DatabasesQuality Assurance (QA) JuniorHow do you create table using a designer in Microsoft SQL Server Management Studio (SSMS)?
DatabasesQuality Assurance (QA) JuniorWhat is a difference between in-line and block comments and what is a syntax for each type of comment on Microsoft SQL Server?
DatabasesQuality Assurance (QA) Mid-levelHow would you insert 1000 rows into a table Customers in your Microsoft SQL Server database?
DatabasesQuality Assurance (QA) Mid-levelYou have a table Users in your Microsoft SQL Server database. You generate the script that would re-create the table structure. Could you describe the script and explain what are the individual parts of the script good for/what are they doing?
DatabasesQuality Assurance (QA) Mid-levelYou have a table Users in your Microsoft SQL Server database. How do you generate script that would create the table? To goal is to use the this script to create the empty table Users with the same structure in a different database?
DatabasesQuality Assurance (QA) Mid-levelHow do you retrieve and show all rows from the table in Microsoft SQL Server database using Microsoft SQL Server Management Studio (SSMS)?
DatabasesQuality Assurance (QA) JuniorHow do you create a table in Microsoft SQL Server database?
DatabasesQuality Assurance (QA) JuniorUsing SSMS, where do you find the list of all tables within a database?
DatabasesMS SQL ServerQuality Assurance (QA) JuniorWhere do you find a list of databases on the SQL Server?
DatabasesQuality Assurance (QA) JuniorWhat is a data type?
DatabasesQuality Assurance (QA) JuniorDo you know what is a database, table and what is the difference between them?
DatabasesQuality Assurance (QA) JuniorHow do you create a new database using SSMS?
DatabasesQuality Assurance (QA) JuniorWhat is Microsoft SQL Server?
DatabasesQuality Assurance (QA) JuniorWhat do you know about Windows authentication and Sql server authentication?
DatabasesQuality Assurance (QA) JuniorWhat is localhost?
DatabasesQuality Assurance (QA) JuniorWhat is Microsoft SQL Server instance?
DatabasesQuality Assurance (QA) Mid-levelHow do you connect to SQL server instance and disconnect from SQL server instance?
DatabasesQuality Assurance (QA) JuniorHow would you install Microsoft SQL Server Management Studio?
DatabasesQuality Assurance (QA) JuniorHow would you run SSMS (Microsoft SQL Server Management Studio)?
DatabasesQuality Assurance (QA) JuniorWhat is SSMS?
DatabasesQuality Assurance (QA) JuniorWhat is Microsoft SQL Server Management Studio and what is it good for?
DatabasesQuality Assurance (QA) JuniorWhat is a difference between DROP TABLE and TRUNCATE TABLE and DELETE FROM?
Databases Mid-levelWhat will be the result of the following T-SQL?
Code challengeDatabasesMS SQL ServerSQL SeniorWhat is the difference between OLAP and OLTP? When is each used?
Databases Mid-levelDescribe the difference between optimistic and pessimistic locking.
Databases Mid-levelIn databases, what is the difference between a delete statement and a truncate statement?
Databases Mid-levelWhat are transaction logs, and how are they used?
Databases Mid-levelWhat are the most important database performance metrics, and how do you monitor them?
Databases Mid-levelHow would you store 1 million phone numbers?
Data StructuresDatabases JuniorDescribe and tell the difference amongst table, view and materialized view.
Databases Mid-levelCan you use different column names for tables merged using UNION ALL? What will be the column names in the result?
DatabasesSQL Mid-levelWhat is the difference between UNION and UNION ALL?
DatabasesSQL Mid-levelWhat is the processing order of logical parts of the following query?
DatabasesSQL Mid-levelWhen you use SQL Server, what is a difference between local and global temporary table?
DatabasesMS SQL ServerSQL SeniorWhat is a result of the query below for table with 10 rows when there are 2 clients with the headcount column having a NULL value, there are 7 customers with 1 head and 1 customer with 2 heads?
DatabasesSQL Mid-levelWhat is a result of the following query for table with 10 rows when there are 2 clients with the name column having a NULL value?
DatabasesSQL Mid-levelWhat is a result of SELECT COUNT(*)?
DatabasesSQL Senior
Are you wondering what questions will you get asked on your job interview?
Do you have a Job Ad URL address ? Then we will predict the questions for you...
- Share the question, get the right answerSubmit the question you have been asked by a recruiter. We will give you the right answer.
Recently added questions
- Using Entity Framework Core, how do you define which tables should be eager loaded?
- What is Cartesian Explosion in Entity Framework?
- What is N+1 query problem in Entity Framework and how to fix it?
- What is query splitting in Entity Framework and why would you use it?
- What is JWT and how do you use it?
- Do you use your Entity Framework models in API controllers?
- What are POCO classes in Entity Framework?
- Why would you recommend a company to use Entity Framework?
- What Entity Framework versions did you use?
- What is a server evaluation and client evaluation in Entity Framework and why should you know about it?
- Using Entity Framework, how do you check if a row exists in a database?
- How do you handle SQL injection attacks in Entity Framework?
- When are queries executed when you use Entity Framework?
- Which types of loading do you know and which type of loading is good in which scenario in Entity Framework?
- Using Entity Framework, when will you prefer to use Code First and when Database First approach? Why?
- What is a difference between Database First and Code First approach in Entity Framework?
- What is the use of .AsNoTracking() method?
- What is Code First approach in Entity Framework?
- Using Entity Framework, how can you disable an object property from being mapped to a database entity column?
- What happens when you insert multiple rows using Entity Framework?
No Comments Yet.
Be the first to tell us what you think.
Be the first to tell us what you think.