what is the main difference between constraints(like
primary key etc..)& joins?
- 2 Answers
- 5376 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.
Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain an automatic checkpoint
What is the native system stored procedure to execute a command against all databases?
Can we use pragma autonomous_transaction in trigger?
What are the types of processing and explain each? : sql server analysis services, ssas
What is the Disadvantage of indexed sequential file.
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
how you can get the list of largest tables in a database? : Sql server administration
How to create a ddl trigger using "create trigger" statements?
Define left outer join in sql server joins?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is dimension table? : sql server analysis services, ssas
What are the differences between web role and worker role?
Explain what is it unwise to create wide clustered index keys?
Explain candidate key, alternate key, and composite key?
How to list all user defined functions in the current database?
