What are constraints? Explain different types of
constraints?

Answer Posted / manikandan elangovan

Primary key
Foreign Key
Unique Key
Not Null
Check
default

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain various data region available in ssrs with their use?

494


What are the differences between decimal and float in ms sql server?

569


What is partition, how will you implement it? : sql server analysis services, ssas

606


Tell me about joins in database system and explain each in detail.

602


How to create a Master database in SQL server ?

551






How to search for a string in all stored procedure in sql server?

542


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

539


What is lock escalation? : sql server database administration

599


What is 3nf normalization?

568


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

593


What are the types of table?

549


How do I create a trace in sql server?

520


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

559


Can you please explain the difference between primary keys and foreign keys?

660


How to use subqueries in the from clause in ms sql server?

571