SQL Server Interview Questions - Basic Questions

Create a Table with Constraints

Write a SQL script to create a table named 'Products' with columns for ProductID (primary key), ProductName, and Price.

Expected output: A SQL script that creates the Products table with the specified columns and constraints.

Hint: Use CREATE TABLE and specify PRIMARY KEY constraint.

Write a SELECT Query

Write a SQL query to select all products with a price greater than 100.

Expected output: A SELECT statement that retrieves products where Price > 100.

Hint: Use the WHERE clause with a comparison operator.

A clustered index determines the physical order of data in a table and there can be only one per table. A non-clustered index is a separate structure that points to the data rows and a table can have multiple non-clustered indexes.

Normalization organizes data to reduce redundancy and improve data integrity by dividing large tables into smaller related tables and ensuring logical data dependencies.

Basic SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP.