Databases job interview questions

QUESTION 1:

What is the purpose of T-SQL?

Databases Junior

QUESTION 2:

Explain how a clustered index works?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 3:

What is database normalization and why do we do it?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 4:

Do you have any experience with database modeling?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 5:

What first steps would you take to troubleshoot a performance issue?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 6:

What versions of SQL Server have you worked with?

DatabasesMS SQL ServerSQL Junior

QUESTION 7:

What theoretically performs better, a LEFT OUTER JOIN with IS NULL in the WHERE clause or WHERE EXISTS?

DatabasesMS SQL ServerSQL Senior

QUESTION 8:

Which high availability technologies have you worked with?

DatabasesMS SQL ServerSQL Senior

QUESTION 9:

What is your least favorite part about SSIS?

DatabasesMS SQL ServerSQL Senior

QUESTION 10:

What would you consider a good fragmentation percentage to reorganize an index? Rebuild?

DatabasesMS SQL ServerSQL Senior

QUESTION 11:

What is Parameter Sniffing?

DatabasesMS SQL ServerSQL Senior

QUESTION 12:

What are the differences between Clustered and nonclustered indexes?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 13:

What is the index fragmentation?

DatabasesMS SQL ServerSQL Senior

QUESTION 14:

What is a View in SQL?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 15:

What are the three usual forms of database normalization and why are they important?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 16:

Where do you start with creating indexes to speed up performance?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 17:

What are the INNER, OUTER, LEFT, RIGHT JOINS in SQL?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 18:

What do you do to optimize a query's performance in SQL?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 19:

What is a foreign key?

DatabasesMS SQL ServerSQL Junior

QUESTION 20:

What is a primary key?

DatabasesMS SQL ServerSQL Unknown

QUESTION 21:

What is the difference between an inner join and outer join?

DatabasesMS SQL ServerSQL Mid-level

QUESTION 22:

What is the difference between temp tables and table variables in SQL?

DatabasesMS SQL ServerSQL Senior

QUESTION 23:

What is the meaning of ASC and DESC keywords in SQL server?

DatabasesQuality Assurance (QA) Junior

QUESTION 24:

What is ORDER BY statement used for in Microsoft SQL server?

DatabasesMS SQL ServerQuality Assurance (QA) Junior

QUESTION 25:

What is WHERE statement good for in SQL server script?

DatabasesMS SQL ServerQuality Assurance (QA) Junior

QUESTION 26:

What is DISTINCT and what is good for?

DatabasesMS SQL ServerQuality Assurance (QA) Junior

QUESTION 27:

What is TOP and what is it good for in SQL server script?

DatabasesQuality Assurance (QA) Junior

QUESTION 28:

Using SQL query, how do you limit number of returned rows using TOP(x)?

DatabasesMS SQL ServerQuality Assurance (QA) Junior

QUESTION 29:

How can you select rows from the database table using a script using SELECT?

DatabasesQuality Assurance (QA) Junior

QUESTION 30:

How do you insert rows using a script using INSERT in SQL?

DatabasesQuality Assurance (QA) Junior

QUESTION 31:

What are 3 block notation, 2 block notation, 1 block notation and understand the difference?

DatabasesQuality Assurance (QA) Junior

QUESTION 32:

What is a scheme?

DatabasesQuality Assurance (QA) Junior

QUESTION 33:

How to identify what is a current database in SQL server?

DatabasesQuality Assurance (QA) Junior

QUESTION 34:

Using Microsoft SQL Server Management Studio, what are the two options for identifying which is the currently selected database?

DatabasesMS SQL ServerQuality Assurance (QA)SQL Junior

QUESTION 35:

Using 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 Junior

QUESTION 36:

What is SQL query and SQL script?

DatabasesQuality Assurance (QA) Junior

QUESTION 37:

Using 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) Junior

QUESTION 38:

Using 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) Junior

QUESTION 39:

How do you retrieve and show all rows from the table in Microsoft SQL Server database using T-SQL script?

DatabasesQuality Assurance (QA) Junior

QUESTION 40:

How do you create table using a designer in Microsoft SQL Server Management Studio (SSMS)?

DatabasesQuality Assurance (QA) Junior

QUESTION 41:

What 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-level

QUESTION 42:

How would you insert 1000 rows into a table Customers in your Microsoft SQL Server database?

DatabasesQuality Assurance (QA) Mid-level

QUESTION 43:

You 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-level

QUESTION 44:

You 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-level

QUESTION 45:

How 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) Junior

QUESTION 46:

How do you create a table in Microsoft SQL Server database?

DatabasesQuality Assurance (QA) Junior

QUESTION 47:

Using SSMS, where do you find the list of all tables within a database?

DatabasesMS SQL ServerQuality Assurance (QA) Junior

QUESTION 48:

Where do you find a list of databases on the SQL Server?

DatabasesQuality Assurance (QA) Junior

QUESTION 49:

What is a data type?

DatabasesQuality Assurance (QA) Junior

QUESTION 50:

Do you know what is a database, table and what is the difference between them?

DatabasesQuality Assurance (QA) Junior

QUESTION 51:

How do you create a new database using SSMS?

DatabasesQuality Assurance (QA) Junior

QUESTION 52:

What is Microsoft SQL Server?

DatabasesQuality Assurance (QA) Junior

QUESTION 53:

What do you know about Windows authentication and Sql server authentication?

DatabasesQuality Assurance (QA) Junior

QUESTION 54:

What is localhost?

DatabasesQuality Assurance (QA) Junior

QUESTION 55:

What is Microsoft SQL Server instance?

DatabasesQuality Assurance (QA) Mid-level

QUESTION 56:

How do you connect to SQL server instance and disconnect from SQL server instance?

DatabasesQuality Assurance (QA) Junior

QUESTION 57:

How would you install Microsoft SQL Server Management Studio?

DatabasesQuality Assurance (QA) Junior

QUESTION 58:

How would you run SSMS (Microsoft SQL Server Management Studio)?

DatabasesQuality Assurance (QA) Junior

QUESTION 59:

What is SSMS?

DatabasesQuality Assurance (QA) Junior

QUESTION 60:

What is Microsoft SQL Server Management Studio and what is it good for?

DatabasesQuality Assurance (QA) Junior

QUESTION 61:

What is a difference between DROP TABLE and TRUNCATE TABLE and DELETE FROM?

Databases Mid-level

QUESTION 62:

What will be the result of the following T-SQL?

Code challengeDatabasesMS SQL ServerSQL Senior

QUESTION 63:

What is the difference between OLAP and OLTP? When is each used?

Databases Mid-level

QUESTION 64:

Describe the difference between optimistic and pessimistic locking.

Databases Mid-level

QUESTION 65:

In databases, what is the difference between a delete statement and a truncate statement?

Databases Mid-level

QUESTION 66:

What are transaction logs, and how are they used?

Databases Mid-level

QUESTION 67:

What are the most important database performance metrics, and how do you monitor them?

Databases Mid-level

QUESTION 68:

How would you store 1 million phone numbers?

Data StructuresDatabases Junior

QUESTION 69:

Describe and tell the difference amongst table, view and materialized view.

Databases Mid-level

QUESTION 70:

Can you use different column names for tables merged using UNION ALL? What will be the column names in the result?

DatabasesSQL Mid-level

QUESTION 71:

What is the difference between UNION and UNION ALL?

DatabasesSQL Mid-level

QUESTION 72:

What is the processing order of logical parts of the following query?

DatabasesSQL Mid-level

QUESTION 73:

When you use SQL Server, what is a difference between local and global temporary table?

DatabasesMS SQL ServerSQL Senior

QUESTION 74:

What 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-level

QUESTION 75:

What 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-level

QUESTION 76:

What is a result of SELECT COUNT(*)?

DatabasesSQL Senior

Get questions by Job Ad URL Get questions by Job Ad Text

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...

Get questions by Job Ad URL

Share the question, get the right answer
Submit the question you have been asked by a recruiter. We will give you the right answer.
Add a question

Recently added questions

Anonymous
test

Anonymous
e

Anonymous
Superrr

Anonymous
wup

Anonymous
🔥

Anonymous
nm

Anonymous
x

Anonymous
good

Anonymous
good

esmhli
hm

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e

LaceJaguar65
e