Q81. What is AUTO_INCREMENT?
Automatically generates sequential unique integers for a column, typically the PRIMARY KEY. ```sql CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50)...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (116 available).
Active:
Tag: dbms ×
Q82. Valid constraints in MySQL?
MySQL supports a complete set of integrity constraints: 1. **`PRIMARY KEY`**: Uniquely identifies each row (implies `NOT NULL` and `UNIQUE`). 2. **`FOREIGN KEY`**: Enforc...
Q83. Which is NOT TRUE about constraints?
Any assertion claiming that **constraints are optional in production** or that **constraints significantly slow down reads** is false. ### Why Constraints Are Vital: - Co...
Q84. NOT NULL constraint?
The **`NOT NULL`** constraint enforces that a column must always contain a valid data value and cannot accept `NULL`: ```sql CREATE TABLE employees ( id INT PRIMARY KEY, ...
Q85. An unique (non-key) field?
To enforce that every value in a non-primary key column is unique, apply the **`UNIQUE`** constraint: ```sql CREATE TABLE users ( id INT PRIMARY KEY, email VARCHAR(255) U...
Q86. What is CHECK constraint?
A **`CHECK`** constraint ensures that all values stored in a column satisfy a specific boolean condition: ```sql CREATE TABLE products ( product_id INT PRIMARY KEY, name ...
Q87. UNIQUE vs PRIMARY KEY?
| PRIMARY KEY | UNIQUE | |-------------|--------| | One per table | Multiple per table | | Cannot be NULL | Usually allows one NULL | | Implicitly indexed | Explicitly in...
Q88. What does DROP TABLE do?
Permanently removes the table definition, all data, indexes, triggers, and constraints. **Cannot be undone** (unless in a transaction that rolls back, in some DBs). ```sq...
Q89. DROP vs TRUNCATE?
While both `DROP` and `TRUNCATE` are DDL operations, their scope is fundamentally different: | Feature | `TRUNCATE TABLE` | `DROP TABLE` | | :--- | :--- | :--- | | **Data...
Q90. Add order_date column to order table?
To add an `order_date` column to an existing table, use `ALTER TABLE ... ADD COLUMN`: ```sql ALTER TABLE `orders` ADD COLUMN order_date DATE NOT NULL DEFAULT (CURRENT_DAT...