SQL Default Constraint
6.Value of x?
CREATE TABLE test_default (
x INT DEFAULT 10
);
INSERT INTO test_default(x) VALUES (NULL);
-
A. NULL
-
B. 0
-
C. 10
-
D. Error
NULL
NULL
7.Value of created_on?
CREATE TABLE test_date (
created_on DATE DEFAULT CURRENT_DATE
);
INSERT INTO test_date VALUES ();
-
A. NULL
-
B. Yesterday’s date
-
C. Today’s date
-
D. Error
Today’s date
Today’s date
8.Which clause adds a DEFAULT after table creation?
-
A. MODIFY COLUMN name DEFAULT ‘X’
-
B. CHANGE DEFAULT name TO ‘X’
-
C. ADD DEFAULT TO name
-
D. UPDATE COLUMN DEFAULT
MODIFY COLUMN name DEFAULT ‘X’
MODIFY COLUMN name DEFAULT ‘X’
9.Which SQL assigns default 0 to marks column?
-
A. marks INT DEFAULT 0
-
B. SET marks = 0 DEFAULT
-
C. CREATE marks DEFAULT(0)
-
D. marks DEFAULT TO 0
marks INT DEFAULT 0
marks INT DEFAULT 0
10.What happens if you insert NULL in a column with DEFAULT?
-
A. NULL is inserted
-
B. Default value is used
-
C. Error
-
D. Row is skipped
NULL is inserted
NULL is inserted