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

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

RAINING TABLETS AND LAPTOPS

It all started with Jayalalitha promising free laptops to students of Tamil Nadu , if they would vote her to power

They did

Now she is busy distributing a million laptops to students – every year

For politicians all over India , this was an eye-opener !

They were quick to realize that it was no more ,

• Roti , Kapada , Makan

• Sadak , Pani , Bijlee

To win elections , they must promise ,

• Tablets and Laptops

Next to adopt this new-age mantra , were

• Akhilesh Yadav ( Uttar Pradesh )

• Prakash Singh Badal ( Punjab )

Lo and Behold !

They too got elected to power !

Only yesterday, Rajasthan Chief Minister Gehlot came out with a promise to distribute free laptops to all students passing 10^th or 12^th standard

And believe me , in a matter of weeks , Modi ( Gujarat ) and Gowda / Yeddy ( Karnataka ) will make similar announcements

Not to be left out , expect Rahul Gandhi to promise , to every single Indian voter ( approx 400 millions ),

·     a Laptop and a Tablet and a Smart phone

if voted to power in 2014 national elections

And, all imported from EuroZone !

Soon India will become the most YouTube-savvy nation in the world !

What does it matter that , due to mal-nutrition , some 2,348 children die in India , every day !

With regards

HEMEN  PAREKH

STATE OF EDUCATION

Times of India (  07,Mar,2012  ) reports :

• Central Teachers Eligibility Test ( CTET ) was held on Jan 29, 2012

• 10,58,000  teachers registered to take the exam

• 900,000  teachers appeared for the exam

• Only 55,422 teachers managed to score the minimum 60 % required to pass the exam  (approx 6 %  passed)

• In last year’s exam , 14 % had passed

• CTET was started by the Government last year to to ensure that the quality of teachers across the country is standardized

Consequence ?

15 year old students from 73 countries took part in PISA [ Programme for International Student Assessment ], conducted by OECD

When tested on their reading , math and science abilities , Indian students stood “ second – to – last “ . So what ? Indian students were ahead of the students from Kyrgyzstan, who stood last !

Students from China’s Shanghai province , which participated in PISA for the first time , scored highest in reading . It also topped the charts in math and science

You are welcome to draw your own conclusion !

With regards

HEMEN  PAREKH