Question

What is a default value?

(a) It is a value that automatically creates a primary key

(b) It is a value that cannot be altered during insertion of values in the tuple

(c) It is a value that is initially loaded into the attribute

(d) None of the mentioned

I got this question by my college professor while I was bunking the class.

My query is from SQL Data Types and Schemas in division Intermediate and Advanced Sql of RDBMS

Answer 1

Correct answer is (c) It is a value that is initially loaded into the attribute

For explanation: A default value is a value that is initially loaded into the attribute. All the tuples have the default value in the attribute for which it is specified in case any value is not externally specified.