{"id":5930,"date":"2025-03-10T07:18:25","date_gmt":"2025-03-10T07:18:25","guid":{"rendered":"https:\/\/www.hirist.tech\/blog\/?p=5930"},"modified":"2025-12-29T10:51:21","modified_gmt":"2025-12-29T10:51:21","slug":"top-45-database-testing-interview-questions-and-answers","status":"publish","type":"post","link":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/","title":{"rendered":"Top 45+ Database Testing Interview Questions and Answers"},"content":{"rendered":"\n<p>Finding database testing interview questions tricky? You are not alone\u2014many candidates struggle with data integrity, SQL queries, and performance issues. This guide simplifies your preparation with 45+ common questions and clear answers.<\/p>\n\n\n\n<p>It will help you stay ahead and answer with confidence.<\/p>\n\n\n\n<p><strong>Fun Fact:<\/strong> In India, database testers with 1 to 7 years of experience earn between \u20b91.8 lakh and \u20b99.6 lakh per year.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_Freshers\" title=\"Database Testing Interview Questions for Freshers&nbsp;\">Database Testing Interview Questions for Freshers&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_Experienced_Candidates\" title=\"Database Testing Interview Questions for Experienced Candidates&nbsp;\">Database Testing Interview Questions for Experienced Candidates&nbsp;<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_2_Years_Experience\" title=\"Database Testing Interview Questions for 2 Years\u2019 Experience\">Database Testing Interview Questions for 2 Years\u2019 Experience<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_3_Years_Experience\" title=\"Database Testing Interview Questions for 3 Years\u2019 Experience\">Database Testing Interview Questions for 3 Years\u2019 Experience<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_4_Years_Experience\" title=\"Database Testing Interview Questions for 4 Years\u2019 Experience\">Database Testing Interview Questions for 4 Years\u2019 Experience<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_5_Years_Experience\" title=\"Database Testing Interview Questions for 5 Years\u2019 Experience\">Database Testing Interview Questions for 5 Years\u2019 Experience<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_for_6_Years_Experience\" title=\"Database Testing Interview Questions for 6 Years\u2019 Experience\">Database Testing Interview Questions for 6 Years\u2019 Experience<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Advanced_Database_Interview_Questions_for_Testing\" title=\"Advanced Database Interview Questions for Testing\">Advanced Database Interview Questions for Testing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#SQL_Database_Testing_Interview_Questions\" title=\"SQL Database Testing Interview Questions\">SQL Database Testing Interview Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Basic_SQL_Queries_Interview_Questions_for_Testers\" title=\"Basic SQL Queries Interview Questions for Testers\">Basic SQL Queries Interview Questions for Testers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#SQL_Queries_for_Testing_Interview_for_Experienced_Candidates\" title=\"SQL Queries for Testing Interview for Experienced Candidates&nbsp;\">SQL Queries for Testing Interview for Experienced Candidates&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Manual_Testing_SQL_Interview_Questions\" title=\"Manual Testing SQL Interview Questions\">Manual Testing SQL Interview Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Manual_Testing_Interview_Questions\" title=\"Database Manual Testing Interview Questions\">Database Manual Testing Interview Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Data_Warehouse_ETL_Testing_Interview_Questions\" title=\"Data Warehouse ETL Testing Interview Questions\">Data Warehouse ETL Testing Interview Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Company-Specific_Database_Testing_Interview_Questions\" title=\"Company-Specific Database Testing Interview Questions\">Company-Specific Database Testing Interview Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Database_Testing_Interview_Questions_in_Capgemini\" title=\"Database Testing Interview Questions in Capgemini\">Database Testing Interview Questions in Capgemini<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Oracle_Testing_Interview_Questions\" title=\"Oracle Testing Interview Questions\">Oracle Testing Interview Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Cognizant_Database_Testing_Interview_Questions\" title=\"Cognizant Database Testing Interview Questions\">Cognizant Database Testing Interview Questions<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#Wrapping_Up\" title=\"Wrapping Up\">Wrapping Up<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_Freshers\"><\/span>Database Testing Interview Questions for Freshers&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a list of common DB testing interview questions and answers for freshers:&nbsp;<\/p>\n\n\n\n<ol>\n<li><strong>What is database testing, and why is it important?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Database testing checks the accuracy, consistency, and reliability of stored data. It helps identify issues like data corruption, incorrect transactions, and performance bottlenecks. Without proper testing, applications can break, leading to incorrect data processing and security risks.<\/p>\n\n\n\n<ol start=\"2\">\n<li><strong>What are the key components of database testing?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>This is one of the most common database testing questions.<\/p>\n\n\n\n<p>Database testing covers:<\/p>\n\n\n\n<ul>\n<li><strong>Schema testing<\/strong> \u2013 Validates table structures, column constraints, and relationships.<\/li>\n\n\n\n<li><strong>Data integrity testing<\/strong> \u2013 Checks if data remains consistent after CRUD operations.<\/li>\n\n\n\n<li><strong>Transaction testing<\/strong> \u2013 Verifies rollback and commit functionalities.<\/li>\n\n\n\n<li><strong>Performance testing<\/strong> \u2013 Assesses query execution time and indexing efficiency.<\/li>\n\n\n\n<li><strong>Security testing<\/strong> \u2013 Tests access controls and data encryption.<\/li>\n<\/ul>\n\n\n\n<ol start=\"3\">\n<li><strong>How do you validate data consistency in a database?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI compare the source and target data using SQL queries, checking for mismatches. Foreign key constraints help maintain consistency across tables. Running reconciliation scripts after transactions helps spot anomalies. In automated testing, tools like QuerySurge and DbFit assist in detecting inconsistencies.\u201d<\/em><\/p>\n\n\n\n<ol start=\"4\">\n<li><strong>What is the difference between functional and non-functional database testing?<\/strong><\/li>\n<\/ol>\n\n\n\n<ul>\n<li><strong>Functional testing<\/strong> checks CRUD operations, triggers, and stored procedures for correctness.<\/li>\n\n\n\n<li><strong>Non-functional testing<\/strong> focuses on performance, scalability, and security, such as query optimization and load testing.<\/li>\n<\/ul>\n\n\n\n<ol start=\"5\">\n<li><strong>Can you explain the ACID properties of a database?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>ACID stands for:<\/p>\n\n\n\n<ul>\n<li><strong>Atomicity<\/strong> \u2013 A transaction is all or nothing; if one part fails, the entire transaction rolls back.<\/li>\n\n\n\n<li><strong>Consistency<\/strong> \u2013 The database remains valid before and after a transaction.<\/li>\n\n\n\n<li><strong>Isolation<\/strong> \u2013 Transactions do not interfere with each other.<\/li>\n\n\n\n<li><strong>Durability<\/strong> \u2013 Committed transactions remain in the database even after a system failure.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong>Also Read - <a href=\"https:\/\/www.hirist.tech\/blog\/top-45-functional-testing-interview-questions-and-answers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 45+ Functional Testing Interview Questions and Answers<\/a><\/strong><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_Experienced_Candidates\"><\/span>Database Testing Interview Questions for Experienced Candidates&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here are some common data base testing interview questions for experienced candidates:&nbsp;<\/p>\n\n\n\n<ol start=\"6\">\n<li><strong>How do you test database triggers and stored procedures?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI execute stored procedures with different input values to verify correctness. For triggers, I perform related CRUD operations to check if they execute as expected. Debugging tools like SQL Profiler help trace execution. I also compare expected vs. actual data states after execution.\u201d<\/em><\/p>\n\n\n\n<ol start=\"7\">\n<li><strong>What challenges have you faced while testing databases, and how did you solve them?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cOne major challenge was handling large datasets during performance testing. Queries that worked well on small datasets slowed down with millions of records. I optimized indexes, rewrote inefficient queries, and used partitioning to improve performance. Another issue was missing referential integrity, which I fixed by enforcing foreign key constraints.\u201d<\/em><\/p>\n\n\n\n<ol start=\"8\">\n<li><strong>How do you check for data integrity issues in a large database?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI write SQL queries to compare source and target tables. Using checksum functions helps detect data corruption. I also verify constraints like unique keys and foreign key relationships. Running automated reconciliation scripts ensures that large-scale data updates do not introduce errors.\u201d<\/em><\/p>\n\n\n\n<ol start=\"9\">\n<li><strong>Explain different types of database indexes and their impact on performance.<\/strong><\/li>\n<\/ol>\n\n\n\n<ul>\n<li><strong>Clustered Index<\/strong> \u2013 Sorts and stores rows physically in order; improves range queries.<\/li>\n\n\n\n<li><strong>Non-Clustered Index<\/strong> \u2013 Maintains a separate structure pointing to data; speeds up lookups.<\/li>\n\n\n\n<li><strong>Unique Index<\/strong> \u2013 Prevents duplicate values in a column.<\/li>\n\n\n\n<li><strong>Full-Text Index<\/strong> \u2013 Optimizes searches in text-based columns.<br>Indexes improve read performance but slow down inserts and updates due to maintenance overhead.<\/li>\n<\/ul>\n\n\n\n<ol start=\"10\">\n<li><strong>How would you test a database migration?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI start by comparing schema structures between old and new databases. Then, I validate data consistency using row counts and checksum functions. Running sample queries ensures that relationships and indexes work correctly. Finally, I perform load testing to confirm the new database handles expected traffic.\u201d<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_2_Years_Experience\"><\/span>Database Testing Interview Questions for 2 Years\u2019 Experience<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol start=\"11\">\n<li>Can you describe a situation where you found a critical database bug?<\/li>\n\n\n\n<li>How do you approach debugging a failed SQL query?<\/li>\n\n\n\n<li>What is the difference between database normalization and denormalization?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_3_Years_Experience\"><\/span>Database Testing Interview Questions for 3 Years\u2019 Experience<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol start=\"14\">\n<li>Have you ever optimized a slow-running query? How?<\/li>\n\n\n\n<li>How do you handle test cases when working with large datasets?<\/li>\n\n\n\n<li>What are the different types of database locks?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_4_Years_Experience\"><\/span>Database Testing Interview Questions for 4 Years\u2019 Experience<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol start=\"17\">\n<li>Describe a complex database testing project you worked on.<\/li>\n\n\n\n<li>How do you handle database performance testing in an enterprise environment?<\/li>\n\n\n\n<li>What is the role of indexing in database testing?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_5_Years_Experience\"><\/span>Database Testing Interview Questions for 5 Years\u2019 Experience<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol start=\"20\">\n<li>What\u2019s the most challenging database issue you have resolved?<\/li>\n\n\n\n<li>How do you prioritize database test cases in an Agile environment?<\/li>\n\n\n\n<li>What is the difference between a clustered and non-clustered index?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_for_6_Years_Experience\"><\/span>Database Testing Interview Questions for 6 Years\u2019 Experience<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol start=\"23\">\n<li>Have you ever had to validate data across multiple databases? How did you do it?<\/li>\n\n\n\n<li>How do you handle security testing in databases?<\/li>\n\n\n\n<li>What are database partitioning and sharding, and when should they be used?<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-verse\"><strong>Also Read - <a href=\"https:\/\/www.hirist.tech\/blog\/top-25-performance-testing-interview-questions-and-answers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 25+ Performance Testing Interview Questions and Answers<\/a><\/strong><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Advanced_Database_Interview_Questions_for_Testing\"><\/span>Advanced Database Interview Questions for Testing<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let\u2019s go through some advanced DB testing interview questions and answers:&nbsp;<\/p>\n\n\n\n<ol start=\"26\">\n<li><strong>How do you identify and resolve deadlocks in a database?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cDeadlocks happen when two transactions hold locks that block each other. To identify them, I check database logs and use system views like sys.dm_tran_locks in SQL Server or SHOW ENGINE INNODB STATUS in MySQL. To resolve deadlocks, I prioritize transactions using timeout settings, redesign queries to access tables in the same order, and use indexing to speed up execution.\u201d<\/em><\/p>\n\n\n\n<ol start=\"27\">\n<li><strong>What techniques can be used to test database replication?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI compare data between source and replica databases using checksum functions. Running parallel queries on both helps spot inconsistencies. I also simulate network failures to see if replication resumes correctly. Monitoring tools like Oracle GoldenGate or MySQL Replication Status help track delays and conflicts.\u201d<\/em><\/p>\n\n\n\n<ol start=\"28\">\n<li><strong>How do you test database failover and recovery mechanisms?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI simulate server failures by shutting down the primary node and monitoring if the secondary node takes over. After failover, I validate data integrity by running queries on the new primary. To test recovery, I restore a backup and compare it with the original database to confirm completeness.\u201d<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQL_Database_Testing_Interview_Questions\"><\/span>SQL Database Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here are some common SQL testing interview questions and answers:<\/p>\n\n\n\n<ol start=\"29\">\n<li><strong>How do you validate database constraints using SQL queries?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>This is one of the most important interview questions for SQL testing.<\/p>\n\n\n\n<p><em>\u201cI use CHECK, FOREIGN KEY, and UNIQUE constraints in queries. For example, to check a foreign key constraint, I run:<\/em><\/p>\n\n\n\n<p>SELECT * FROM child_table c&nbsp;<\/p>\n\n\n\n<p>WHERE NOT EXISTS (SELECT 1 FROM parent_table p WHERE p.id = c.parent_id);<\/p>\n\n\n\n<p><em>If rows are returned, the constraint is not enforced correctly.\u201d<\/em><\/p>\n\n\n\n<ol start=\"30\">\n<li><strong>How do you test database transactions and rollbacks?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI start a transaction, perform updates, and then roll back to see if data reverts.&nbsp;<\/em><\/p>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<p>BEGIN TRANSACTION;<\/p>\n\n\n\n<p>UPDATE employees SET salary = salary + 5000 WHERE id = 101;<\/p>\n\n\n\n<p>ROLLBACK;<\/p>\n\n\n\n<p>SELECT * FROM employees WHERE id = 101;<\/p>\n\n\n\n<p><em>The salary should remain unchanged if rollback works correctly.\u201d<\/em><\/p>\n\n\n\n<ol start=\"31\">\n<li><strong>What SQL commands are used for data validation in testing?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Common commands include:<\/p>\n\n\n\n<ul>\n<li>COUNT(*) \u2013 Verifies record count.<\/li>\n\n\n\n<li>SUM(column_name) \u2013 Checks totals for consistency.<\/li>\n\n\n\n<li>GROUP BY \u2013 Identifies duplicate or missing values.<\/li>\n\n\n\n<li>EXCEPT or MINUS \u2013 Compares data across tables.<\/li>\n<\/ul>\n\n\n\n<p><strong>Note:<\/strong> SQL tests are commonly included in database testing interviews to assess query writing, optimization, and data validation skills.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Basic_SQL_Queries_Interview_Questions_for_Testers\"><\/span>Basic SQL Queries Interview Questions for Testers<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>These are basic SQL Query interview questions and answers for testers:&nbsp;<\/p>\n\n\n\n<ol start=\"32\">\n<li><strong>Write an SQL query to fetch the second-highest salary from an Employee table.<\/strong><\/li>\n<\/ol>\n\n\n\n<p>SELECT DISTINCT salary&nbsp;<\/p>\n\n\n\n<p>FROM employees&nbsp;<\/p>\n\n\n\n<p>ORDER BY salary DESC&nbsp;<\/p>\n\n\n\n<p>LIMIT 1 OFFSET 1;<\/p>\n\n\n\n<ol start=\"33\">\n<li><strong>How do you retrieve duplicate records from a table?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>SELECT column_name, COUNT(*)&nbsp;<\/p>\n\n\n\n<p>FROM table_name&nbsp;<\/p>\n\n\n\n<p>GROUP BY column_name&nbsp;<\/p>\n\n\n\n<p>HAVING COUNT(*) &gt; 1;<\/p>\n\n\n\n<ol start=\"34\">\n<li><strong>What is the difference between INNER JOIN and LEFT JOIN?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>This is one of the most common interview questions for SQL Queries for testers.&nbsp;<\/p>\n\n\n\n<ul>\n<li><strong>INNER JOIN<\/strong> returns only matching rows between tables.<\/li>\n\n\n\n<li><strong>LEFT JOIN<\/strong> returns all rows from the left table and matching rows from the right. Unmatched rows have NULL values.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-verse\"><strong>Also Read - <a href=\"https:\/\/www.hirist.tech\/blog\/top-100-sql-query-interview-questions-and-answers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 100 SQL Query Interview Questions and Answers<\/a><\/strong><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SQL_Queries_for_Testing_Interview_for_Experienced_Candidates\"><\/span>SQL Queries for Testing Interview for Experienced Candidates&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let\u2019s go through some SQL Query interview questions and answers for experienced testers:<\/p>\n\n\n\n<ol start=\"35\">\n<li><strong>Write an SQL query to find employees who earn more than their department\u2019s average salary.<\/strong><\/li>\n<\/ol>\n\n\n\n<p>SELECT e.name, e.salary, e.department_id<\/p>\n\n\n\n<p>FROM employees e<\/p>\n\n\n\n<p>WHERE e.salary &gt; (SELECT AVG(salary) FROM employees WHERE department_id = e.department_id);<\/p>\n\n\n\n<ol start=\"36\">\n<li><strong>How do you test data retrieval performance in SQL?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI analyze execution plans using EXPLAIN in MySQL or SET STATISTICS IO ON in SQL Server. Indexing and query optimization, like reducing SELECT *, help improve performance.\u201d<\/em><\/p>\n\n\n\n<ol start=\"37\">\n<li><strong>How do you fetch the last five records from a table?<\/strong><\/li>\n<\/ol>\n\n\n\n<p>You might also come across SQL questions for testers like this one.&nbsp;<\/p>\n\n\n\n<p>SELECT * FROM employees&nbsp;<\/p>\n\n\n\n<p>ORDER BY id DESC&nbsp;<\/p>\n\n\n\n<p>LIMIT 5;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Manual_Testing_SQL_Interview_Questions\"><\/span>Manual Testing SQL Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a list of manual testing and SQL interview questions and answers:<\/p>\n\n\n\n<ol start=\"38\">\n<li><strong>How do you manually validate data after an ETL process?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI compare source and target record counts and check key columns for mismatches. Running queries with EXCEPT or MINUS helps find missing or extra records.\u201d<\/em><\/p>\n\n\n\n<ol start=\"39\">\n<li><strong>What techniques do you use to test stored procedures manually?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI execute stored procedures with different inputs and validate the output. Using PRINT statements in SQL Server or DBMS_OUTPUT.PUT_LINE in Oracle helps debug.\u201d<\/em><\/p>\n\n\n\n<ol start=\"40\">\n<li><strong>How do you verify database constraints without using automation tools?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI insert invalid data manually and check if constraints prevent it. For example, I try adding a duplicate value in a column with a unique constraint to see if it gets rejected.\u201d<\/em><\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong>Also Read - <a href=\"https:\/\/www.hirist.tech\/blog\/top-75-manual-testing-interview-questions-and-answers\/\" target=\"_blank\" rel=\"noreferrer noopener\">Top 75+ Manual Testing Interview Questions and Answers<\/a><\/strong><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Manual_Testing_Interview_Questions\"><\/span>Database Manual Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a list of common database manual testing interview questions and answers:&nbsp;<\/p>\n\n\n\n<ol start=\"41\">\n<li><strong>How do you test database schema changes in a manual testing environment?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI compare old and new schemas using INFORMATION_SCHEMA or schema comparison tools. Running regression tests on critical queries helps detect issues.\u201d<\/em><\/p>\n\n\n\n<ol start=\"42\">\n<li><strong>What steps do you follow to verify data consistency across different tables?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI use JOIN queries to check referential integrity. Aggregation checks, like comparing sum totals across related tables, also help confirm consistency.\u201d<\/em><\/p>\n\n\n\n<ol start=\"43\">\n<li><strong>How do you manually check database triggers and their impact?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI perform related operations and verify if the trigger executes correctly. Checking system logs and auditing tables helps track unexpected behaviour.\u201d<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Warehouse_ETL_Testing_Interview_Questions\"><\/span>Data Warehouse ETL Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol start=\"44\">\n<li><strong>How do you validate data transformation rules in ETL testing?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI create SQL queries to compare transformed data against expected results. Using CASE statements helps validate transformation logic in the database.\u201d<\/em><\/p>\n\n\n\n<ol start=\"45\">\n<li><strong>How do you test ETL performance for large datasets?<\/strong><\/li>\n<\/ol>\n\n\n\n<p><em>\u201cI analyze execution time for different batch sizes. Indexing, partitioning, and parallel processing help optimize ETL performance.\u201d<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Company-Specific_Database_Testing_Interview_Questions\"><\/span>Company-Specific Database Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Database_Testing_Interview_Questions_in_Capgemini\"><\/span>Database Testing Interview Questions in Capgemini<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol>\n<li>What challenges do you face when testing data migrations?<\/li>\n\n\n\n<li>How do you verify data integrity in a multi-source database system?<\/li>\n\n\n\n<li>How do you automate database validation using SQL scripts?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Oracle_Testing_Interview_Questions\"><\/span>Oracle Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol>\n<li>What are the components of Oracle&#8217;s physical database structure?<\/li>\n\n\n\n<li>What is the difference between PL\/SQL and SQL?<\/li>\n\n\n\n<li>How do you test Oracle stored procedures and functions?<\/li>\n\n\n\n<li>How do you handle performance tuning in an Oracle database?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cognizant_Database_Testing_Interview_Questions\"><\/span>Cognizant Database Testing Interview Questions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol>\n<li>How do you conduct database testing?<\/li>\n\n\n\n<li>How do you approach testing large-scale databases in an enterprise setup?<\/li>\n\n\n\n<li>What are the key database testing challenges in cloud-based applications?<\/li>\n\n\n\n<li>Which type of Validation you will do at Landing and staging area?<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Wrapping_Up\"><\/span>Wrapping Up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>So, these are the 45+ important database testing interview questions you should prepare for. Whether you are a fresher or an experienced professional, understanding these concepts will help you perform well in interviews.&nbsp;Looking for <a href=\"https:\/\/www.hirist.tech\/k\/database-testing-jobs.html?ref=blog\" target=\"_blank\" rel=\"noreferrer noopener\">database testing jobs<\/a>? Find the top tech opportunities on Hirist, India\u2019s leading <a href=\"https:\/\/www.hirist.tech\/?ref=blog\" target=\"_blank\" rel=\"noreferrer noopener\">job portal for IT<\/a> professionals.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Finding database testing interview questions tricky? You are not alone\u2014many candidates struggle with data integrity,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":5946,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,27,19],"tags":[79,32,34,33,76],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog<\/title>\n<meta name=\"description\" content=\"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog\" \/>\n<meta property=\"og:description\" content=\"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/\" \/>\n<meta property=\"og:site_name\" content=\"Hirist Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hirist.jobs\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-10T07:18:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-29T10:51:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1216\" \/>\n\t<meta property=\"og:image:height\" content=\"832\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"hiristBlog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hiristBlog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/\",\"url\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/\",\"name\":\"Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.hirist.tech\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg\",\"datePublished\":\"2025-03-10T07:18:25+00:00\",\"dateModified\":\"2025-12-29T10:51:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/f40a5a435d73195ec4e424a307b0c26b\"},\"description\":\"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage\",\"url\":\"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg\",\"contentUrl\":\"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg\",\"width\":1216,\"height\":832,\"caption\":\"database testing interview questions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.hirist.tech\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Top 45+ Database Testing Interview Questions and Answers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/#website\",\"url\":\"https:\/\/www.hirist.tech\/blog\/\",\"name\":\"Hirist Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.hirist.tech\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/f40a5a435d73195ec4e424a307b0c26b\",\"name\":\"hiristBlog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1d0fb418cc48cd31b61160060c199240?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1d0fb418cc48cd31b61160060c199240?s=96&d=mm&r=g\",\"caption\":\"hiristBlog\"},\"sameAs\":[\"https:\/\/www.hirist.tech\/blog\"],\"url\":\"https:\/\/www.hirist.tech\/blog\/author\/hiristblog\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog","description":"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/","og_locale":"en_US","og_type":"article","og_title":"Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog","og_description":"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.","og_url":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/","og_site_name":"Hirist Blog","article_publisher":"https:\/\/www.facebook.com\/hirist.jobs","article_published_time":"2025-03-10T07:18:25+00:00","article_modified_time":"2025-12-29T10:51:21+00:00","og_image":[{"width":1216,"height":832,"url":"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg","type":"image\/jpeg"}],"author":"hiristBlog","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hiristBlog","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/","url":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/","name":"Top 45+ Database Testing Interview Questions and Answers (2026) - Hirist Blog","isPartOf":{"@id":"https:\/\/www.hirist.tech\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage"},"image":{"@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg","datePublished":"2025-03-10T07:18:25+00:00","dateModified":"2025-12-29T10:51:21+00:00","author":{"@id":"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/f40a5a435d73195ec4e424a307b0c26b"},"description":"A list of 45+ essential database testing interview questions with answers for experienced SQL testers with SQL queries and DB testing.","breadcrumb":{"@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#primaryimage","url":"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg","contentUrl":"https:\/\/www.hirist.tech\/blog\/wp-content\/uploads\/2025\/03\/database-testing-interview-questions.jpeg","width":1216,"height":832,"caption":"database testing interview questions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hirist.tech\/blog\/top-45-database-testing-interview-questions-and-answers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hirist.tech\/blog\/"},{"@type":"ListItem","position":2,"name":"Top 45+ Database Testing Interview Questions and Answers"}]},{"@type":"WebSite","@id":"https:\/\/www.hirist.tech\/blog\/#website","url":"https:\/\/www.hirist.tech\/blog\/","name":"Hirist Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hirist.tech\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/f40a5a435d73195ec4e424a307b0c26b","name":"hiristBlog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hirist.tech\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1d0fb418cc48cd31b61160060c199240?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d0fb418cc48cd31b61160060c199240?s=96&d=mm&r=g","caption":"hiristBlog"},"sameAs":["https:\/\/www.hirist.tech\/blog"],"url":"https:\/\/www.hirist.tech\/blog\/author\/hiristblog\/"}]}},"_links":{"self":[{"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/posts\/5930"}],"collection":[{"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/comments?post=5930"}],"version-history":[{"count":16,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/posts\/5930\/revisions"}],"predecessor-version":[{"id":6903,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/posts\/5930\/revisions\/6903"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/media\/5946"}],"wp:attachment":[{"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/media?parent=5930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/categories?post=5930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hirist.tech\/blog\/wp-json\/wp\/v2\/tags?post=5930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}