Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
SQL Server 2
« Previous
Default is a type of constraint although it does not really enforce anything
Options
- Yes
- No
CORRECT ANSWER : Yes
Discussion Board
Default Constraint
Yes, the default is a type of constraint, although it does not really enforce anything. Default constraints apply a value to a column when an INSERT statement does not specify the value for the column. Although default constraints do not enforce a rule like the other constraints we have seen, they do provide the proper values to keep domain integrity in tact. A default can assign a constant value, the value of a system function, or NULL to a column. You can use a default on any column except IDENTITY columns and columns of type timestamp.
Prajakta Pandit 03-8-2017 02:11 AM
« Previous
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲