Interview Questions And Answers

SELECT CONVERT(char, DATABASEPROPERTYEX('MyDatabase','collation'))

YES

This catalog SP returns objects of type: Tables and Views. This includes system tables as well.

Data represented by creating DataContract which expose the
data which will be transefered /consumend from the serive
to its clients.

**Operations which is the functions provided by this
service.

To write an operation on WCF,you have to write it as an
interface,This interface contains the "Signature" of the
methods tagged by ServiceContract attribute,and all methods
signature will be impelemtned on this interface tagged with
OperationContract attribute.

and to implement these serivce contract you have to create
a class which implement the interface and the actual
implementation will be on that class.


Code Below show How to create a Service Contract:

[ServiceContract]
Public Interface IEmpOperations
{
[OperationContract]
Decimal Get EmpSal(int EmpId);

}

Class MyEmp: IEmpOperations
{
Decimal Get EmpSal()
{
// Implementation of this method.
}
}

Hope now you can differentiate between Data
Contract,Service Contract and OperationContract.

I will explain you this with an Example.


CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)
GO

INSERT INTO dbo.TEST (ROWID) VALUES (NEWID())
GO 1000


Note Second Go 1000. This will insert 1000 row to table test.

A primary key is a column which uniquely identifies the
records in a table. In a broad sense, a primary key is the
mixture of a unique key and an index: A collumn with a primary
key is indexed to deliver a faster query, and doesn't allow
duplicate values to ensure specific data.

A foreign key is a column (the child collumn) in a table which
has a corresponding relationship and a dependency on another
collumn (the parent collumn) that is usually in a different
table. Parent collumns can have multiple child collumns, but a
child collumn can only have one parent collumn.

Primary key does't allow null value
while foreign key allow null value

I will explain you this with an Example.


CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)
GO

INSERT INTO dbo.TEST (ROWID) VALUES (NEWID())
GO 1000


Note Second Go 1000. This will insert 1000 row to table test.

The metadata API service has been extended to retrieve language information in MSCRM4.0.

Multiple organizations can now be hosted and WSDL APIs are now unique per organization in MSCRM4.0.

Plug-ins (callouts) and workflow now use the same event framework, allowing for even more extensibility.

The SDK has been expanded to include offline access.

Now we can programmatically create, read, update and delete the metadata such as entities, attributes and relationship.

There are three services instead of two which we used to have in previous version

Many to Many Relationship was not available in MSCRM3.0

Multicurrency feature was not available in MSCRM3.0

I will explain you this with an Example.


CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)
GO

INSERT INTO dbo.TEST (ROWID) VALUES (NEWID())
GO 1000


Note Second Go 1000. This will insert 1000 row to table test.

I will explain you this with an Example.


CREATE TABLE dbo.TEST (ID INT IDENTITY (1,1), ROWID uniqueidentifier)
GO

INSERT INTO dbo.TEST (ROWID) VALUES (NEWID())
GO 1000


Note Second Go 1000. This will insert 1000 row to table test.