What are constraints? Explain different types of
constraints?
Answer Posted / mohib
there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints
| Is This Answer Correct ? | 21 Yes | 58 No |
Post New Answer View All Answers
Why do we partition data?
what is a join and explain different types of joins? : Sql server database administration
How can change procedure in sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How do you rebuild an identity column?
How to execute stored procedure and set temp table in sql server?
Explain the difference between clustered and non-clustered index?
Can you please explain the difference between primary keys and foreign keys?
How to read data in a table with "select" statements?
What are the built in functions in sql server?
What is a rollup clause?
How to provide values to stored procedure parameters in ms sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is star, snowflake and star flake schema? : sql server analysis services, ssas