explain the type of contraints
Answers were Sorted based on User's Feedback
Answer / reva ram sahu
constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / surya
Constraints are used to provide the scope to table data...
they are..
Primary key
unique key
not null
check
foriegn key
default..
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / anand
primary constraint
check constraint
notnull constraint
foreign key constraint
Is This Answer Correct ? | 0 Yes | 1 No |
What is subquery? Explain the properties of a subquery?
Is truncate autocommit?
What is the process of normalization?
What is the architecture of ms sql reporting service?
What are four major operators that can be used to combine conditions on a where clause?
What is normalization and denormalization in sql server?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is the recovery model? List the types of recovery model available in sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What is Index Segmentation ?
What is user defined datatypes and when you should go for them?
What are exact numeric data types in ms sql server?