Database Technical Interview Questions
- Why is a UNION ALL faster than a UNION? - What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually? - What are three rules of thumb to create good passw...
Here are some of the Microsoft SQL Server developer interview questions: Which of the following has the highest order of precedence? Functions and Parenthesis Multiplication, Division and Exponents Ad...
1 How do you show the currently running queries? - SHOW FULL PROCESSLIST; 2. How do you kill a MySQL query? - See the ID of it from the question above, then KILL id. You can separate multiple IDs by s...
Normalization organizes relational data to reduce unnecessary duplication and update anomalies. For example, storing a customer’s address once avoids inconsistent edits across many order rows when the...
Many replication designs apply changes to replicas asynchronously, so a committed primary write may not yet be visible there. A user who creates a record and immediately reads from a replica can see a...
A primary key identifies each row and is non-NULL. A foreign key enforces an allowed relationship to a referenced key, helping prevent orphaned data. A unique constraint prevents duplicate combination...
Create students and courses tables plus an enrollment table containing foreign keys to both. Add a primary key or unique constraint on the student-course pair if only one enrollment is permitted. Attr...
Restore it into an isolated environment with compatible software and required encryption keys, then check structural integrity and important application-level invariants. Verify expected tables, repre...
Start with data relationships, transaction boundaries, integrity requirements, query patterns, and operational skills. Relational storage often fits strongly related entities and cross-entity constrai...
Test your aptitude, quantitative reasoning, and core programming skills under timed conditions.
Start Placement Test