MLStackMLSCCafé
 
 
Sign in with GoogleSign in with Google. Opens in new tab
Master Your ML & AIAI Interview
2103 Curated Machine Learning, Data Science, AI & LLMs Interview Questions
Answered To Get Your Next Six-Figure Job Offer
Top 22 Big-O Notation Interview Questions  Big-O Notation  22  
Top 62 Data Structures Interview Questions  Data Structures  62  
Top 29 Databases Interview Questions  Databases  29  
Top 50 Julia Interview Questions  Julia  50  
Top 59 MATLAB Interview Questions  MATLAB  59  
Top 40 NumPy Interview Questions  NumPy  40  
Top 68 Pandas Interview Questions  Pandas  68  
Top 139 Python Interview Questions  Python  139  
Top 41 R Interview Questions  R  41  
Top 52 SQL Interview Questions  SQL  52  
Top 39 Scala Interview Questions  Scala  39  
Top 24 Searching Interview Questions  Searching  24  
Top 26 Sorting Interview Questions  Sorting  26  
👨‍💻 Having Full-Stack & Coding Interview? Check  FullStack.Cafe - 3877 Full-Stack, Coding & System Design Questions and AnswersHaving Full-Stack & Coding Interview? Check 👨‍💻 FullStack.Cafe - 3877 Full-Stack, Coding & System Design Questions and Answers

Top 29 Databases Interview Questions

Entry Junior Mid Senior Expert
Sign in with GoogleSign in with Google. Opens in new tab
Learning Progress:
Databases Theoretical Questions
Q1:   

What is Normalisation?

  Related To: SQL
Add to PDF   Junior 
Q2:   

What are the advantages of NoSQL over traditional RDBMS?

  Related To: NoSQL
Add to PDF   Junior 
Q3:   

What Is ACID Property Of A System?

  Related To: Software Architecture
 Add to PDF   Mid 
Q4:   

What is Optimistic locking?

  Related To: Entity Framework
 Add to PDF   Mid 
Q5:   

Define ACID Properties

  Related To: SQL
 Add to PDF   Mid 
Q6:   

How a database index can help performance?

  Related To: SQL
 Add to PDF   Mid 
Q7:   

What is Denormalization?

  Related To: SQL
 Add to PDF   Mid 
Q8:   

When should I use a NoSQL database instead of a relational database?

  Related To: NoSQL
 Add to PDF   Mid 
Q9:   

What are the difference between Clustered and a Non-clustered index?

  Related To: SQL
 Add to PDF   Mid 
Q10:   

What's the difference between a Primary Key and a Unique Key?

  Related To: SQL
 Add to PDF   Mid 
Q11:   

When would you use NoSQL?

  Related To: NoSQL
 Add to PDF   Mid 
Q12:   

How do you off load work from the Database?

  Related To: Software Architecture
 Add to PDF   Senior 
Q13:   

What Is Sharding?

  Related To: Software Architecture
 Add to PDF   Senior 
Q14:   

How do you track record relations in NoSQL?

  Related To: NoSQL
 Add to PDF   Senior 
Q15:   

Explain eventual consistency in context of NoSQL

  Related To: NoSQL
 Add to PDF   Senior 
Q16:   

What is the cost of having a database index?

  Related To: SQL
 Add to PDF   Senior 
Q17:   

What Is BASE Property Of A System?

  Related To: Software Architecture, NoSQL
 Add to PDF   Senior 
Q18:   

How does B-trees Index work?

  Related To: SQL
 Add to PDF   Senior 
Q19:   

Explain the difference between Exclusive Lock and Update Lock

  Related To: SQL
 Add to PDF   Senior 
Q20:   

Explain the differences in conceptual data design with NoSQL databases?

  Related To: NoSQL
 Add to PDF   Expert 
Q21:   

Is the C in ACID is not the C in CAP?

  Related To: CAP Theorem, NoSQL
 Add to PDF   Expert 
Q22:   

How do you make schema changes to a live database without downtime?

  Related To: PostgreSQL, MySQL
 Add to PDF   Expert 
Q23:   

Why you should never use GUIDs as part of clustered index?

  Related To: MySQL, PostgreSQL, T-SQL
 Add to PDF   Expert 
Q24:   

What Does Eventually Consistent Mean?

  Related To: Software Architecture
 Add to PDF   Expert 
Q25:   

What is the difference between B-Tree, R-Tree and Hash indexing?

  Related To: SQL
 Add to PDF   Expert 
Q26:   

How does database Indexing work?

  Related To: SQL
 Add to PDF   Expert 
Q27:   

What is Optimistic Locking and Pessimistic Locking?

  Related To: SQL
 Add to PDF   Expert 
Q28:   

Name some disadvantages of a Hash index

  Related To: SQL
 Add to PDF   Expert 
Q29:   

What are some other types of Indexes (vs B-Trees)?

  Related To: SQL
 Add to PDF   Expert 
 
Top 30 OpenClaw Interview Questions  OpenClaw  30  

Prepare for AI developer and engineer interviews with 19 answered OpenClaw questions covering Gateway architecture, channels, agent workspaces, memory, MCP, model failover, multi-agent routing, security, sandboxing, approvals, and remote operations....

Top 32 MCP Interview Questions  MCP  32  

Prepare for AI agent developer interviews with 15 Model Context Protocol (MCP) questions covering tools, resources, prompts, JSON-RPC, transports, roots, sampling, security, and practical MCP server design....

Top 30 AWS Machine Learning Interview Questions  AWS Machine Learning  30  

Amazone runs the internet as we know it. Amazon Web Services (AWS) offers a comprehensive suite of machine learning (ML) services that cater to various needs and expertise levels. Follow along and learn the 23 most common AWS machine-learning intervi...

23 Azure Machine Learning Interview Questions (ANSWERED)
Azure Machine Learning (Azure ML) is a cloud-based service for creating and managing machine learning solutions. It’s designed to scale, distribute, and deploy machine learning models to the cloud. Follow along and learn the 23 most common Azure Mach...
Top 30 Azure ML Interview Questions  Azure ML  30  
27 Hadoop Interview Questions (ANSWERED) For Your Next Big Data and ML Interview
Hadoop is an open-source big data processing framework. It leverages distributed computing to store and process large datasets in a fault-tolerant manner. According to recent reports, Apache Hadoop is one of the most sought-after big data skills with...
Top 32 Hadoop Interview Questions  Hadoop  32  
23 Apache Spark Interview Questions (ANSWERED) To Learn Before ML & Big Data Interview
Apache Spark is a unified analytics engine for large-scale data processing. It is built to handle various use cases in big data analytics, including data processing, machine learning, and graph processing. Follow along and learn the 23 most common an...
Top 30 Apache Spark Interview Questions  Apache Spark  30  
23 Scala Interview Questions (ANSWERED) For Your Next Data Science Interview
Scala is a powerful language with functional programming capabilities that can be a good choice for data science, especially in big data and distributed computing scenarios. As an example, Apache Spark, a popular distributed data processing framework...
Top 39 Scala Interview Questions  Scala  39  
30 PyTorch Interview Questions (ANSWERED) To Beat Your Next Machine Learning Interview
PyTorch popularity as a Deep Learning framework of choice is on the rise. As of December 2022, 62% of the academic papers were implemented in PyTorch whereas only 4% were for TensorFlow. Follow along and prepare effectively with these key 30 PyTorch ...
Top 36 PyTorch Interview Questions  PyTorch  36  
23 Common Artificial Intelligence Interview Questions (SOLVED) For Your Next ML & DS Interview
The use of Artificial Intelligence (AI) in machine learning and data science enabled advancements in areas such as natural language processing, computer vision, recommendation systems, fraud detection, predictive analytics, and personalized medicine....
Top 42 ChatGPT Interview Questions  ChatGPT  42  
Top 18 Machine Learning Interview Questions  Machine Learning  18  
Top 140 Neural Networks Interview Questions  Neural Networks  140  
21 Data Science Optimisation Algorithms Interview Questions (ANSWERED)
Optimization algorithms are extensively used in training machine learning models. Data engineers employ algorithms like gradient descent, stochastic gradient descent, and variants (e.g., Adam, RMSprop) to optimize the model parameters and minimize th...
Top 33 Optimisation Interview Questions  Optimisation  33  

MLStack.Cafe is a biggest hand-picked collection of top Machine Learning, Data Science & Python Interview Questions. Land your next Six-Figure DS job offer in no time.

Coded with 🧡 using React in Australia 🇦🇺

by @aershov24, Full Stack Cafe Pty Ltd 🤙, Est. 2018

Privacy • Terms of Service • Guest Posts • Contacts • FullStack.Cafe

Great    based on 65 Trustpilot  Reviews