I need the answers for the below questions

Posted by Chandru_ra under Sql Server on 4/12/2011 | Points: 10 | Views : 2361 | Status : [Member] | Replies : 7
Dear Friends,

I need the answers for the below questions. give the answer if you know the correct answer.

1.which Statement is true?

A.Both primary key and unique enforce uniqueness of the column on which they are defined.
B.Primary key creates a clustered index on the column,.
C.all the above
D.None of the above

2.what is the difference b/w the where and having Sql clauses?

A.The Where and the Having Clauses are identical
B.The Having sql clause condition(s) is applied to all rows in the result set before the Where clause is applied(if present).The Where clause is used only with Select Sql Statements and specifies a search condition for an aggregate or group.
C.None

3.The Union Sql clause can be used with?

A.The select clause only
B.The Update clause only
C.The Delete clause only
D.The Update and delete clause only
D.

chandru


Responses

Posted by: Radhikalingam on: 4/12/2011 [Member] Starter | Points: 25

Up
0
Down
1.which Statement is true?

A.Both primary key and unique enforce uniqueness of the column on which they are defined.
B.Primary key creates a clustered index on the column,.
C.all the above
D.None of the above

Answer C

2.what is the difference b/w the where and having Sql clauses?

A.The Where and the Having Clauses are identical
B.The Having sql clause condition(s) is applied to all rows in the result set before the Where clause is applied(if present).The Where clause is used only with Select Sql Statements and specifies a search condition for an aggregate or group.
C.None

Answer B

3.The Union Sql clause can be used with?

A.The select clause only
B.The Update clause only
C.The Delete clause only
D.The Update and delete clause only

Answer A

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Radhikalingam on: 4/12/2011 [Member] Starter | Points: 25

Up
0
Down
Sorry. Answer for the 2 nd Question is C.

2.what is the difference b/w the where and having Sql clauses?

A.The Where and the Having Clauses are identical
B.The Having sql clause condition(s) is applied to all rows in the result set before the Where clause is applied(if present).The Where clause is used only with Select Sql Statements and specifies a search condition for an aggregate or group.
C.None

Answer C


Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 6/26/2012 [Member] Starter | Points: 25

Up
0
Down

Answer

C
C
A


Regards


sriram

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muralidosscm on: 7/4/2012 [Member] Starter | Points: 25

Up
0
Down
Answer
1)C
2)C
3)A

Regards
Muralidoss M

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 7/4/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
1.

Statement is not correct always!

B."Primary key creates a clustered index on the column" - Is not correct statement always!. Primary key can be also NonClustered aswell!. PK will be created with Clustered only when that Table doesn't have Clustered Index already on it! otherwise It'll be NonClustered!



Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: saficreator-10970 on: 7/4/2012 [Member] Starter | Points: 25

Up
0
Down
1. Primary key creates a clustered index as default. But primary key can create non-clustered index also if we specified when creating constraint.

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 7/5/2012 [Member] Starter | Points: 25

Up
0
Down
Answer

1. C
2. C
3. A




R D Patel

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response