Monday 25 June 2007

INTERVIEW-QUESTIONS

25 June 2007

INTERVIEW-QUESTIONS

AI_FUNCTION_SUBCATEGORY_MAPPER

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
FNAME	varchar	500
SID	numeric	Null
SNAME	varchar	500

AIBASE

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	numeric	Null
FUNCTIONS	varchar	500
FUNCTIONURL	varchar	500
VALIDITY	varchar	1

AIPRIMARYFUNCTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
ID	numeric	Null
FUNCTIONNAME	varchar	500
FUNCTIONURL	varchar	500

AIQUESTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
SID	numeric	Null
TID	numeric	Null
TNAME	varchar	500
QID	numeric	Null
QUESTION	varchar	500
UPDATED	varchar	1

AISECONDRYFUNCTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FUNCTIONID	numeric	Null
FUNCTIONNAME	varchar	500
SUBCATEGORYID	numeric	Null
SUBCATEGORY	varchar	500
SUBCATEGORYURL	varchar	500

AITERTIORYFUNCTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
SID	numeric	Null
SNAME	varchar	500
TERTIORYFNID	numeric	Null
TERTIORYFN	varchar	500
TERTIORYFNURL	varchar	500

DTPROPERTIES

COLUMN_NAME	DATA_TYPE	LENGTH
id	int	Null
objectid	int	Null
property	varchar	64
value	varchar	255
unvalued	nvarchar	255
value	image	2147483647
version	int	Null

GRFUNCTIONLIST

COLUMN_NAME	DATA_TYPE	LENGTH
FUNCTIONID	decimal	Null
FUNCTIONNM	varchar	100
ENTERDT	datetime	Null
COMPANYCD	varchar	10
INUSE	char	1

GRKEYWORDLIST

COLUMN_NAME	DATA_TYPE	LENGTH
KEYWORDNM	varchar	120
COUNTER	decimal	Null

IT-FUNCTIONLIST

COLUMN_NAME	DATA_TYPE	LENGTH
ID	int	Null
FUNCTIONNAME	varchar	500

IT-HIGHLIGHTED-KEYWORDS

COLUMN_NAME	DATA_TYPE	LENGTH
FID	int	Null
KEYWORD	varchar	500
WEIGHT	int	Null

IT-KEYWORDS-EXCEL

COLUMN_NAME	DATA_TYPE	LENGTH
FID	numeric	Null
KEYWORD	varchar	500
WEIGHT	numeric	Null
SELECTED	varchar	1

JOBADVT

COLUMN_NAME	DATA_TYPE	LENGTH
ADVTID	varchar	50
ADVTSOURCE	varchar	50
DESIGNATIONNM	varchar	150
COMPANYNM	varchar	150
CITYNM	varchar	500
MINEXP	numeric	Null
MAXEXP	numeric	Null
LEVELNM	varchar	100
JOBPOSTEDDT	datetime	Null
EMAIL	varchar	100
JOBFULLADVT	text	2147483647
JOBFULLADVTPLAIN	text	2147483647
FUNCTIONID	numeric	Null

JOBDESCERRORS

COLUMN_NAME	DATA_TYPE	LENGTH
ERRORS	varchar	500
TYPE	varchar	50

JOBDESCRIPTION

COLUMN_NAME	DATA_TYPE	LENGTH
JOBID	numeric	Null
JOBMAINTITLE	varchar	500
JOBMAINALTERNATIVE	varchar	500
JOBTITLE	varchar	500
JOBALTERNATIVE	varchar	500
JOBDESC	text	2147483647

MONRESUME

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	decimal	Null
PROCESSID	decimal	Null
EMAILID	varchar	75
RESUMEHTML	text	2147483647
RESUMETEXT	text	2147483647
PROCESSDATE	datetime	Null

RESULTS

COLUMN_NAME	DATA_TYPE	LENGTH
ADVTID	varchar	50
ADVTSOURCE	varchar	50
DESIGNATIONNM	varchar	150
COMPANYNM	varchar	150
CITYNM	varchar	500
MINEXP	decimal	Null
MAXEXP	decimal	Null
LEVELNM	varchar	100
JOBPOSTEDDT	datetime	Null
EMAIL	varchar	100
JOBFULLADVT	text	2147483647
JOBFULLADVTPLAIN	text	2147483647
FUNCTIONID	decimal	Null

SOFTSKILLSMASTER

COLUMN_NAME	DATA_TYPE	LENGTH
ID	int	Null
LINKS	nvarchar	255
NAME	nvarchar	255
SOFTSKILL	nvarchar	1

SOFTSKILLSQUESTIONS

COLUMN_NAME	DATA_TYPE	LENGTH
CATID	smallint	Null
QID	smallint	Null
QUESTION	next	1073741823

Hemen Parekh

Friday 9 March 2007

THE ULTIMATE WINNER

In its election manifesto, Samajwadi Party has promised :

A free tablet for every student passing out of 10^th standard ( ie: approx 5 million students )

A free laptop for every student passing out of 12^th standard ( ie: approx 3.5 milion students )

Yesterday , in a TV interview , Akhilesh Yadav has confirmed that his party will fulfill its promises

Already , Jaylalitha ( AIADMK ) has made a similar promise during last year’s elections in TamilNadu , which brought her to power

By now , TN Govt has already placed orders for Rs 1300 Crore worth of orders on Indian Manufacturers for supply of laptops !

And , to fulfill her promise , she must place similar-size orders every year for the next 4 years , till her term expires

It will be the same in UP for the next 5 years

I believe , Prakash Singh Badal who just won the state elections in Punjab has made similar promise – and he would not want to be accused of not having kept his promise when 2017 elections arrive !

No doubt , Gouda in Karnataka and Modi in Gujarat , who face State elections in a few months , will want to capitalize on this “ winning formula “

Before long , 50 million Indian students will be getting tablets / laptops , every year !

So , who is the ultimate winner in elections ?

Without doubt , the computer manufacturers !

With regards

HEMEN PAREKH