All 169 questions

  1. What is database replication?

    Asked in 2 of 612 interviews · last asked Feb 22 · Concept · Junior

    Other ways it was asked
    • “What is database replication, and what is it used for?”
    • “How does database replication work, and what is it used for?”
    • “How does database replication work?”

  2. What first steps would you take on both the database and application sides when migrating from Oracle to PostgreSQL?

    Asked in 2 of 612 interviews · last asked Oct 16 · Scenario · Mid-level

    Other ways it was asked
    • “If I were asked to migrate from Oracle to PostgreSQL, what would I consider first?”
    • “What analysis points would you consider when migrating both the application and database from Oracle to PostgreSQL?”
    • “How would you migrate a database from Oracle to PostgreSQL, and what challenges would you address?”

  3. How would you migrate an on-premises database to SQL Server?

    Asked in 2 of 612 interviews · last asked Aug 21 · Scenario · Mid-level

    Other ways it was asked
    • “If you want to migrate an on-premises application to Azure, how would you do that?”
    • “How would you migrate an on-premises database to Azure SQL?”

  4. On an Oracle RAC cluster, how do you manage service relocation, and what are your best practices for optimization?

    Asked in 2 of 612 interviews · last asked Jul 16 · Tooling · Senior

    Other ways it was asked
    • “How do you relocate a service in an Oracle RAC cluster?”

  5. Which command do we use to create a managed table in Databricks?

    Asked in 2 of 612 interviews · last asked Aug 26 · Tooling · Junior

    Other ways it was asked
    • “How do we create a table in Databricks?”

  6. How would you back up a SQL database table before making changes?

    Asked once · last asked Oct 9 · Tooling · Mid-level

  7. What managed SQL database services are available in AWS, GCP, and Azure, and how do they compare with on-premises SQL Server?

    Asked once · last asked Feb 7 · Concept · Mid-level

  8. How do you manage database migrations in PostgreSQL while ensuring data integrity?

    Asked once · last asked Jun 26 · Scenario · Mid-level

    Other ways it was asked
    • “How can database migrations in PostgreSQL help preserve data integrity? Can you give an example?”

  9. What would you want to understand before migrating R pipelines to dbt or PostgreSQL?

    Asked once · last asked Sep 9 · Scenario · Mid-level

    Other ways it was asked
    • “What would you assess, and what issues would you look for, when migrating R pipelines to dbt or PostgreSQL?”
    • “How would you approach migrating an R data pipeline to PostgreSQL?”

  10. Can you rename a column in a Microsoft Fabric Warehouse using the SQL endpoint?

    Asked once · last asked Sep 16 · Concept · Mid-level

  11. How would you ingest changes from an on-premises SQL Server database, and why choose direct reads or transaction-log CDC?

    Asked once · last asked Sep 16 · Scenario · Senior

    Other ways it was asked
    • “How would you design ingestion from an on-premises SQL Server database, choosing between direct reads and transaction-log CDC?”

  12. How would you create a custom SQL test in dbt?

    Asked once · last asked Sep 20 · Tooling · Mid-level

  13. What is the difference between sharding and partitioning?

    Asked once · last asked Feb 4 · Concept · Mid-level

  14. Can you differentiate between failover clustering, Always On Availability Groups, and log shipping, and explain when to use each?

    Asked once · last asked Feb 7 · Concept · Senior

  15. Does a failover cluster instance (FCI) provide high availability using shared storage, or is there something else involved?

    Asked once · last asked Feb 7 · Concept · Mid-level

    Other ways it was asked
    • “Does an FCI provide high availability using shared storage, or is there something else involved?”

  16. When might you need a read replica in addition to shared storage in a failover cluster?

    Asked once · last asked Feb 7 · Concept · Senior

  17. What is the primary difference between a failover cluster instance and Always On Availability Groups?

    Asked once · last asked Feb 7 · Concept · Mid-level

  18. For five nines of availability, would you choose Always On Availability Groups or a failover cluster instance, and why?

    Asked once · last asked Feb 7 · Scenario · Senior

    Other ways it was asked
    • “From a DBA's perspective, which is easier to maintain: Always On Availability Groups or a failover cluster instance?”

  19. Suppose users report that SQL Server is inaccessible. Where would you start troubleshooting?

    Asked once · last asked Feb 7 · Scenario · Mid-level

  20. How would you approach a database migration, including making schema changes?

    Asked once · last asked Feb 18 · Scenario · Mid-level

  21. What do you know about database replication and sharding?

    Asked once · last asked Feb 22 · Concept · Mid-level

  22. Is database replication the same as creating a backup?

    Asked once · last asked Feb 22 · Concept · Junior

  23. How do you usually approach high availability and disaster recovery for the databases you're responsible for?

    Asked once · last asked Feb 24 · Scenario · Senior

  24. How do you usually set up monitoring and alerts for production databases, and what does that look like in practice?

    Asked once · last asked Feb 24 · Scenario · Senior

  25. What's the hardest database issue you've encountered in production, and how did you resolve it?

    Asked once · last asked Feb 24 · Behavioral · Senior

  26. How would you clean data using bulk SQL queries versus a Python script, and when would you choose each approach?

    Asked once · last asked Mar 6 · Scenario · Mid-level

  27. What tools can be used to back up an Oracle database?

    Asked once · last asked Mar 9 · Tooling · Mid-level

  28. How do you coordinate an Oracle 12c upgrade as part of an SAP Basis role?

    Asked once · last asked Mar 9 · Scenario · Mid-level

  29. How would you design indexing, partitioning, and scaling strategies—such as elastic pools, read replicas, or sharding—to ensure low-latency queries and high throughput for a massive influx of invoice records while maintaining relational integrity?

    Asked once · last asked Mar 9 · Design · Senior

  30. How would you choose a cache and database for a payment-card ordering system?

    Asked once · last asked Mar 16 · Design · Senior

  31. What is the difference between an upsert and CDC?

    Asked once · last asked Mar 20 · Concept · Mid-level

  32. When migrating from Postgres to MySQL, how would you propagate CDC changes to keep the target system in sync?

    Asked once · last asked Mar 20 · Design · Senior

  33. What SQL would you use to apply CDC events from a source such as Kafka to a target table?

    Asked once · last asked Mar 20 · Write code · Senior

  34. When applying CDC changes with a MERGE or upsert, how would you identify which target rows to update?

    Asked once · last asked Mar 20 · Concept · Mid-level

  35. How would you provision a database for a new organization in a multitenant application: manually or with scripts?

    Asked once · last asked Apr 9 · Scenario · Mid-level

  36. What should you consider when performing a Room database migration?

    Asked once · last asked Apr 11 · Scenario · Mid-level

  37. What techniques can you use to scale a database horizontally across multiple machines?

    Asked once · last asked Apr 13 · Design · Senior

  38. A deployment has caused a major outage and needs to be rolled back quickly, but it included database migrations. How would you handle the rollback?

    Asked once · last asked Apr 17 · Scenario · Senior

  39. After a failed production database migration, what technical steps can you take to restore the environment to a working state?

    Asked once · last asked Apr 17 · Scenario · Senior

  40. What would you do if a database could no longer accept additional requests?

    Asked once · last asked Apr 17 · Scenario · Senior

  41. Would database replication be suitable for replicating five-gigabyte objects in an object storage system?

    Asked once · last asked Apr 22 · Design · Senior

  42. How would you create database tables and insert default data in a Laravel, PHP, or Node.js application?

    Asked once · last asked May 5 · Tooling · Junior

  43. When would you use a seeder, and when would you use a migration?

    Asked once · last asked May 5 · Concept · Junior

  44. Where would you place a database, and how would you configure it to perform quickly for users around the world?

    Asked once · last asked May 11 · Design · Senior

  45. How do you manage major database schema changes while preserving backward compatibility?

    Asked once · last asked May 18 · Scenario · Senior

  46. How would you implement data quality checks in PostgreSQL after the data has been loaded?

    Asked once · last asked May 19 · Tooling · Mid-level

  47. How does managing persistence differ between a monolithic architecture and a microservices architecture?

    Asked once · last asked May 22 · Design · Senior

  48. Do you prefer SQL or PySpark, and how do you decide which to use?

    Asked once · last asked Jun 17 · Concept · Mid-level

  49. What are the advantages of Alembic migrations?

    Asked once · last asked Jun 24 · Concept · Mid-level

  50. When you add a new column to a large PostgreSQL table in production, how do you do it to minimize locks and avoid long downtime?

    Asked once · last asked Jul 16 · Scenario · Senior

  51. How would you enforce a NOT NULL constraint on a new PostgreSQL column with minimal impact, and what checks would you run before validating the constraint?

    Asked once · last asked Jul 16 · Scenario · Senior

  52. When reviewing a database migration that adds and backfills a column before enforcing NOT NULL, what correctness or operational risks would you look for, and how would you address them?

    Asked once · last asked Jul 16 · Scenario · Senior

  53. How would you make a database migration that backfills a new column safe under concurrent writes?

    Asked once · last asked Jul 16 · Scenario · Senior

  54. How would you approach a database migration or troubleshoot a complex Kubernetes issue?

    Asked once · last asked Jun 30 · Scenario · Senior

  55. What are the differences and benefits of Apache Iceberg and Hive ACID?

    Asked once · last asked Jul 16 · Concept · Senior

  56. Assume you have to migrate 10 TB of data from Oracle to AWS. How would you do it?

    Asked once · last asked Jul 16 · Scenario · Senior

  57. In RMAN, what is the practical difference between recovery using DUPLICATE and point-in-time recovery (PITR), and when would you use each?

    Asked once · last asked Jul 16 · Concept · Senior

  58. How would you plan and execute a complex database migration, such as moving from Oracle to PostgreSQL?

    Asked once · last asked Jul 16 · Behavioral · Senior

    Other ways it was asked
    • “Describe a complex Oracle-to-PostgreSQL migration you led. How did you plan and execute it?”

  59. What health checks would you perform on an Oracle RAC cluster?

    Asked once · last asked Jul 16 · Scenario · Senior

  60. How do you manage high availability in an Oracle RAC cluster?

    Asked once · last asked Jul 16 · Scenario · Senior

  61. How would you structure an end-to-end Oracle-to-PostgreSQL migration using Ora2Pg, and what pitfalls arise when converting PL/SQL to PL/pgSQL?

    Asked once · last asked Jul 16 · Scenario · Senior

  62. What is Barman, how does it work with PostgreSQL, and how does streaming WAL archiving differ from network-based archiving?

    Asked once · last asked Jul 16 · Tooling · Senior

  63. How does Patroni use a DCS such as Consul or etcd to prevent split-brain?

    Asked once · last asked Jul 16 · Concept · Senior

  64. What is the difference between VACUUM and VACUUM FULL in PostgreSQL?

    Asked once · last asked Jul 18 · Concept · Mid-level

  65. When would you choose pg_dump over pg_basebackup?

    Asked once · last asked Jul 18 · Concept · Mid-level

  66. What would you do if you detected data corruption and needed to restore the database to a point three hours earlier?

    Asked once · last asked Jul 18 · Scenario · Senior

  67. How would you migrate an on-premises Oracle database to Oracle RDS, from planning through completion?

    Asked once · last asked Jul 18 · Scenario · Senior

  68. What are the key differences between PostgreSQL on AWS RDS and a self-managed PostgreSQL database?

    Asked once · last asked Jul 18 · Concept · Mid-level

  69. If you drop a database object in production, how can you recover it?

    Asked once · last asked Jul 20 · Scenario · Senior

  70. Can you explain the HANA persistence layer?

    Asked once · last asked Jul 22 · Concept · Mid-level

  71. What is the difference between a savepoint and a log backup?

    Asked once · last asked Jul 22 · Concept · Mid-level

  72. How would you mitigate a database bottleneck during a sudden 10x traffic spike?

    Asked once · last asked Jul 22 · Scenario · Senior

  73. How would you migrate 500 million or more records without downtime or data loss?

    Asked once · last asked Jul 27 · Design · Senior

  74. When bursts hit one endpoint, for example around 1k RPS, doing Postgres writes, what Node.js and database-side strategies do you use to prevent overload while keeping latency predictable?

    Asked once · last asked Jul 27 · Scenario · Senior

  75. When would you use read replicas, and what problem do they address?

    Asked once · last asked Jul 27 · Concept · Mid-level

  76. What are the caveats of swapping database engines completely?

    Asked once · last asked Jul 27 · Concept · Senior

  77. How would you choose between DynamoDB, Aurora, RDS, or a combination for a transactional workload?

    Asked once · last asked Jul 27 · Scenario · Senior

  78. When performing a data migration for a large-scale system upgrade on a trading platform involving millions of historical transaction records, what is your systematic SQL-based approach?

    Asked once · last asked Jul 28 · Scenario · Senior

  79. Would a 30-day time-to-live policy be appropriate for dropping old data partitions, and what factors would you consider?

    Asked once · last asked Jul 29 · Scenario · Mid-level

  80. How would you approach deploying a full-stack application on Vercel with PostgreSQL for an MVP and later migrating it to a self-managed server?

    Asked once · last asked Jul 31 · Design · Mid-level

  81. What is your normal approach to schema migrations in a CI/CD pipeline, and how do you avoid data loss during deployment?

    Asked once · last asked Aug 4 · Scenario · Senior

  82. If many MySQL connections are open, how do you check which user has active connections?

    Asked once · last asked Aug 11 · Scenario · Mid-level

  83. How would you analyze terabytes of data in an AWS storage bucket, and when would you use SQL?

    Asked once · last asked Aug 12 · Scenario · Senior

  84. Which Python tools can you use to manage database migrations?

    Asked once · last asked Aug 13 · Tooling · Mid-level

  85. If a database backup job reports that transaction logs are not truncating, what would you check in the backup configuration?

    Asked once · last asked Aug 18 · Scenario · Senior

  86. When should an application use separate read and write databases?

    Asked once · last asked Aug 20 · Concept · Senior

  87. What types of database replication are there, and how can changes be transferred between database instances?

    Asked once · last asked Aug 21 · Concept · Mid-level

  88. What's the difference between synchronous and asynchronous replication in detail?

    Asked once · last asked Aug 21 · Concept · Senior

  89. What does pg_dump contain, and what formats can its output use?

    Asked once · last asked Aug 21 · Concept · Mid-level

  90. What methods can you use to create a full PostgreSQL backup besides pg_dump?

    Asked once · last asked Aug 21 · Concept · Mid-level

  91. What information is stored in PostgreSQL's write-ahead log (WAL)?

    Asked once · last asked Aug 21 · Concept · Senior

  92. How can you create a full data backup when the PostgreSQL WAL does not store the full data?

    Asked once · last asked Aug 21 · Concept · Senior

  93. When loading incrementally, how do you prevent duplicate rows if events can arrive late or be replayed? What keys and constraints do you rely on?

    Asked once · last asked Aug 23 · Scenario · Senior

  94. What is a MERGE operation, and when would you use it to load data?

    Asked once · last asked Aug 25 · Concept · Mid-level

  95. What are database schema migrations, and when would you use them?

    Asked once · last asked Dec 9 · Concept · Mid-level

  96. In Databricks, why do we need a storage location for a table when an RDBMS like Oracle handles storage internally?

    Asked once · last asked Aug 26 · Concept · Mid-level

  97. How do you ensure data is accurate and reliable when preparing it for a model using SQL and Python?

    Asked once · last asked Aug 31 · Scenario · Senior

  98. How does Patroni protect PostgreSQL from split-brain during a network failure between the primary and replicas?

    Asked once · last asked Sep 1 · Concept · Senior

  99. How do you migrate from a JSON blob per user to a relational model for analytics?

    Asked once · last asked Sep 3 · Scenario · Senior

  100. How would you migrate data for a live service?

    Asked once · last asked Sep 4 · Scenario · Senior

  101. How can a load balancer be configured to handle both read and write traffic?

    Asked once · last asked Sep 4 · Concept · Mid-level

  102. How do you choose between PySpark and SQL when creating notebooks in Microsoft Fabric?

    Asked once · last asked Sep 9 · Concept · Mid-level

  103. What would you use to find key insights in 5 million records?

    Asked once · last asked Sep 9 · Scenario · Mid-level

  104. How would you bulk-load large amounts of data into Oracle compared with MongoDB?

    Asked once · last asked Sep 9 · Tooling · Mid-level

  105. How would you deploy a Python or Node.js backend with a SQL database on AWS?

    Asked once · last asked Sep 9 · Design · Mid-level

  106. When a BigQuery MERGE statement updates existing records and inserts new ones, does that implement SCD Type 1 or Type 2?

    Asked once · last asked Sep 10 · Concept · Mid-level

  107. For a trading business, is it ideal to run multiple database clusters on a single VM, with a separate database in each cluster, at large scale? If not, what architecture would be more suitable?

    Asked once · last asked Sep 10 · Design · Senior

  108. How would you approach a heavy-load system by choosing between sharding and other options?

    Asked once · last asked Sep 15 · Design · Senior

  109. Can you rename a table in OneLake using the SQL endpoint?

    Asked once · last asked Sep 16 · Concept · Mid-level

  110. How do you rename or drop a column in a Delta Lake table?

    Asked once · last asked Sep 17 · Tooling · Mid-level

  111. How would you design a scalable full-stack application using Next.js or React, Node.js, GraphQL, and PostgreSQL, including caching and database optimization?

    Asked once · last asked Sep 17 · Design · Senior

    Other ways it was asked
    • “Can you design a scalable full-stack application using Next.js or React, Node.js, GraphQL, and PostgreSQL? What would your approach be for caching and database optimization?”

  112. How would you use SQL and pipeline metadata to investigate a data reconciliation difference?

    Asked once · last asked Sep 20 · Scenario · Senior

  113. How would you decide whether multiple databases should share a server or run on separate servers?

    Asked once · last asked Sep 21 · Design · Mid-level

  114. How can three databases share a dedicated server while being organized into separate clusters?

    Asked once · last asked Sep 21 · Design · Senior

  115. How would you scale a database independently, and would you use the same one-master, three-worker architecture for it?

    Asked once · last asked Sep 21 · Design · Senior

  116. How would you address scaling bottlenecks when a relational database such as MySQL or PostgreSQL already has read replicas?

    Asked once · last asked Sep 21 · Scenario · Senior

  117. How would you scale an e-commerce food-ordering system when its database writer is overloaded in production?

    Asked once · last asked Sep 21 · Design · Senior

  118. How would you create incremental dbt models in Snowflake? Write the SQL for them.

    Asked once · last asked Sep 21 · Write code · Mid-level

  119. How would you migrate an on-premises Oracle database, including its data and objects, to Snowflake?

    Asked once · last asked Sep 22 · Design · Senior

  120. How would you manage database schema evolution as features are added and data grows, and what challenges can arise during migrations?

    Asked once · last asked Sep 23 · Scenario · Senior

  121. When would you consider a distributed or sharded database architecture?

    Asked once · last asked Sep 23 · Concept · Senior

  122. How do you handle database scaling when a single table or entity grows rapidly?

    Asked once · last asked Sep 24 · Design · Senior

  123. A table cannot be updated. How would you troubleshoot the problem?

    Asked once · last asked Sep 25 · Scenario · Mid-level

  124. How would you rename a column in a production leads table with 10,000,000 rows without downtime or data loss?

    Asked once · last asked Oct 1 · Scenario · Senior

  125. If records are present in the raw layer but a code change caused an inner join to the region dimension to drop them from the curated dataset, how would you restore the missing data and prevent this from happening again?

    Asked once · last asked Oct 1 · Scenario · Senior

  126. What is the purpose of SQL MERGE logic in a data pipeline, and how would you improve it?

    Asked once · last asked Oct 2 · Scenario · Mid-level

  127. How would you choose a database for a project hosted on Azure while keeping the option to self-host PostgreSQL?

    Asked once · last asked Oct 2 · Design · Senior

  128. What are the advantages and disadvantages of using a managed database instead of hosting and operating one yourself?

    Asked once · last asked Oct 2 · Concept · Mid-level

  129. How do Django migrations work?

    Asked once · last asked Oct 7 · Concept · Mid-level

  130. Where would you obtain PostgreSQL binaries from, and how would you evaluate whether that source is suitable?

    Asked once · last asked Oct 12 · Scenario · Senior

  131. How would you create a workable process for your team to build PostgreSQL 16 binaries on a base operating system?

    Asked once · last asked Oct 12 · Scenario · Senior

  132. How would you use AWS EC2 instances, S3 buckets, and relational databases to improve scalability?

    Asked once · last asked Oct 12 · Behavioral · Mid-level

    Other ways it was asked
    • “How did you leverage AWS EC2 instances, S3 buckets, and relational databases to enhance scalability?”

  133. How can you persist PostgreSQL data in a Docker container so it survives container restarts?

    Asked once · last asked Oct 13 · Scenario · Mid-level

  134. How would you troubleshoot a complex SQL transformation flow in SAP Datasphere when business results are incorrect?

    Asked once · last asked Oct 14 · Scenario · Senior

  135. What challenges arise when creating a reusable AI prompt to support Oracle-to-PostgreSQL migrations across 10 to 15 applications?

    Asked once · last asked Oct 16 · Scenario · Senior

  136. How would you approach database scaling, and what would make you choose read replicas over sharding or vice versa?

    Asked once · last asked Oct 20 · Design · Mid-level

  137. How would you explain replication lag to nontechnical stakeholders in two short paragraphs for an incident update, including impact, risk, and mitigation without jargon?

    Asked once · last asked Oct 20 · Scenario · Mid-level

  138. How would you migrate from MySQL to PostgreSQL and synchronize user data without data loss or downtime?

    Asked once · last asked Oct 22 · Design · Senior

  139. What are the advantages of Amazon Aurora over traditional RDS for MySQL and PostgreSQL?

    Asked once · last asked Oct 22 · Concept · Mid-level

  140. What are Basic and elastic pools in Azure SQL, and how do you configure them?

    Asked once · last asked Jan 8 · Tooling · Mid-level

  141. What are Azure SQL and Azure SQL Managed Instance, and what types are available?

    Asked once · last asked Jan 8 · Concept · Mid-level

  142. How do you plan and execute a database migration?

    Asked once · last asked Jan 8 · Scenario · Mid-level

  143. Tell me about a data analytics project where you used SQL, Tableau, or another tool. What did you use it for, what challenges did you face, and how did you approach the work?

    Asked once · last asked Jan 20 · Behavioral · Junior

  144. How would you automate routine SQL Server maintenance tasks?

    Asked once · last asked Feb 7 · Tooling · Mid-level

    Other ways it was asked
    • “What tools can you use to automate SQL Server maintenance tasks?”

  145. What is the difference between a primary database and a replica?

    Asked once · last asked Jul 18 · Concept · Mid-level

    Other ways it was asked
    • “What is the difference between a primary database and a replica, and how are changes propagated between them?”

  146. What is copied during database replication?

    Asked once · last asked Jan 29 · Concept · Junior

  147. Can database replication copy the schema without copying the data?

    Asked once · last asked Jan 29 · Concept · Junior

  148. Does a failover cluster instance provide read replicas?

    Asked once · last asked Feb 7 · Concept · Mid-level

  149. How do the costs of Always On Availability Groups and failover cluster instances compare?

    Asked once · last asked Feb 7 · Concept · Mid-level

  150. What does Alembic do?

    Asked once · last asked Feb 23 · Tooling · Junior

  151. What does the `php artisan migrate` command do?

    Asked once · last asked Mar 12 · Concept · Junior

  152. What is scaling in a database?

    Asked once · last asked Mar 27 · Concept · Junior

  153. What is phpMyAdmin?

    Asked once · last asked May 13 · Concept · Junior

  154. What mechanism do ORMs provide for managing changes to a database schema?

    Asked once · last asked Aug 5 · Concept · Junior

  155. What are different ways to implement synchronization between database replicas?

    Asked once · last asked Aug 21 · Concept · Mid-level

  156. What types of database backups are there?

    Asked once · last asked Aug 21 · Concept · Junior

  157. What are different ways to create a full database backup?

    Asked once · last asked Aug 21 · Concept · Mid-level

  158. What are the key memory parameters in PostgreSQL?

    Asked once · last asked Aug 30 · Concept · Mid-level

  159. What is maintenance_work_mem in PostgreSQL?

    Asked once · last asked Aug 30 · Concept · Mid-level

  160. Is the database usually the first component of a system to fail?

    Asked once · last asked Sep 2 · Concept · Mid-level

    Other ways it was asked
    • “In your experience, is the database usually the first thing that fails?”

  161. How would you extract and move data from a database?

    Asked once · last asked Sep 3 · Scenario · Mid-level

  162. What data operations can you perform in BigQuery using SQL?

    Asked once · last asked Sep 9 · Concept · Mid-level

  163. What is a Django migration file used for?

    Asked once · last asked Sep 12 · Concept · Junior

  164. How do you use SQL in data engineering?

    Asked once · last asked Sep 17 · Tooling · Mid-level

  165. What database would you choose for an application that needs to scale from 100 users to millions, and why?

    Asked once · last asked Sep 21 · Design · Mid-level

  166. What application changes may be required when migrating a system to Sybase?

    Asked once · last asked Oct 16 · Scenario · Mid-level

  167. What types of migrations are available in SQL Server?

    Asked once · last asked Jan 8 · Concept · Mid-level

  168. What is RDS, and what is it needed for?

    Asked once · last asked Jan 24 · Concept · Junior

  169. What are database migrations?

    Asked once · last asked Oct 23 · Concept · Junior

More SQL interview questions

How this list is made

Every question here was asked by a real interviewer in a real job interview that a candidate ran MeetAssist in. After the call, the interviewer's questions are pulled from the transcript. Practice sessions, tests, exams and anything that was not a job interview are dropped.

Questions are rewritten so they make sense on their own: names of people, employers and clients are removed, and speech-to-text mistakes are fixed. Small talk, logistics and questions about one candidate's own résumé are left out. Rephrasings of the same question are merged, and the count is the number of different interviews it came up in.

The interviews come from candidates who use MeetAssist, so they lean towards software, data and AI roles: the shares describe these interviews, not every SQL interview. Answers to the most asked questions are written and checked by an editor; a "common mistake" is shown only when reviews of real answers in these interviews show it, with the count.

612 interviews, 357 candidates, Nov 2025 to Oct 2026. Updated every month with new interviews.