Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 138444 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ravi gupta
constraint define rules that must be followed to maintain
consistency and correctness of data.a constraint can either
be created while creating a table or can be added later.
constraint can be divided into the following types:--
(1)primary key constraint.
(2)unique constraint.
(3)foreign key constraint.
(4)check constraint.
(5)default constraint.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Explain what is analysis service repository?
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 is self contained scalar sub query?
Can primary key be null?
Define ACID properties in a Database?
What is report rendering ?
what happens on checkpoint? : Sql server database administration
What is the process of normalization?
What is the difference between char, varchar and nvarchar?
What is the command used to check locks in microsoft sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What are the advantages of stored procedure in sql server?
What is dirty read?
