Computer Science, asked by rupesh1388, 1 year ago

what do you understand by the term default value of a field in base​

Answers

Answered by riya2280
3

Techopedia explains Default Values - Database

When creating a database table in systems such as Oracle or SQL Server, an option to specify a default value is available. This separates database design issues from the front-end application. For instance, if a bank's interest rate for the current financial year is 8 percent, this may be set as the default value. This relieves the user from having to enter it repeatedly into the database. Most databases use the keyword “default” as a data type. Modification to a default data type can be changed by using the ALTER TABLE command. When a new row is created with vacant column data type, it is filled with default values. For example, the “Date” column in most cases has a default data type as the “CURRENT DATE.”

Answered by sunitach2981
1

The value which remains same.

For ex- Destination of students can be same in students record, so we can set a default value.

For ex: destination of students is Delhi.

So here default value is Delhi.

We can't have to write one by one, we can use this for writing all destinations...

Similar questions