CREATE TABLE [candidate_details] (
	[candidate_ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[dob] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[mobile] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[email] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	CONSTRAINT [PK_candidate_details] PRIMARY KEY  CLUSTERED 
	(
		[candidate_ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

INSERT INTO [dbo].[candidate_details]([name], [dob], [mobile], [email])
VALUES('Alex', '03/26/1970', '9876567898', 'alex@example.com')
VALUES('John', '12/24/1987', '9876567896', 'john@gmail.com')
VALUES('Sinha', '06/06/1980', '9877297783', 'sinha@yahoo.com')
VALUES('Alex', '09/21/1980', '9836829829', 'alex@example.com')

, CONSTRAINT [UNQ_name_email] UNIQUE (
			[mobile]
			, [email]
			)

		, CONSTRAINT [UNQ_dob_email] UNIQUE (
			[dob]
			, [email]
			)

		, CONSTRAINT [UNQ_dob_name] UNIQUE (
			[dob]
			, [name]
			)

		, CONSTRAINT [UNQ_dob_name_email] UNIQUE (
			[dob]
			, [name]
			, [email]
			)