Please Help me

[rama82]

Hi

All

Please give the answer of the following questions.

1. what is the difference between primary key and unique key.
2. what is the difference between cluser and noncluser index.
3. what is the difference between CTS AND CLS.
4. What is the difference between exe and dll.
5. How to create dll of my complete project.

Thanks & Regards
Ramashish Kumar

[kunal pawar]

1. what is the difference between primary key and unique key.

Primary Key: A column in a table whose values uniquely identify the rows in the table. A primary key value cannot be NULL.

Unique Key: Unique Keys are used to uniquely identify each row in an Oracle table. There can be one and only one row for each unique key value.


2. what is the difference between cluser and noncluser index.

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.



3. what is the difference between CTS AND CLS.

CTS having all data type,object that clr want at runtime to check data type.cls is subset of cTs is for integrtion of all languages.ie when u use classes in two languages it help u to inet\rmixed using cts .The purpose of the CLS is to provide robust interoperabilit y between .NET languages, including the ability to inherit classes written in one .NET language in any other .NET language and cross-language debugging

4. What is the difference between exe and dll.
EXE - An assembly with an entry point is called as an EXE file.

DLL - An assembly without entry point is called as an DLL file

5. How to create dll of my complete project.
when u build u program it will create dll file

[Plater]

While kunal pawar was nice enough to answer your questions, there was a number of things wrong.
1) That sounds like an assignment, which we are not supposed to answer as its against site rules.
2) None of those questions were releated to .NET specifically. They were SQL suestions and then software developement questions.
4) The title of the thread was very unhelpful to identifying the subject matter of the question
3) All of which would have been very easily answered with the magic site called google

I will be moving this thread to more appropriate section, as soon as I decide which one that is.


MODERATOR