what is the main difference between constraints(like primary key etc..)&a

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

what is the main difference between constraints(like 
primary key etc..)& joins?

Question Submitted By :: Amit

I also faced this Question!!

Rank

Answer Posted By

Re: what is the main difference between constraints(like primary key etc..)& joins?

Answer
# 1

Constraints are the mechanisms used by the sql server to 
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or 
more tables.

Is This Answer Correct ?

0 Yes

0 No

Ravikiran

Re: what is the main difference between constraints(like primary key etc..)& joins?

Answer
# 2

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 ?

1 Yes

0 No

Monal

Question	Asked @	Answers
Other SQL Server Interview Questions


Explain DBMS, RDBMS?		4
What is the difference between SSAS 2000 and SSAS 2005?	APX	1
What is Deadlock?	Satyam	2
wat is the main diff between sql server 2000and sql server 2005	Jade-Software	4
how to know Who Is Blocking Your SQL Server?		2
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.	Satyam	3
What is mean by "fill factor" ? and what is mean by "Index "in sql?	Logica-CMG	1
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.		7
what is advantages in sql 2005 over sql 2000?		1
What is a Join in SQL Server?		1
What is a materialized view?		2
what are file groups?	Evalueserve	3
When do you create cluster and noncluster index?	Satyam	4
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?		2
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?	Microsoft	4
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005		1
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?		2
What is referential integrity? What are the advantages of it?	Digital-Domain	2
Can you link only other SQL Servers or any database servers such as Oracle?		1
WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT		8

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com