Scriptimiz

SQL Default Constraint

1.What does the DEFAULT constraint do?

2.What will country be?

CREATE TABLE customers (
  name VARCHAR(50),
  country VARCHAR(50) DEFAULT 'India'
);

INSERT INTO customers(name) VALUES ('Rahul');

3.Which of these defines a default value correctly?

4.When is the default value used?

5.What will be the output of the given code?

CREATE TABLE orders (
  id INT,
  status VARCHAR(10) DEFAULT 'Pending'
);

INSERT INTO orders(id, status) VALUES (1, 'Shipped');