I need the answers for the below questions

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

0	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

0	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

0	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

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

0	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

0	Answer 1. C 2. C 3. A R D Patel Chandru_ra, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts