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